Re: [PHP-DB] 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:[EMAIL PROTECTED] w³: http://www.k-fish.de/
gpg: http://www.k-fish.de/mykeys.gpg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] phpmyadmin troubles - creating tables
you need INT(16) or something, as in in phpmyadmin, enter an integer for the
size of the field as well when defining it :)
// -Original Message-
// From: olinux [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 24 July 2001 2:08 PM
// To: php-db
// Subject: [PHP-DB] phpmyadmin troubles - creating tables
//
//
// 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
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] phpmyadmin troubles - creating tables
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
