CODEWITHSUNDEEP
mysqlsql
user2981651
user2981651

Reputation: 11

correct mysql syntax error

please could someone tell me the problem with this syntax because mysql 5.5.32 keeps tell me about an error

CREATE TABLE `clients` (
    `ID` tinyint(11) NOT NULL auto_increment,
    `title` varchar(10) NOT NULL default '',
    `firstName` varchar(30) NOT NULL default '',
    `lastName` varchar(30) NOT NULL default '',
    `address1` varchar(100) NOT NULL default '',
    `address2` varchar(100) NOT NULL default '',
    `town` varchar(100) NOT NULL default '',
    `province` varchar(100) NOT NULL default '',
    `country` varchar(40) NOT NULL default '',
    `postCode` varchar(20) NOT NULL default '',
    `telephone` varchar(20) NOT NULL default '',
    `email` varchar(100) NOT NULL default '',
    `cardNo` varchar(16) NOT NULL default '0000-00-00',
    `expiryDate` date NOT NULL default '0000-00-00',
    PRIMARY KEY  (`ID`)
) TYPE=MyISAM COMMENT='customer table' AUTO_INCREMENT=1 ;

Upvotes: 1

Views: 1263

Answers (2)

Jason Heo
Jason Heo

Reputation: 10236

change TYPE to ENGINE like this:

CREATE TABLE `clients` (
    `ID` tinyint(11) NOT NULL auto_increment,
    `title` varchar(10) NOT NULL default '',
    `firstName` varchar(30) NOT NULL default '',
    `lastName` varchar(30) NOT NULL default '',
    `address1` varchar(100) NOT NULL default '',
    `address2` varchar(100) NOT NULL default '',
    `town` varchar(100) NOT NULL default '',
    `province` varchar(100) NOT NULL default '',
    `country` varchar(40) NOT NULL default '',
    `postCode` varchar(20) NOT NULL default '',
    `telephone` varchar(20) NOT NULL default '',
    `email` varchar(100) NOT NULL default '',
    `cardNo` varchar(16) NOT NULL default '0000-00-00',
    `expiryDate` date NOT NULL default '0000-00-00',
    PRIMARY KEY  (`ID`)
) ENGINE=MyISAM COMMENT='customer table' AUTO_INCREMENT=1 ;

MySQL 5.0 accepts TYPE or ENGINE, but above MySQL 5.1, Only ENGINE is allowed.

Upvotes: 1

user1864610
user1864610

Reputation:

The keyword TYPE has been replaced by ENGINE as in

ENGINE=MyISAM

Upvotes: 1

Related Questions