MySQL 4.1.1 create table : why negatives values need quotation marks?

Any idea ? Thanks in advance. Christophe. -- *** Christophe DIARRA Institut de Physique Nucleaire 15, Rue Georges Clemenceau Bat 102 - S2I 91406 ORSAY Cedex Tel: (33) 1 69 15 65 60 Fax: (33) 1 69 15 64 70 E-mail: [EMAIL PROTECTED] *** -- MySQL General Mailing List For list archives: http://lis

Re: MySQL 4.1 : curious privilege problems (grant, use, show databases)

On Nov 25, Christophe DIARRA wrote: > > Hello. > > > > MySQL 4.1.0 is not respecting the registered privileges. > ... > > "show databases" displays an incorrect list of databases. Each user lists a > > database it should not, and doesn't show all the dat

MySQL 4.1 : curious privilege problems (grant, use, show databases)

db from db; +-+--++ | user| host | db | +-+--++ | ccsql | %| cctandem | | ccsql | %| cctandemOnline | | ccsql | %| cctest | | archive | %| dbancien | | archive | %| dbcourant

Fastest way to get the number of rows in a table ?

0-00-00 00:00:00', `idarchive` bigint(20) NOT NULL default '0', `jamaiseffacer` char(1) NOT NULL default '', PRIMARY KEY (`iddatephoto`) ) TYPE=InnoDB 1 row in set (0.00 sec) Thanks in advance for your he

Storing/retrieving "long" or very big double values

27;select * from ouble_test'). Any idea or experience to share. Thanks in advance, Christophe. *** Christophe DIARRA Institut de Physique Nucleaire 15, Rue Georges Clemenceau Bat 102 - S2I 91406 ORSAY Cedex Tel: (33) 1 69 15 65 60 Fax: (33) 1 69 15 45 03