Dennis Thrysøe wrote:
> CREATE TABLE Test3
> (
> ID INT PRIMARY KEY NOT NULL auto_increment,
> FactText TEXT
> )
>
> mySQL reports a parse error in the decleration of ID (always near
> auto_increment).
Turn it to:
ID INT NOT NULL auto_increment PRIMARY KEY,
--
+----------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
