Posted by paul on 06/29/05 18:16

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) )

• Next in forum: Re: enum can't create table
• Prev in forum: Re: Best way to keep user's product infos
• Thread view: enum can't create table

[Reply to this message]