I'm practicing MySQL.

What's wrong with this simple table creation code?

create table business
( title char(30) not null,
suite int unsigned not null,
position int unsigned not null,
phone,
business_url,
our_url not null,
contact_first,
contact_last,
b_image1,
b_image2,
b_image3,
b_image4,
couponimage1,
couponimage2,
couponimage3,
couponimage4,
coupontext1,
coupontext2,
coupontext3,
coupontext4,
couponexp1,
couponexp2,
couponexp3,
couponexp4,
keywords not null,
couponkeywords
);

Error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
business_url,
our_url not null,
contact_first,
contact_last,
b_i' at line 5



Thanks.

Don't you need to specify the types for all the fields phone and below??

Edit: yeah, u will need to define the field type, buddy :)

oh I see, thanks for the help!

Basic table creation:


create table my_table (
first_field int not null,
secon_field int,
third_field varchar(255),
PRIMARY KEY (first_field)
) type=innodb;


I think I hit of of the main points. Each field needs a type and the table itself needs a type.

and the table itself needs a type.??

Sure - ISAM, MyISAM, MERGE, HEAP, BDB or InnoDB. MyISAM is the default, so you don't *have to specify a type.