php-db | 2000121

Re: [PHP-DB] 'date' data-type From: Leonard Tambunan (leonard <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.

CREATE TABLE your_table ( theDate DATE );

> 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>
> 

-- 
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>