phpmyadmin troubles - creating tables

From: 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

« previous php.db (#10702) next »