enum can't create table

05-31-2007, 7:41 PM

I'm getting a syntax error on the last line with the enum definition.
I'm running mySQL 4.1 through PHP. Any clue? Maybe I need to change some
config to accept what ought to be standard syntax?

CREATE TABLE customer (
id INT UNSIGNED AUTO_INCREMENT,
user_name VARCHAR(30),
name VARCHAR(30),
company VARCHAR(50),
password VARCHAR(30),
email VARCHAR(50),
address1 VARCHAR(50),
address2 VARCHAR(50),
city VARCHAR(30),
state CHAR(2),
zip VARCHAR(10),
phone VARCHAR(15),
date_opened DATE,
admin ENUM('no', 'yes') DEFAULT 'no',
PRIMARY KEY (id) )

05-31-2007, 7:41 PM

Well I got phpMyAdmin to do it.

paul wrote:
> I'm getting a syntax error on the last line with the enum definition.
> I'm running mySQL 4.1 through PHP. Any clue? Maybe I need to change some
> config to accept what ought to be standard syntax?
>
> CREATE TABLE customer (
> id INT UNSIGNED AUTO_INCREMENT,
> user_name VARCHAR(30),
> name VARCHAR(30),
> company VARCHAR(50),
> password VARCHAR(30),
> email VARCHAR(50),
> address1 VARCHAR(50),
> address2 VARCHAR(50),
> city VARCHAR(30),
> state CHAR(2),
> zip VARCHAR(10),
> phone VARCHAR(15),
> date_opened DATE,
> admin ENUM('no', 'yes') DEFAULT 'no',
> PRIMARY KEY (id) )
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Big text from shelloutput into table?	AO	Database	0	05-31-2007 7:38 PM
Having problem creating a new Table in SQL database,	Dr.Tulip	Database	0	05-31-2007 7:38 PM
cvs: pear /DB_Table/DB Table.php	David Morse	Pear	0	05-20-2007 6:42 PM
Table aliases	fireshark	Database	5	07-16-2006 5:59 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)