- Original Message -
> From: "Hervey Liu"
>
> CREATE TABLE logins (
>success
> enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
> DEFAULT 'Y' NOT NULL,
>when datetime DEFAULT '-00-00 00:00:00' NOT NULL,
This is going to be an issu
HGi Yang, all!
Yang Yang wrote:
> hi,i am a new guy for a company,and will make 1-3 server to mysql datacenter
>
> i have 2 question want to ask and hope receive responce
>
> 1.on centos or linux server,i should use 5.0 version or 5.1 version,which
> verison is better and can resolve many traff
At 03:36 PM 2/28/2011, Michael Dykman wrote:
One statement will do:
SELECT Min(prod_price) , Max(prod_price), Avg(prod_price) INTO pl, ph, pa
from products;
- michael dykman
Michael,
Brilliant! Thanks. :-)
Mike
On Mon, Feb 28, 2011 at 4:30 PM, mos wrote:
> I want to have a store
One statement will do:
SELECT Min(prod_price) , Max(prod_price), Avg(prod_price) INTO pl, ph, pa
from products;
- michael dykman
On Mon, Feb 28, 2011 at 4:30 PM, mos wrote:
> I want to have a stored procedure that returns 5 columns from a table and do
> some calculations on it. But when I tr
I want to have a stored procedure that returns 5 columns from a table and
do some calculations on it. But when I try it, it complains there is a
syntax error on the 2nd "INTO" clause.
It appears I can have only 1 INTO clause per SQL statement. That means I
have to execute 5 different SQL stateme
I downloaded 5.5 for use under Vista and Windows 7, and found that only the
instance configurator worked. From the command line there was no way to run
"mysql.exe"; there was simply no authorization for any user to run. Often a
complaint appeared that "authentication_string" had no default value
Amongst the common questions it is explained how to make Mac Eudora filter
MySQL-list email based on the added header-line "List-ID". The explanation is
just as good for Windows Eudora, no need to limit it to Macintosh.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
The following occurs when running the Live version of GnackTrack, if you
install from the LiveDVD this issue is no longer present.
LiveDVD can be downloaded from www.gnacktrack.co.uk - this can be used to
demonstrate issue but i think it's likely somethign simple
root@root:~# mysql
ERROR 2002 (HY0
Hi zhongtao,
thank you for reporting this bug. It has been filed as
http://bugs.mysql.com/bug.php?id=60279
Regards,
Roy
On 24.02.11 08.08, tanzhongt wrote:
create table t1(a int);
create table t2(b int);
PREPAREstmt FROM "select sum(b) from t2 group by b having b in (select b from
t1
