I am working on a huge database. I want to find all the tables in all the database which contains columns name say "xyz" (cann't say actual column name). Is there any query or other way to solve the my problem. TIA  FYI  DB : MySql
I have 2-3 different column names that I want to look up in the entire DB and list out all tables which have those columns. Any easy script?
How to install Ubuntu on portable external Hard Drive? OS: Windows 7. I want install Linux Ubuntu on portable external Hard Drive USB 2.0. I read a variety of methods, but I'm confused by contradictory advices and methods. Actually, installing Ubuntu on anything other than clean PC looks much more complicated than installing Windows. I need to have Ubuntu package + Python 2.7 + C compiler installed. My external hard drive is partially filled, I need to keep all files.   Will Ubuntu run entirely on external hardrive, without writing anythinhg to Windows system folders and to registry?  Can anyone post detailed guide how install Ubuntu on external hard drive? Let $R=\mathbb{Z}\left[\sqrt{−5}\right]$. Let $I=\left(2,1+\sqrt{−5}\right)$. Show $I^2 = (2)$ in $R$. I don't know how to solve this problem. I tried to write out the sum of products in the definition of products of ideals, but that doesn't seem to lead anywhere. Is it possible to write some C or C++ code and compile to binaries, then use those binaries with php? Is it also possible to write a php library using C and C++ ?  If so, please tell how can I do so? When estimating variance, why do unbiased estimators divide by n-1 yet maximum likelihood estimates divide by n? I am totally confused: On the one hand you can read all kinds of explanations why you have to divide by n-1 to get an unbiased estimator for the (unknown) population variance (degrees of freedom, not defined for sample size 1 etc.) - see e.g.  or .  On the other hand when it comes to variance estimation of a supposed normal distribution all of this doesn't seem to be true anymore. There it is said that the maximum likelihood estimator for variance includes only a division by n - see e.g. .  Now, can anyone please enlighten me why it is true here but not there? I mean normality is what most models boil down to (not least due to the ). So is the choice "division by n" yet the best choice for finding the best estimation for the true population variance after all?!? Prove by contradiction (not using a calculator) that $\sqrt6 + \sqrt2 < \sqrt{15}$? 4 fast cores or 6 slower ones? If friction acts on car all time, why is it not accelerating forever? In the first gear, slowly releasing my clutch i push the gas pedal to the maximum torque level, say at 2000 rpm. Now as the engine torque is acting on the wheel, friction helps the car to accelerate.   If i hold the gas pedal at that position, the torque should continuously act on the wheel and the car should increase speed forever. But in reality even if we put the gas pedal at the max.torque rpm range in first gear it speeds up to certain wheel rpm (say 500rpm) and it stays there only. Why? Is something wrong with StackOverflow's spam filter? Recently there have been huge numbers of spam topics related to football streaming. They have all been spam flagged and deleted but there are more getting posted all the time, I just flagged another 6 or so a few minutes ago. This has been going on for around 3 days now with these topics getting constantly posted over and over again in the  tag. How to disable notifications for a single mailbox in Mail? When managing multiple mailboxes, is it possible to disable the notifications for certain mailboxes? How to install a list of packages using apt-get? So from what I understand transistors are one of the most important electronic elements for computers because of TTL (Transistors-Transistors Logic).  Is this true? If so, how exactly does this work? I have heard the terms "logic gate" and "logic block" tossed around. This is a  about RAID levels.    What are:   the RAID levels typically used (including the RAID-Z family)?  deployments are they commonly found in? benefits and pitfalls of each? Agreeing on a single shortened nomenclature? I've noticed across various stack exchange sites that when they refer to their own stack exchange on their site, they'll shorten the name to something similar to either:  EE.SE (Electrical Engineering Stack Exchange) OR Tex.Sx (LaTeX Stack Exchange)  Essentially they'll do XX.SE or XX.SX which has the possibility to generate some confusion for new users.    Have I not visited enough sites and just noticed an outlier or would it be beneficial for Stack Exchange sites to agree on a shortened name nomenclature? How to cleanup deadlinks I was reading some answers about ruby and there are a lot of links to _why's sites.  and took all his sites with him.  Almost every introduction question about ruby will include at least one or two links to one of his sites. Examples:          With a bit more effort I could probably find more questions with a lot of deadlinks.  My suggestion for discussion was, what would be a good way to solve deadlinks in the answers/comments? Not every site _why created has resurfaced somewhere else, but some could be replaced by new links.  But I wanted the discussion to go beyond this specific problem of deadlinks in the ruby answers, an automatic solution would be to let the links be scanned in a batch and when found dead be replaced by a google cache or webarchive version of the page, and perhaps mark it so that the community can replace the link with an alternative? In Magic, at the start of the game, you draw 7 cards. How would you calculate the likelihood of drawing a specific card in your opening hand?  For example, let's say I have a 60 card deck, and I'm running 4 . What is the percent chance that I will have at least one Bird in my opening hand? How do we "restore" notepad after crash? Can I fly back to Italy if my Italian residency card has expired and is being renewed? I have a residence permit (permesso di soggiorno) for Italy. I am currently in the Netherlands for an exchange. My permit expired on the 30th of November and I applied for a new one but I will get the card in January. I have the documents supporting that I have applied for the renewal of the permit. In the middle I want to travel to Italy for Christmas and come back to the Netherlands.    Would this be a problem? Solving cubic equations with another method. I want to solve cubic equations with some pattern or formula. My maths teacher told me that if we want to solve cubic equations we have to find any one value for the equation which satisfy it and then divide the main equation by it. But I find that method little useless . Is there any other simplier or good method to solve it. You can explain it by an example. Could someone explain to me what the collision of two photons would look like? Will they behave like,   Electromagnetic waves: they will interfere with each other and keep their wave nature Particles: they will bounce like classical balls   I assume that energy of that system is too small to make creation of pairs possible. What are independent parameters in Hellmann–Feynman theorem? A typical example in textbooks about the application of Hellmann–Feynman theorem is calculating $\left\langle\frac{1}{r^2}\right\rangle$ in hydrogen-like atoms.  has a nice demonstration of this. At some point in the Wikipedia derivation is used that $$\frac{\partial n}{\partial \ell}~=~1. \tag{1}$$   But why is eq. (1) true? I know that  $$n=n_r+\ell+1,$$   but $n_r$ is just another variable with different physical meaning, so why is $n_r$ independent from $\ell$, whereas $n$ is not? The Wikipedia proof for Hellmann–Feynman theorem does not address the problem of independence of different parameters. What variables are kept fixed during the differentiation $(1)$ and why?  The Wikipedia page seems to have only a vague notion of $\frac{\partial\hat{H}}{\partial\lambda}$ and $\frac{\partial E}{\partial\lambda}$, unlike in, e.g., thermodynamics, where all partial derivatives are typically written like  $$\left( \frac{\partial U}{\partial V} \right)_S \qquad ,\qquad  \left( \frac{\partial U}{\partial V} \right)_p \qquad ,\qquad  \ldots $$ so that it is clear which variables are kept fixed during the differentiations.