Is there a required ordering for table column attributes upon table creation?
MySQL 3.22.23b-sun-solaris2.6-sparc gave me the following error which I
'finally' fixed by reordering the spec..
mysql> create table test2(ID int not null unsigned);
ERROR 1064: You have an error in your SQL syntax near 'unsigned)' at line 1
mysql> create table test2(ID int unsigned not null);
Query OK, 0 rows affected (0.10 sec)
It did not like 'not null' declared before 'unsigned'. This is not intutitive
and makes me wonder what other gotchas there are, and whether there is
documentation somewhere pointing them out.
boeing phantom works
|• MySQL Bug?||Stephen Uczekaj||27 Jul|
| • Re: MySQL Bug?||Paul DuBois||27 Jul|