mysql table creation error
Posted: Sun Aug 10, 2003 2:48 pm
i'm rather new to sql... i don't understand the error. the only fddfernce form the book i modeled this after is they have bigint where i have int, and they don't use auto_increment... well. on the first line.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW DATABASES
-> ;
+----------------+
| Database |
+----------------+
| findyourdesire |
| mysql |
+----------------+
2 rows in set (0.15 sec)
mysql> USE findyourdesire
Database changed
mysql> CREATE TABLE users(
-> uid int auto_increment unsigned NOT NULL PRIMARY KEY,
-> username varchar(15) NOT NULL PRIMARY KEY,
-> password varchar(15) NOT NULL,
-> email tinytext NOT NULL PRIMARY KEY,
-> gmt_offset tinyint default '-5' NOT NULL,
-> site_access tinyint unsigned default '0' NOT NULL,
-> admin_comment tinytext,
-> approved tinyint unsigned default '12' NOT NULL,
-> last_login_ip tinytext NOT NULL,
-> last_login_date datetime default '0000-00-00 00:00:00' NOT NULL,
-> end_level date default '0000-00-00' NOT NULL,
-> login_duration tinyint default '0' NOT NULL,
-> join datetime default '0000-00-00 00:00:00' NOT NULL,
-> gender char(1) NOT NULL,
-> last_activity datetime default '0000-00-00 00:00:00' NOT NULL
-> ) TYPE=MyISAM;
ERROR 1064: You have an error in your SQL syntax near 'unsigned NOT NULL PRIMARY KEY,
username varchar(15) NOT NULL PRIMARY KEY,
passwo' at line 2
mysql> SHOW TABLES
-> ;
Empty set (0.18 sec)
mysql> CREATE TABLE users(
-> uid int auto_increment unsigned NOT NULL PRIMARY KEY,
-> username varchar(15) NOT NULL PRIMARY KEY,
-> password varchar(15) NOT NULL,
-> email tinytext NOT NULL PRIMARY KEY,
-> gmt_offset tinyint default '-5' NOT NULL,
-> site_access tinyint unsigned default '0' NOT NULL,
-> admin_comment tinytext,
-> approved tinyint unsigned default '12' NOT NULL,
-> last_login_ip tinytext NOT NULL,
-> last_login_date datetime default '0000-00-00 00:00:00' NOT NULL,
-> end_level date default '0000-00-00' NOT NULL,
-> login_duration tinyint default '0' NOT NULL,
-> join datetime default '0000-00-00 00:00:00' NOT NULL,
-> gender char(1) NOT NULL,
-> last_activity datetime default '0000-00-00 00:00:00' NOT NULL) TYPE=MyISAM;
ERROR 1064: You have an error in your SQL syntax near 'unsigned NOT NULL PRIMARY KEY,
username varchar(15) NOT NULL PRIMARY KEY,
passwo' at line 2
mysql>