I am using a query to output a result into CSV file. the query is   select distinct FirstName,LastName,Company,State,Email1,Email2,contact_number,Cellphone,Cellphone2 into outfile '/tmp/prudential.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' From person;   is there a way where I can get Headers of the columns as-well in the CSV file.
In MySql's interpreter, it's very easy to dump a table to the screen along with its field names.   There seems to be no simple way to export a table to a tab-delimted or CSV outfile including its column headers.  I'm trying to do this using only SQL or the Linux command line, without writing a program in another language.  Thank you
I came across the following question:     If 3 boys can paint a fence in 2 days what part of the job can     be completed by two boys in 1 day?   The answer to this problem is $\frac13$.  I can't manage to tackle this problem. Could anyone tell me what would be the quickest way to solve this problem (This question is a standardized test based question). Any help would be appreciated. I am wondering whether there exists a function such that:  $$\lim_{x \rightarrow a}f(x)=\infty$$  at some point $a$ on the real axis but yet,  $$\int_{-\infty}^{+\infty}\left|f(x)\right|\ dx&lt;\infty$$  Does the fact that a function is unbounded imply that it has no finite integral? How can I make a Random Number Generator with vanilla redstone? I am looking for a correct proof of this statement: If $G$ is a group such that $G/Z(G)$ is cyclic, then $G$ is commutative.  Proof: $G/Z(G)$ is isomorphic to $\operatorname{Inn}(G)$ and is cyclic, and then for every $a$ and $b$ in $G$ the inner isomorphisms $\gamma_a$ and $\gamma_b$ satisfy $\gamma_a \gamma_b = \gamma_{ab} = \gamma_{ba} = \gamma_b \gamma_a$, and therefore for every $a,b \in G$, $ab = ba$.  Is that proof complete, or am I missing something? Thanks a lot for the help. Can we clarify to the OP that their question is not yet closed and the duplicates are only suggestions? I keep seeing custom flags in the queue from question askers who are incredibly irritated because there is a big, prominent box at the top of their question. It's just a list of other questions which may have the answer they desire, and is only even displayed to them because the question is not closed yet.  This question may already have an answer here: [list]  But to an ordinary user, it is not at all clear that the box is only shown to them, or that it will go away on its own if their question never actually gets closed. Could the text for this notice be altered to make it more clear that:  They are just suggestions for the person to view. Potentially if they agree with one, they should vote to close their own question as a duplicate of it.  Their question is not closed yet. If they disagree with the duplicates suggested, they should clarify their question and explain why it's not a duplicate.   I was thinking of an altered wording such as:  You might be able to find an answer to your question here: [list] If those answers do not fully address your question, please [edit your question] to clarify your exact problem.  I went with a more direct wording for the bolded title. Since the notice is only displayed to the asker, it makes more sense to talk directly to them in the message rather than making it feel like it's supposed to be addressing the entire audience of the site. Emphasize that only that person is seeing it by talking to them. It would also be helpful to append a &quot;More info&quot; link at the end of the message that links them to some further documentation about duplicates, and explains how the notice works - particularly that it will go away eventually or change to a proper duplicate notice if the question does get closed. Mac Sierra won't boot - SmartBattery: finished polling type 4 Modern textbook on statistical field theory with an emphasis on applications to non-equilibrium phenomena? Rotate (group) objects outwards on spherical particle system? I'm trying to create a mini-world with (among other things) trees on it. I have created an icosphere, modeled several trees and put them in a group. Next I added a particle system to the sphere, and chose hair. In the "render" section I selected Group and the name of the group I created. As expected the trees show up but they're all oriented in the same direction, while I would like them to pop up just like the default hairs do (along the normal of the individual faces). I tried fiddling with all kinds of settings, had them oriented in all kind of ways (e.g. towards the "north pole"). I also tried using the emitter instead of hair setting but without success as well. I seem to remember from first year physics that we can calculate the RMS speed of a stationary, ideal gas with $v=\sqrt{\frac{3RT}{M}}$. Does a similar equation exist for liquids? Is there a standard function in C that would return the length of an array? Guest (not logged in) users can only sort questions with specific tag by newest I think this is platform wide (all SE sites).   Logout Choose a tag, eg.  on SO Try to sort questions by something other than newest   No matter what sorting is chosen, questions are sorted by newest Using v2.73, cycles and a very simple scene: an array of cubes, no big deal.   If I set the shader's material to transparent, the cubes in the foreground do become transparent but those far away in the back do not disappear completely and this strange dark things appear (visible in rendered mode and in final renders)    I've played with the clipping distance on the viewport and camera, but I can't figure out how to make those ghosts go away... I have to give a combinatorial proof of  $$\sum_{k=1}^nk{n\choose k}^2=n{2n-1\choose n}.$$  I find it difficult to solve such problems. I'm not a brilliant person and never will be so I need to have algorithms to solve most problems. Usually I won't just "see" solutions unless I have a thorough enough understanding of a theory. This is also the case here. I know what the symbols mean, but I don't see what I should count and how to obtain the identity.  I think the right-hand side counts $n$-element subsets of a $(2n-1)$-element set with one element chosen to be "special". I think I should find a partition of the set of such subsets into $n$ parts so that the left-hand side is the sum of the cardinalities of the parts. Is there $n$ of anything on the right-hand side? Well, there are $n$ choices for the "special" elements, but only after I've chosen the $n$-element subset. Otherwise I can choose the "special element" in $2n-1$ ways.  This is a homework problem so I probably shouldn't ask for a full solution. But I would like to have some guidelines for approaching such problems, perhaps based on this example. When should we use proximity rule in "either/or", and "neither/nor"? According to this , if at least one of the nouns involved is plural then it should take the plural form of the verb. Otherwise, it should take the singular form of the verb. But in the last part it says not all grammars agree to those rules thus proximity rule applies. However, it doesn't explain when to apply the proximity rule and when not to use the former rules. What does this notification icon mean? Samsung s7 Dividing polynomial $f(x)$ by $x-3$ and $x+6$ leaves respective remainders $7$ and $22$. What's the remainder upon dividing by $(x-3)(x+6)$? How to show $a,b$ coprime to $n\Rightarrow ab$ coprime to $n$? Let $a,b,n$ be integers such that  $\gcd(a,n)=\gcd(b,n)=1$. How to show that $\gcd(ab,n)=1$?   In other words, how to show that if two integers $a$ and $b$ each have no non-trivial common divisor with and integer $n$, then their product does no have a non-trivial common divisor with $n$ either.     This is a problem that is an exercise in my course.   Intuitively it seems plausible and it is easy to check in specific cases but how to  give an actual proof is not obvious. Can $\sqrt{n} + \sqrt{m}$ be rational if neither $n,m$ are perfect squares? Why do different wavelength get impeded more or less when in different materials? Moving with the same speed, but a longer physical distance would imply that the fields oscillate less times in the material, but I don't know why a difference in the number of oscillations would impede the wave- I don't even know why things slow down in general. Why some electromagnetic wave would slow down just because it's entering other electromagnetic fields... It would seem to me that the only factor would be time taken to physically move some electron or something in the direction of the fields... But that seems to simple of an explanation to me. For any prime $p > 3$, why is $p^2-1$ always divisible by 24?