table creating

admin

Administrator
Staff member
CREATE TABLE members (
id int UNSIGNED NOT NULL,
username varchar(16) NOT NULL,
password varchar(16) NOT NULL,
email varchar NOT NULL,
realname varchar NULL,
age tinyint(2) NULL,
aim varchar(16) NULL,
icq int(9) UNSIGNED NULL,
sitename varchar NULL,
siteaddr varchar NULL,
picture varchar NULL,
date char(8) NOT NULL,
time char(7) NOT NULL,
);

I'm using phpMyAdmin and it gives me errors on the create a table feature, so i thought I'd try it manually.

When I enter that, it gives me this error:

You have an error in your SQL syntax near 'NOT NULL, realname varchar NULL, age tinyint(2) NULL, aim varchar(16) NULL' at line 5

Line 5 would be the line that the "email" column is on. It gives me many errors just like this when I use phpMyAdmin, and I have NO CLUE why. I mean, phpMyAdmin is supposed to make managing a database easier, so shouldn't it correct these errors itself? Agh.

Anyways, could someone just tell me what's wrong with the syntax above?
 
Back
Top