Problem with CREATE statement... 1

[degroat]

Can someone please tell me what I am doing wrong here:

create table order (oid int unsigned auto_increment primary key, bname varchar(25), baddr1 varchar(50), baddr2 varchar(50), bcity varchar(25), bstate char(2), bzip varchar(8), sname varchar(25), saddr1 varchar(50), saddr2 varchar(50), scity varchar(25), sstate varchar(2), szip varchar(8), phone varchar(20), email varchar(50), shipmethod varchar(4), newsletter int, ip varchar(15), approval_num int, ref_num int, leaseline int, avs char(2), avs2 char(1), cvm_match char(1))

 

[sleipnir214]

What error are you getting?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

You'll probably find that MySQL doesn't like nameing a table "order". That word is a MySQL reserved word.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[degroat]

You have an error in your SQL syntax near 'order(oid int unsigned auto_increment primary key, bname varchar(25), baddr1 var' at line 1

 

[degroat]

Good call.. that's what it was. Thanks.