How to send email using MySQL Server?
How to send email from MySQL 5.1
I have two groups with equal variances and unequal sample size (28 and 8) and I want to run a Student t-test. Can I use Mann-Whitney considering that the variances are equal? Do you think if there is a better test to compare the samples? Natural (human alpha-numeric) sort in Microsoft SQL 2005 We have a large database on which we have DB side pagination. This is quick, returning a page of 50 rows from millions of records in a small fraction of a second.  Users can define their own sort, basically choosing what column to sort by.  Columns are dynamic - some have numeric values, some dates and some text.  While most sort as expected text sorts in a dumb way. Well, I say dumb, it makes sense to computers, but frustrates users.  For instance, sorting by a string record id gives something like:  rec1 rec10 rec14 rec2 rec20 rec3 rec4   ...and so on.  I want this to take account of the number, so:  rec1 rec2 rec3 rec4 rec10 rec14 rec20   I can't control the input (otherwise I'd just format in leading 000s) and I can't rely on a single format - some are things like "{alpha code}-{dept code}-{rec id}".  I know a few ways to do this in C#, but can't pull down all the records to sort them, as that would be to slow.  Does anyone know a way to quickly apply a natural sort in Sql server?    We're using:  ROW_NUMBER() over (order by {field name} asc)   And then we're paging by that.  We can add triggers, although we wouldn't. All their input is parametrised and the like, but I can't change the format - if they put in "rec2" and "rec10" they expect them to be returned just like that, and in natural order.    We have valid user input that follows different formats for different clients.  One might go rec1, rec2, rec3, ... rec100, rec101  While another might go: grp1rec1, grp1rec2, ... grp20rec300, grp20rec301  When I say we can't control the input I mean that we can't force users to change these standards - they have a value like grp1rec1 and I can't reformat it as grp01rec001, as that would be changing something used for lookups and linking to external systems.  These formats vary a lot, but are often mixtures of letters and numbers.  Sorting these in C# is easy - just break it up into { "grp", 20, "rec", 301 } and then compare sequence values in turn.  However there may be millions of records and the data is paged, I need the sort to be done on the SQL server.  SQL server sorts by value, not comparison - in C# I can split the values out to compare, but in SQL I need some logic that (very quickly) gets a single value that consistently sorts.  @moebius - your answer might work, but it does feel like an ugly compromise to add a sort-key for all these text values. I'm seeking for a proof of the following:     Let $A$ be an invertible matrix. Then the determinant of $A^{-1}$ equals:   $$\left|A^{-1}\right|=|A|^{-1} $$   I don't know where to begin the proof. Any suggestions? How to peel hard boiled eggs easily? This is one of the most annoying duties in the kitchen, for me.  What are yours tips and tricks to peel hard boiled eggs easily? Am I correct to say the difference between a signed and unsigned integer is:  Unsigned can hold a larger positive value and no negative value. Unsigned uses the leading bit as a part of the value, while the signed version uses the left-most-bit to identify if the number is positive or negative. Signed integers can hold both positive and negative numbers.  Any other differences? Best way to save data on the iPhone I am writing an iPhone application, and need to save the state of my application (5K or so).  My main worry is data persisting across upgrades. Some of the applications I use clearly got this wrong, and I would prefer not to! Where are some places to get reference images for modeling? I'm a newbie.  I've gone through a number of tutorials and want to get some actual experience with modeling. But, I don't know where to go to get good reference images for modeling with front/sides views.  Can anyone recommend the best places to find such images? How to type latin small letter c with cedilla I run Ubuntu on a DELL XPS 13 notebook that has an US keyboard configured as US international. After upgrading to version 13.10 I can no loger get a cedilla by typing '+C. Instead, I get a "ć".  What should I do to get a "ç"?  I am using Ubuntu Gnome 13.10 64 bit. How can I install the Google Apps Package (Play Store, ...) on my Android device? I have recently installed a custom ROM and cannot find the Play Store. It seems like all apps that belong to Google are missing.  How can I install the Google Apps Package (Play Store, ...) on my Android device? Can you grapple/shove with the Hunter Ranger's Whirlwind Attack? The  states:     You can use your action to make a melee attack against any number of creatures within 5 feet of you, with a separate attack roll for each target.   The rules on "" state (the rules in shoving are effectively identical):     When you want to grab a creature or wrestle with it, you can use the Attack action to make a special melee attack, a grapple. If you're able to make multiple attacks with the Attack action, this attack replaces one of them.   I couldn't find any other features spells or abilities that allow a creature to make a flat "melee attack". If they had said "melee weapon attack" instead this would have meant the same thing but specifically have excluded grapple/shove as an option.  I am unsure whether the rules on grappling/shoving mean that the only time you can grapple/shove are when you take the Attack action, which you are not doing when using the Whirlwind Attack feature.   I would like answers to assume that the following ruling made in the  is correct:     Whirlwind Attack is unusual, in that it’s a single attack with multiple attack rolls... reduce Screen brightness in battery mode automatically KDE and XFCE4 has a program to adjust the screen brightness automatically in battery mode to a preset value. How can i set the same with Unity ( or Gnome3 )? I just fit a model in lme4, and I'm wondering what the heck I fit...  I have individuals id, and each is measured pass/fail on items that can be described using two factors, f1 and f2. My theory says that id and f2 can interact. So I want to compare these models:  # f2 doesn't matter m1 &lt;- lmer(pass ~ f1 + (1|id), family="binomial")  # f2 is a fixed effect, doesn't interact with individuals m2 &lt;- lmer(pass ~ f1 + f2 + (1|id), family="binomial")  # f2 is a nested random effect, interacting with individuals m3 &lt;- lmer(pass ~ f1 + (1|f2/id), family="binomial")   First, am I right that there's a random effect of each level of f2, and each individual's level of f2 is partially pooled, depending on the number of observations for that individual?  Second, does it make sense to fit f2 as a fixed effect with random individuals nested within each level of f2? How does one write that?  Third, what's this, with f2 and id reversed in the formula? I typed it by accident, but now I want to understand it.  m3weird &lt;- lmer(pass ~ f1 + (1|id/f2), family="binomial") Inheriting constructors Why does this code:  class A {     public:          explicit A(int x) {} };  class B: public A { };  int main(void) {     B *b = new B(5);     delete b; }   Result in these errors:   main.cpp: In function ‘int main()’: main.cpp:13: error: no matching function for call to ‘B::B(int)’ main.cpp:8: note: candidates are: B::B() main.cpp:8: note:                 B::B(const B&)   Shouldn't B inherit A's constructor?  (this is using gcc) CSS two divs next to each other I want to put two &lt;div&gt;s next to each other. The right &lt;div&gt; is about 200px; and the left &lt;div&gt; must fill up the rest of the screen width? How can I do this? Shortcut to open Terminal and run some commands How to list available shells for use by command-line? Way to list "Contact Us" email address on web site, yet reduce likelihood of spam? What's a good way to list a "Contact Us" email address on a web site, while reducing the likelihood it will get spammed?  Is putting the email address in an image the best technique, or are there others? How can I find the codes related to a function in GAP? When I use "??" in front of the name of function there is no help, so I want to find the code of function among packages. What does it mean for two objects to "touch"? I want to run Notepad++ twice. Like in this paint printscreen.  How I want it:    Not what I want:    Is this possible?