Topic: SQL syntax error

[woodplease]

this is probably a stupid mistake, but i cant seem to find it. I'm just trying to create a table, using phpMyAdmin to directly enter the sql. the error message i get is
"#1064 - 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 'NOT NULL varchar2(12), password NOT NULL varchar2(100), forename NOT NULL va' at line 3"

Code: [Select]

CREATE TABLE users (
user_id int NOT NULL AUTO_INCREMENT,
username varchar2(12),
password varchar2(100),
forename varchar2(100),
surname varchar2(100),
email varchar2(100)
)
Any help on why this is happening would be great. I'm running mysql 5.1.41 if this helps

Thanks

[premiso]

The error you have shown does not coincide with the SQL you have shown.

There is no NOT NULL before varchar2.  The issue is the NOT NULL should be after the TYPE declaration.

[woodplease]

that is the code i used.

i've changed it so that it reads

Code: [Select]

CREATE TABLE users (
user_id int NOT NULL AUTO_INCREMENT,
username varchar2(12) NOT NULL,
password varchar2(100) NOT NULL,
forename varchar2(100) NOT NULL,
surname varchar2(100) NOT NULL,
email varchar2(100) NOT NULL
)
i'm still gettin the error, although it reads slightly different

#1064 - 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 'varchar2(12) NOT NULL, password varchar2(100) NOT NULL, forename varchar2(10' at line 3

[premiso]

VARCHAR2 should probably be VARCHAR.

Unless I am mistaken, I do not think VARCHAR2 is a valid TYPE in MySQL.

[woodplease]

thanks, problem solved