phpmyadmin troubles - creating tables
| From: | olinux | Date: | Tue, 24 Jul 2001 06:07:51 +0000 |
| Subject: | phpmyadmin troubles - creating tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10702@lists.php.net to get a copy of this message | ||
OK, I have no idea why but i have spent the past hour trying to create this
stupid table. I am using the latest version of phpmyadmin. I created the
query several times thru the interface and then played with the query in the
textbox. I need help badly.
CREATE TABLE users (id INT (9) not null , user VARCHAR (12) not null ,
pass VARCHAR (45) not null , permission ENUM , package INT not null ,
apartment VARCHAR (75) not null , apt_address VARCHAR (120) not null ,
apt_city VARCHAR (45) not null , apt_state CHAR (2) not null , apt_zip
CHAR (5) not null , con_first VARCHAR (25) not null , con_last VARCHAR
(30) not null , con_phone VARCHAR (15) not null , con_phone_2 VARCHAR (15)
not null , con_fax VARCHAR (15) not null , con_email VARCHAR (70) not null
, bill_first VARCHAR (25) not null , bill_last VARCHAR (30) not null ,
bill_address VARCHAR (120) not null , bill_city VARCHAR (45) not null ,
bill_state CHAR (2) not null , bill_zip CHAR (5) not null )
I would like my table to look like this. I have tried removing the INT
limit. I have no idea why this is not working.
the error that returns says:
MySQL said: You have an error in your SQL syntax near ' package INT not null
, apartment VARCHAR (75) not null , apt_address VARCHAR (' at line 1
I have tried creating the table as type myisam and still no luck.
Thank you,
olinux
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com