Try changing this...
category_id NUMERIC NOT NULL AUTO_INCREMENT,
to this...
category_id INT NOT NULL AUTO_INCREMENT,
or MEDIUMINT/BIGINT if you need that much.
The INT type is the only type to accept an auto_increment qualifier.
http://www.mysql.com/doc/en/CREATE_TABLE.html
Hope this
Hi
AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal?
not 100% sure but it looks like it
Peter
-Original Message-
From: Cesar Baquerizo [mailto:[EMAIL PROTECTED]
Sent: 24 March 2003 20:59
To: MySQL
Subject: CREATE syntax wrong?
Hello,
I am on:
mysql Ver 11.18 Distrib