I want to select multiple rows of data from a table and add it onto another one.  For example:  Select * from Table1   which would return  id | name  1 | Chad  2 | Mary  3 | Denise   I want to add these rows of data to Table 2  Insert(id, name) values(@id, @name)   Thank you!
I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (, , , , and ).  Is there a silver-bullet syntax coming from an SQL standard (for example, ) that would allow me to insert the values without worrying about the underlying database?
How can I control where smoke and fire are emitted from? /usr/bin vs /usr/local/bin on Linux Print to standard printer from Python? Can I have 2x2 workspaces in GNOME 3? I have just upgraded to Ubuntu 17.10 and found out there is no option to have 2 by 2 workspaces. I was able to configure 4 "static" workspaces using , but I would like to have them in 2 rows by 2. Any ideas? In Ruby on Rails, how do I format a date with the "th" suffix, as in, "Sun Oct 5th"? I want to display dates in the format: short day of week, short month, day of month without leading zero but including "th", "st", "nd", or "rd" suffix.  For example, the day this question was asked would display "Thu Oct 2nd".  I'm using Ruby 1.8.7, and  just doesn't seem to do this.  I'd prefer a standard library if one exists. Photoelectric effect intensity I understand the PE effect quite well but I'm failing to understand one thing. Intensity is the amount of energy per second incident to a given area.   So can you can increase the intensity by either increasing the electrical energy or making the area smaller? By increasing the electrical energy, what exactly is happening?  I assume that by increasing intensity you are increasing the number of photons incident to an area of the metal thus increasing the rate of photoelectric emission. But why doesn't increasing intensity via more electrical power lead to greater energy of the electrons, if by increasing intensity you are increasing the energy of the incident waves?  I understand the results but I'm trying to understand why the intensity works the way it is thanks Book about almost extinct warrior race with three castes: sen, kaa, ker The aliens in this book are an humanoid alien mercenary race, fighting for some other aliens, against humans?.   The Ker are the fighters, the sen are the wise ones, and the kaa the family/non-fighters.  Their clan gets almost wiped out because both their employers and humanity fear them, and the last survivors head towards their race' home planet, together with a human captive, who learns about their ways.  The other aliens are some blob-like aliens with little genetic variety.  Ring any bells? Let $X, Y$ be an exponentially distributed random variables with parameters $a, b$. Then $X$ has pdf:    $$f_X(x) =\begin{cases} a e^{-a x},&amp; x\geq 0\\ 0,&amp; \text{otherwise}.\end{cases}$$ Suppose $X$ and $Y$ independent. Show that $$\mathbb P(X&gt;Y) = \frac{b}{a+b}.$$   Now I thought the following: $$f(x,y) = f_X(x)\ f_Y(y) = abe^{-ax -by},\qquad\text{for } x,y &gt; 0.$$ And then $$\mathbb P(X&gt;Y) = \int_0^\infty \int_0^x a b e^{-ax -by}\,dydx$$ However, if I solve this (manually or using Wolframalpha), I can't seem to end up with $\frac{b}{a+b}$. Any ideas? What is an Electron? I am a n00b to physics. What physics I know comes from high school and popular science books.  At school we were taught about atoms and what make up atoms, but we weren't actually told what the particles were!  So sure an atom has electrons orbiting around a nucleus made of protons and neutrons, but what exactly is an ?  And if we don't know, how can we fire them from guns, like they do in experiments ... etc  Any clarification on this would be great. Is imperative Quicksort in situ (in-place) or not? Is it possible to make an underfull tabulary spread out? Recently I installed Ubuntu 12.10 x64 Server Edition on my PC. Unfortunately, I attempted to install a lightweight desktop but due to the fact that I have an old graphics card, the PC does not perform so well. I am thinking of re-installing an Ubuntu version but I do not want to lose the contents in my home folder. Is there any way to do that with a Live CD? I am often interested in the installation triggers (postinst, postrm) or certain parts of packages (like /usr/share and /etc). Currently, I am running the next command to retrieve the source code:  apt-get source [package-name]   The downside is, this file is often much bigger than the binary package and does not reflect the installation tree.  Right now, I am downloading the packages through :      Download the actual file   This takes too long for me and as someone who really likes the shell, I would like to do something like the next (imaginary) command:  apt-get get-deb-file [package-name]   I could not find something like this in the . The most close I found was the --download-only switch, but this puts the package in /var/cache/apt/archives (which requires root permissions) and not in the current directory. libpng problems for QGIS I'm using ubuntu 18.04 and if I download QGIS 2.18 and I try to run it, I get this:  libpng warning: Application jmp_buf size changed Segmentation fault (core dumped)   If I try with QGIS 3.2, the error is:   libpng warning: Application was compiled with png.h from libpng-1.6.34 libpng warning: Application  is  running with png.c from libpng-1.2.56 libpng error: Incompatible libpng version in application and library   So it's clear that the problem is with libpng.   I purged libpng-dev and reinstall again but nothing changed.   I tried to purge libpng16-16 but I get:  sudo apt purge libpng16-16 Reading package lists... Done Building dependency tree        Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation:  The following packages have unmet dependencies:  libgdk-pixbuf2.0-0 : Depends: libpng16-16 (&gt;= 1.6.2-1) but it is not going to be installed                       Recommends: libgdk-pixbuf2.0-bin  libgtk-3-0 : Depends: libcairo-gobject2 (&gt;= 1.10.0) but it is not going to be installed               Depends: libcairo2 (&gt;= 1.14.0) but it is not going to be installed               Depends: libfontconfig1 (&gt;= 2.12) but it is not going to be installed               Depends: libpango-1.0-0 (&gt;= 1.40.5) but it is not going to be installed               Depends: libpangocairo-1.0-0 (&gt;= 1.40.5) but it is not going to be installed               Depends: libpangoft2-1.0-0 (&gt;= 1.40.5) but it is not going to be installed               Depends: adwaita-icon-theme               Recommends: libgtk-3-bin E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.   and then:  ~$ sudo apt install libgdk-pixbuf2.0-bin libgtk-3-bin Reading package lists... Done Building dependency tree        Reading state information... Done libgdk-pixbuf2.0-bin is already the newest version (2.36.11-2). libgtk-3-bin is already the newest version (3.22.30-1ubuntu1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. ~$ sudo apt install libgtk-3-0 libgdk-pixbuf2.0-0 Reading package lists... Done Building dependency tree        Reading state information... Done libgdk-pixbuf2.0-0 is already the newest version (2.36.11-2). libgtk-3-0 is already the newest version (3.22.30-1ubuntu1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.   At this point I'm afraid of breaking something if I continue trying things, so I come here for advice before.  I deleted and reinstalled ubuntu. I installed first thing qgis and it was working. Afterwards I compiled gdal, from source to have it from python as stand alone. It might be this, but I had done this previously without any problems. Why does the co-efficent of kinetic friction of a block on an inclined plane not change when you increase the angle of the plane? Why does the addition of a \left and \right introduces an extra space around the formula? Specifically, why do $\cos(\theta)$ and $\cos\left(\theta\right)$ render differently?  Is there a way to use resizable delimiters without introducing the spurious spaces?  Why did Knuth design it like this?  Edit: This occurs too, if \operatorname{MYOP} or some other operator, like \lim, \min etc. is used. (This edit is basically to make it easier to find this answer.) I would like to show that  $$\forall n\in\mathbb{N}^*, \quad \sqrt{\frac{n}{n+1}}\notin  \mathbb{Q}$$  I'm interested in more ways of proofing this.  My method :  suppose that $\sqrt{\frac{n}{n+1}}\in  \mathbb{Q}$ then there exist $(p,q)\in\mathbb{Z}\times \mathbb{N}^*$ such that $\sqrt{\frac{n}{n+1}}=\frac{p}{q}$ thus   $$\dfrac{n}{n+1}=\dfrac{p^2}{q^2} \implies nq^2=(n+1)p^2 \implies n(q^2-p^2)=p^2$$ since $p\neq q\implies p^2\neq q^2$ then  $$n=\dfrac{p^2}{(q^2-p^2)}$$  since $n\in \mathbb{N}^*$ then $n\in  \mathbb{Q}$   I'm stuck here and I would like to see different ways to prove $\sqrt{\frac{n}{n+1}}\notin  \mathbb{Q}$ Remove Meta Privilege for MSE (only) Are there any simple rules for choosing the definite vs. indefinite (vs. none) article? Does the lens I just bought have a fungus?