I have a 2 tables, which look like this:  Table 1: personal  | uid      |      city     | |----------|:-------------:| | 1        |  Zurich       | | 2        |  Chicago      | | 3        |  London       |   Table 2: technologies  | uid      |      tech     | |----------|:-------------:| | 2        |  HTML         | | 2        |  JavaScript   | | 2        |  PHP          |   The query that I use:  SELECT DISTINCT personal.city, technologies.tech FROM personal INNER JOIN technologies ON personal.uid = 2   The result:  | Chicago      |  HTML         | | Chicago      |  JavaScript   | | Chicago      |  PHP          |   As you see, I receive 3 records. My goal is to receive only 1 record. So the strings (HTML, JavaScript, PHP) should be either in an array (if that's possible) or they should be separated by a semicolon.
I need to run a query like:  SELECT p.id, p.name,         (SELECT name            FROM sites s           WHERE s.id = p.site_id) AS site_list   FROM publications p   But I'd like the sub-select to return a comma separated list, instead of a column of data.  Is this even possible, and if so, how?
dynamically change UIKeyboards return key Is it standard for graduate students to get gifts for their advisors? Is it standard for graduate students to give their advisors gifts around Christmas, like chocolates or bottles of wine?  What about other important people, such as their thesis committee members, or department secretaries? In my question's preview, the attached image looks rotated. So, assuming you are able to see it in the real orientation, can anyone determine what is that dust flake type thing on the top, slightly towards the left?   One looks like a dust flake and there's another dot to the left of it?  Note: I wont have physical access to the camera until the weekend.  Is it just a dust flake on the lens or can it be some problem with the sensor? Its a 3 month old Canon 1500D. I've always had a LOST.DIR folder on my external SD card, which until now has been empty.  Today my phone complained that my SD card was damaged and wouldn't mount it, so I pulled it out and looked at it on my computer.  There's now a 70237 file inside LOST.DIR which is 128 MB.  It starts with something like "&euml;&lt;MSWIN4.1", seemingly to indicate that it's a dump of a  (which makes no sense).  What did Android dump here and and why?  (I think I may have disconnected my phone from my PC yesterday without ejecting the drives first, so that might be the "why", though it was from Windows XP and not Windows 98.)  Is there a simple way to recover the information in this file? SSH and home directory permissions "A mice problem" vs. "a mouse problem" Why does an object with a glossy shader render in black? When I apply a glossy shader to the material of my text, the text becomes just black. Why?    I have lamp and everything, but the problem persists. The text is red before I add the glossy shader.  I'm using Cycles render.   Thanks! A short story I read long ago about the phone system 'waking up' During my studying to integration I find this integration.  So I tried to prove but I got stuk.  So I need help in this integration.  $$\displaystyle\int_{-\infty}^{\infty} \frac{x \sin (x)}{1+x^2}  dx = \frac {\pi}{e} $$ Do we need inertial frames in Lagrangian mechanics? Proof that total derivative is the only function that can be added to Lagrangian without changing the EOM So I was reading this:  and while the answers for the first question are good, nobody gave much attention to the second one. In fact, people only said that it can be proved without giving any proof or any.  So, if I have a Lagrangian and ADD an arbitrary function of $\dot{q}$, $q$ and $t$ in such a way that the equations of motion are the same, does this extra function MUST be a total time derivative?   EDIT Ok, I changed my question a little bit:  Question: If I have a function that obeys the Euler-Lagrange equation off-shell, this implies that my function is a time derivative? (This was used in Qmechanic's answer of this other question: , equation 14.)  Also, why people only talk about things that change the Lagrangian only by a total derivative? If this is not always the case that keeps the equation of motion the same, so why is it so important? And why in the two questions I posted about the same statement on Landau&amp;Lifshitz's mechanics book only consider this kind of change in the Lagrangian? A story where technology is forbidden, but used by priests I am looking for a story I remember reading in the mid-90s. I can't remember if it was a trilogy or just a three part book, but I know it was in paperback book form. I also know it was found in the Young Adult section of the library at that time.  The general premise was that there had been some sort of war in the past and machines were outlawed. People visited priests who used magic. I remember that the main character discovers that the priest aren't using magic but are actually using machines.  I can also remember the main character ends up leaving the nation he is in and ends up in a neighboring nation where machines are allowed. I remember there being a scene where he watches a "movie" which I think was more like an old fashioned moving picture.  For some reason I keep wanting to tie this whole thing back to a sword, or blue sword, or something like that, but I might be mixing stories. Other things I keep linking to it: the character was in training to be a priest, he was forced to leave, he ended up using the neighboring nation to conquer his homeland. Again, still not sure if I am mixing things but they keep popping up.  I do know that it is not The Blue Sword by Robin McKinley, or its prequel, The Hero and the Crown. Can't boot without Flash Drive plugged in I had Ubuntu 12.04 Beta installed on my computer. When 12.04 was finally released, I made a bootable USB Flash Drive using Startup Disk Creator.  Then I decided to check if this drive works properly and to reinstall the system on my desktop. I must add, my desktop behaves a bit strange when it comes to bootable USB's, it recognizes them as HDD.  In BIOS I changed priority of boot so USB Flash Drive (recognized as HDD) was first. Successfully booted, I installed Ubuntu. Everything worked fine, but...  Now I cannot boot from my real HDD. Every time I want to boot, I put the USB Flash Drive into my computer, boot, safely remove it and everything works.  What do I need to do to repair boot? Proving the identity $\sum_{k=1}^n {k^3} = \big(\sum_{k=1}^n k\big)^2$ without induction I recently proved that  $$\sum_{k=1}^n k^3 = \left(\sum_{k=1}^n k \right)^2$$  using mathematical induction.  I'm interested if there's an intuitive explanation, or even a combinatorial interpretation of this property. I would also like to see any other proofs. If you look at this product:    you can clearly see that it is a DVD+R, i.e. once it is written, it cannot be erased/rewritten.  Then what does the "RW" logo (in the lower right corner) mean? I thought it stood for ReWritable, but experimenting with the medium shows that it is not. Change name on the main Stack Exchange profile Why is accuracy not the best measure for assessing classification models? Submodule of free module over a p.i.d. is free even when the module is not finitely generated? Best practices for Feed restructuring in a social app database Where did newtonian size setting go in 2.79a