Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

[PHP-DB] 'date' data-type From: Russell John Michell (r.j.michell <email protected>)
Date: 12/08/00

Hi all:

I seem to be having trouble specifiying a field length for my 'date'
data type in the mysql shell.

I'm using mysql-3.22.32

 mysql>create table my_table (theDate date (8)); //This is not my
actual table but the date part exists in it as outlined above.

mysql outputs it's usual: You have an error in your SQL syntax near '(8))' at line 1

I am thinking that it uses the same syntax for assigning a length value
as does varchar or int etc etc, what's wrong - anyone??

Russ

--------------------------------------------

          
    "Believe nothing - consider everything"

Russ Michell (APU webteam)
r.j.michell <email protected>
ext 2331 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>