[RESOLVED] Simple MySQL "create table" error - can't figure correct syntax...

[dvarsam]

Hello!

I am trying to create the following table in MySQL:

create table raw_material (id int not null primary key auto_increment, raw_number int(5) not null unsigned);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned)' at line 1

I think that the syntax of the "int(5)" is NOT correct.
I basically want the "int" to be an integer of 5 digits - e.g.
"10000" or "23675", or "00304" but not integers of greater or fewer digits.
I visited the site http://dev.mysql.com, but couldn't find a solution.

I know that this is a very simple question to you, but NOT to me... 😕

Thanks.

[leatherback]

try this:

CREATE TABLE `raw_material` (
`id` INT NOT NULL AUTO_INCREMENT ,
`raw_number` INT( 5 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `id` )
);