Re: phpmyadmin troubles - creating tables

On Tue, Jul 24, 2001 at 01:07:51AM -0500, olinux wrote: > 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 , > 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 If you look hard, you will notice, that you have "permission ENUM" before the "package INT". Now the question is, what do you want to enumerate? You should really provide some attributes to the create statement (unless you left them out for this email). HTH, Karsten -- Why do we have to hide from the police, daddy? Because we use emacs, son. They use vi. ----------------------------- mailto:k.dambekalns@tu-bs.de w³: http://www.k-fish.de/ gpg: http://www.k-fish.de/mykeys.gpg