DB rows need to take in columns
How can I return pivot table output in MySQL?
Children's bike problem with back wheel My daughter has sparkle and glitz 12 inch bike with stabilizers (training wheels). Since we purchased the bike every now and again the back wheel keeps spinning when she is pedaling. This seems to happen more when there is a bit of an incline.  Any suggestions what problem could be? NSWindow Mac App Store like Title Bar What's in an Eclipse .classpath/.project file? GZip of drive image created by using `dd` command I created yesterday a drive image using GZip.  I opened the 51.3 GiB file named ssd.img.gz to see one icon thats a package of 3.9 GiB, yes, thats THree point Nine Gigabytes in size and has the name of the image as ssd.img  That does not seem right to me, has the image creation worked or not?  Yes the drives have data and an operating system on it.  Should I have used cat instead? only I did and it kept on saying that it had nothing to do.  Would using the | zip instead be a better option?    ** EDIT **  The command used was:  mark@zotac:~$ sudo -l Enter password:&lt;entered password to get in to root&gt; root@zotac:~# dd if=/dev/sda | gzip -c &gt; "/media/mark/Seagate External Drive/ssd.img.gz   the terminal spent the best part of 10 Hours at building the image, something in itself that I also found suspect, why so log when copying the files to a folder that I wanted, some 40GiB took 45 minutes...  The source drive /dev/sda had no mounted partitions.     ** EDIT **  Just to clarify, I am trying to make an image of the drive to back up later if things go wrong with a repair, the drive itself needs to be a file on a drive as the target drive partition is using almost all of the drive, the partitions can't be resized on it without formatting it and I am not about to lose 1.4TB of data.   So the dd if=/dev/sda of=/&lt;target&gt; isn't what I need, what I do need is an image of the drive that I can restore the image from to the drive should the repair go wrong.  So what command do I use, dd or cat? Why does | zip keep telling me it has nothing to do when used with cat but no error or warning with dd Is there a destructor for Java? There is a possibility for our universe to be the surface volume of a (higher-dimensional) hyperspace. So if this possibility is true,then is there also a possibility that the other galaxies we see are our own galaxy after light has completed revolution around the three dimensional boundary (surface volume).  Know that we see different shapes for different galaxies.This can be perhaps due to other reasons like-   distance light travelled, the angle through which we look to see the other galaxy (possibly Milky Way) after     it made any number of revolutions, the part of the other galaxy (possibly Milky Way) which we see,and some other properties of light and space.   Only our Milky Way galaxy is just one possibility  Another possibilities are the number of galaxies are far less than we see because we see the same galaxy several times due to curved space.  Any possibilities for the above statements to be true? Auto delete spam email from a domain in Gmail How to turn off chrome's annoying auto-fill? What items are mutually exclusive between worlds? As of 1.2, some features are mutually exclusive between worlds.  In the case of ores at least, .  However, a  gives you the chance for a  (and the upgraded Sweetheart Necklace) which does not seem to have an equivalent version in the Corruption.    What items, if any, are truly mutually exclusive in function between worlds? How to print variables without spaces between values Does causation imply correlation? Correlation does not imply causation, as there could be many explanations for the correlation. But does causation imply correlation? Intuitively, I would think that the presence of causation means there is necessarily some correlation. But my intuition has not always served me well in statistics. Does causation imply correlation? According to some grammars[1][2] and CMS...  "Interjections and vocative should be separated from the rest of the sentence by commas".  The vocative case [1] is used to indicate direct address (i.e., to show when you are talking to somebody or something directly). Nouns in the vocative case are set off using commas. CMS 6.38  As direct address (i.e. vocative case), the parenthetical element should be set off using commas (CMS 6.30). An absolute phrase is always treated as a parenthetical element, as is an interjection.  So,      Hello, world!   That is a very classical way to hello the world.  But, languages change. I am not sure, but today, I feel that it is very uncommon helloing someone with an interjection, providing a small pause and clarifying who is helloed. I have an impression that usually people use hello as a ("kind of") verb, not an interjection.   Question: Is that just a personal (bad) impression or some linguistic has already studied that phenomenon?     [1] - Nelson, Gerald C., Director Survey of English Usage Sidney Greenbaum, and Sidney Greenbaum. An Introduction to English Grammar. Routledge, 2013. [2] - Advanced Grammar in Use with Answers: A Self-Study Reference and Practice Book for Advanced Learners of English. 3 edition. Cambridge University Press, 2013. CMS - Chicago Manual of Style How can I download an older version of Xcode? I am trying to download Xcode from the App Store, but it says that I have to have a newer version of macOS. But I don't have enough space on my computer to upgrade. Its like 8 gigs or something like that and if I only could download Xcode that was compatible with macOS Sierra that would be nice. I'm trying to currently rename a large set of files and have been using quite kludgy methods to do so, such as:  rename 's:(.*)\.MOV:$1.mov:g' *.MOV rename 's:(.*)\.JPG:$1.jpg:g' *.JPG   What I'd really like to do is to be able to combine all of these commands using the . Evidently, using this operator, you can transform items to lower case. The problem is that I need to convert only the extensions. Is there a way to do this using this command? I need to essentially transform the capture group in the following expression to lowercase: ^.+\.(.+)$. Is there a way to do this? I'm kind of new to these kinds of transformations. How do I color intersection of two ellipses in different color. For instances, the ellipses should themselves be colored as yellow and their intersection as red. My code for drawing ellipses is given below  \draw (-4,0) ellipse (8 and 3); \draw (8,0) ellipse (8 and 3);   UPDATE: In the comments to individual answers, I have requested to show it for three ellipses. For a Google account, you are allowed to sync Contacts and People details. What is the difference between these two? Attempt to de-reference a null object: Trigger There were custom validation error(s) encountered while saving the affected record(s). The first validation error encountered was:      Apex trigger updatequotestatus caused an unexpected exception, contact your administrator: updatequotestatus: execution of AfterInsert caused by: System.NullPointerException: Attempt to de-reference a null object: Trigger.updatequotestatus line 5, column 1.   Error Occured at Line:     if((t.what.getsobjecttype() == quote__c.sobjecttype) &amp;&amp; (t.subject.substring(0,5) == 'Email')  trigger updatequotestatus on task (after insert, after update){     Set&lt;Id&gt; quoteIds = new Set&lt;Id&gt;();     List&lt;quote__c&gt; quotes = new List&lt;quote__c&gt;();      for(task t:trigger.new){         if(t.whatId!=null){             if((t.what.getsobjecttype() == quote__c.sobjecttype) &amp;&amp; (t.subject.substring(0,5) == 'Email')){                 quoteIds.add(t.whatId);             }         }     }      for(quote__c q:[select StageName__c from quote__c where Id IN : quoteIds]){         quote__c qt = new quote__c();         qt.Id = q.Id;         qt.StageName__c = 'Proposal Sent';         quotes.add(qt);     }      if(quotes.size()&gt;0){         update quotes;     } } Forcing a SimpleXML Object to a string, regardless of context Let's say I have some XML like this  &lt;channel&gt;   &lt;item&gt;     &lt;title&gt;This is title 1&lt;/title&gt;   &lt;/item&gt; &lt;/channel&gt;   The code below does what I want in that it outputs the title as a string  $xml = simplexml_load_string($xmlstring); echo $xml-&gt;channel-&gt;item-&gt;title;   Here's my problem.  The code below doesn't treat the title as a string in that context so I end up with a SimpleXML object in the array instead of a string.  $foo = array( $xml-&gt;channel-&gt;item-&gt;title );   I've been working around it like this  $foo = array( sprintf("%s",$xml-&gt;channel-&gt;item-&gt;title) );   but that seems ugly.  What's the best way to force a SimpleXML object to a string, regardless of context? What happens if I use RAM of a faster speed than the CPU supports? Does one need a visa to transfer between two airports during a transit through the Schengen area? I am an Indian citizen travelling from New York to Delhi with a layover in Paris where I need to transfer between Paris Orly Airport (ORY) and Paris Charles de Gaulle Airport (CDG).  Do I need to have a visa to make this transfer?  I didn't notice that while booking the ticket.