I would like to display a &lt;table&gt; with these &lt;th&gt;-s: project title description status start date end date users  The problem is, that my subquery returns more than 1 row. Usually 4 people belong to a project, an owner, a manager, a developer and a tester. The owner can create new projects, so he can see the project table I would like to create, but I can't put the users at the end of the table, because more than one belongs to every row.   This is the query:  SELECT project.id, title, description, status, start,end         FROM project          LEFT JOIN users ON (SELECT userid FROM roles,project WHERE projectid=project.id)=users.id   My tables are:  PROJECT id title description status start end  USERS id name pass email  ROLES id projectid userid rolename
Using MySQL, I can do something like:  SELECT hobbies FROM peoples_hobbies WHERE person_id = 5;   My Output:  shopping fishing coding   but instead I just want 1 row, 1 col:  Expected Output:  shopping, fishing, coding   The reason is that I'm selecting multiple values from multiple tables, and after all the joins I've got a lot more rows than I'd like.  I've looked for a function on  and it doesn't look like the CONCAT or CONCAT_WS functions accept result sets.  So does anyone here know how to do this?
Automatically put PGFPlots xtick scale label in x axis label How can I move or force a program installation to another location, even when unsupported? I have an SSD as my main Windows drive, with a 640GB 2.5" HDD, partitioned to store programs and user settings, and also to act as backup (it's the only thing I had lying around at the time of building my PC).  The problem is that whenever I install a program, it installs to C:\Program Files [(x86 for the 32 bit programs]\, although I have changed the environment variables. This wouldn't normally be an issue, however every installation program points its shortcut to my 640GB HDD.  The root layout of both drives:   To clarify:   Program files get installed to C:\ Program shortcuts are always pointed to Z:\, my 640GB HDD   Modifying the relevant environment variables doesn't do anything, I looked at , but however it only talks about modifying the registry and environment variables, which I have already done so.  I install to the Z:\ drive if the installation program lets me change the installation path, but however the installation programs sometimes don't let me change this.  Is there a way that I can force every program to install to the relevant location on Z:\, but at the same time move any programs currently installed to the new location? Perhaps I'm missing something here?  My target is to have every program installed on Z:/, with only the core Windows operating system on C:/.  Found ; would it be appropriate to use in my case? I would be able to move the entire Program Files (and its x86 version) to Z:\, without impacting on the performance.* What is JavaScript's highest integer value that a number can go to without losing precision? Is this defined by the language? Is there a defined maximum? Is it different in different browsers? I want to fill a part of a picture with more or less evenly and randomly distributed circles which should not overlap. It would be okay if circles are only partly inside the shape.  The density should be like what you see on this page  with values 80-100. (But I do not need so many circles, 30 should be enough, I could repeat the pattern).   I cannot use a grid and "wobble" the circles a bit: The circles are too large and it simply does not look randomly.   Currently I am thinking about a random attempt: Get some random point, measure its distance to existing circles, either paint or throw the point away. Try 100 times and hope that you get the right number of circles (and that it does not take too long). But perhaps someone has a better idea.   The example draws the circles simply manually:  \documentclass{article} \usepackage{tikz} \usetikzlibrary{backgrounds} \begin{document}   \begin{tikzpicture}[framed,gridded,radius=0.5cm]  \draw[red](0,0) rectangle (5,5);   \draw (1,1) circle;   \draw (2.3,1.1) circle ;   \draw (4.5,0.8) circle ;   \draw (5.1,1.8) circle ;   \draw (0.4,3.3) circle ;   \draw (2.1,2.8) circle ;   \draw (3.8,3.5) circle ;   \draw (4.8,4.2) circle ;   \draw (0.8,4.9) circle ;   \draw (2.1,4.1) circle ;   \draw (3.8,2.0) circle ;   \draw (3.5,0.6) circle ;   \draw (3.0,5.0) circle ;      \draw (4.1,5.1) circle ;             \draw (0.9,2.1) circle ;  \end{tikzpicture}  \end{document} I'd like to do it in Python. What I'd like to do in this example in C: #include &lt;stdio.h&gt;  int main() {     int i;     for (i=0; i&lt;10; i++) printf(&quot;.&quot;);     return 0; }  Output: ..........  In Python: &gt;&gt;&gt; for i in range(10): print('.') . . . . . . . . . . &gt;&gt;&gt; print('.', '.', '.', '.', '.', '.', '.', '.', '.', '.') . . . . . . . . . .  In Python print will add a \n or space, how can I avoid that? Now, it's just an example, don't tell me I can first build a string then print it. I'd like to know how to &quot;append&quot; strings to stdout. One problem I have found when learning calculus is that there are many different ways to denote the derivative. If $y=f(x)=x^2$, then we could write \begin{align} f'(x)&amp;=2x \\ y'&amp;=2x \\ \frac{df}{dx}(x)&amp;=2x \\ \frac{df(x)}{dx}&amp;=2x \\ \frac{d}{dx}f(x)&amp;=2x \\ \frac{dy}{dx}&amp;=2x \end{align} And this is just Lagrange and Leibniz's notations alone. What I find troubling is that they all seem to be suggesting subtly different things about what the derivative actually is. Is it a function, a limit of a quotient, or both? In the interests of keeping my post brief, I'll focus my attention on $f'(x)=2x$ and $\frac{dy}{dx}=2x$, as these seem to be the most common notations.  $$ f'(x)=2x $$  It does make sense to think of the derivative as the gradient function: $$ f'\colon x\mapsto\lim_{\Delta x \to 0}\frac{f(x+\Delta x)-f(x)}{\Delta x} $$ In this case the limit expression is equal to $2x$, and so we can write $$ f' \colon x \mapsto 2x $$ However, this notation seems a little counter-intuitive when we consider what it means to differentiate a function with respect to a variable other than $x$. If I ask what is the derivative of $f(x)$ with respect to $\frac{x}{2}$, does this question make sense? Is it simply $f'(\frac{x}{2})$? Or do we have to express $x^2$ in terms of $\frac{x}{2}$? And how can we can express this derivative using Lagrange's notation?  $$ \frac{dy}{dx}=2x $$  There are many things which are nice about Leibniz's notation, including the fact that it is explicit which variable you are differentiating with respect to. However, in this case, it is unclear whether we are talking about a function, or something else entirely. There are other issues. Some people say they dislike the Leibniz formulation of the chain rule $$ \frac{dy}{dx}=\frac{dy}{du}\frac{du}{dx} $$ saying that they find it to be inaccurate. I don't really understand why this is the case. Could someone please elaborate? Height of an HTML select box (dropdown) Need a proofreading why all the units are satisfied $a^2-2b^2 =\pm1$ for $\mathbf{Z}[\sqrt{2}]$ All the units are satisfied Pell's equation $a^2-2b^2=\pm1$  for $\mathbf{Z}[\sqrt{2}]$, $a,b\in\mathbf{Z}$.  Here is my proof:  Let $a+b\sqrt{2}$ be a unit $\in\mathbf{Z}[\sqrt{2}]$. This implies $$(a+b\sqrt{2})(c+d\sqrt{2})=1, c+d\sqrt{2}\in\mathbf{Z}\sqrt{2}$$ $$\implies \mathrm{norm}((a+b\sqrt{2})(c+d\sqrt{2}))=1$$ $$\implies \mathrm{norm}(a+b\sqrt{2})\cdot \mathrm{norm}(c+d\sqrt{2})=1$$ $$\implies (a+b\sqrt{2})(a-b\sqrt{2})(c+d\sqrt{2})(c-d\sqrt{2})=1$$ $$\implies (a^2-2b^2)(c^2-2d^2)=1$$ $$\implies \left[ a^2-2b^2=1\text{ and } {c}^2-2{d}^2=1\right]\text{ or } \left[ a^2-2{b}^2=-1\text{ and }{c}^2-2{d}^2=-1\right]$$ $$\implies {a}^2-2{b}^2=\pm1$$ How to overlay images I want to overlay one image with another using CSS. An example of this is the first image (the background if you like) will be a thumbnail link of a product, with the link opening a lightbox / popup showing a larger version of the image.   On top of this linked image I would like an image of a magnifying glass, to show people that the image can be clicked to enlarge it (apparently this isn't obvious without the magnifying glass). How to create Custom Fields on Standard Objects in the package.xml Recently, I accidentally deleted a partition off of my external hard disk. I had a copy of Minitool Power Data Recovery left over when the same drive had become RAW about a year ago. When I selected lost partition recovery, it immediately identified my deleted partition and allowed me to access and recover the files that were there.  My question is this. Is there any way to change the deleted partition back to NTFS without having to have a drive that you need to recover the files to and then move them back after formatting, as I don’t have any space left on either the computer or on my other external hard drive, so that I don’t need to buy a new one. The files on the disk were really important.  I am using Windows 7 Home Premium.  I appreciate any help in solving this crisis. How do we use drupal_add_library(), drupal_add_css() and drupal_add_js()? How do I use drupal_add_library(), drupal_add_css() and drupal_add_js() in Drupal 8?  I am porting a module that uses those functions. I am following what reported in , which says these functions have been removed in favor of #attached, but I am not able to attach these files to my configuration page.  The error I am getting is the following:     Uncaught PHP Exception LogicException: "You are not allowed to use js in #attached"   How do I attach CSS and JavaScript to a page? Impossible to hide navigation bars in Safari iOS 7 for iPhone/iPod touch Proof that a sequence is convergent I'm asked to prove the convergence of the sequence $$X_n=\left(1+\frac12\right)\left(1+\frac14\right)\left(1+\frac18\right)\cdots\left(1+\frac{1}{2^n}\right)$$   I proved that it is increasing through the ratio test and then I want to prove that it is bounded.  My question is the following : is it enough to say that $X_n&lt;\left(\frac32\right)^n$ for $n&gt;1$ or not ? Namely, can we say that a sequence is bounded if $\forall$  $n$ ,  $\exists$ a $N$ such that $X_n&lt;N$ or do I have to find a N such that $\forall$  $n$ , $X_n&lt;N$?  In other words, can a bound depend on $n$ ?  Thanks for your help. How do I delete a Git branch locally and remotely? Cannot see OpenLayers under Plugin in QGIS? Although I have installed the OpenLayers plugin in QGIS 2.4, I cannot see it in the list when I click on Plugins.    Does anyone else have this issue? Is time dilation an illusion? Frequency of the sound when blowing in a bottle I need to factory reset my Macbook but cannot recall the password. So I used Cmd+R during startup and go to terminal and typed 'resetpassword' according to this advice    Now 'Reset Password' application appears but there is nothing where I have to select the volume containing the user account. Why does this happen? Which livestock is the most efficient food source?