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

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

• Next in forum: Re: Database "pruning" tool?
• Prev in forum: enum can't create table
• Thread view: Re: enum can't create table

[Reply to this message]