Syntax error

[jesmor]

Could somebody plase tell me what's wrong in this SQL statment?
DROP DATABASE CustomerDB;

CREATE DATABASE CustomerDB;

CONNECT CustomerDB;

CREATE TABLE address
(ID int(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
addressLine1 varchar(100) NOT NULL,
addressLine2 varchar(100) NULL,
city varchar(100) NOT NULL,
state_or_province varchar(100) NOT NULL,
zip_or_postalCode varchar(100) NOT NULL,
country varchar(100) NOT NULL);

Thanks

 

[danielhozac]

Have you tried changing the [tt]CONNECT[/tt] to [tt]USE[/tt]?

//Daniel