MySql Error 1064 - Created using MySQL WorkBench -


I created it using MySQL WorkBench

  If the table is not present then 'Bakasura_new` The name 'City name', `short_name`, VARCHAR (255) Faucet comment 'Short name', 'country_ID', INT ('ID' INCT (11) unsecured nulled integration, 'name' VARCHAR (255) (11) is not unknowable, primary key (`id`), index 'fk_cities_countries` (` country_id` asc), engine = insodei;  

I am getting this error

MySQL said: Documentation

# 1064 - There is an error in your SQL syntax; manually check that

your system For your simulator, match the MySQL server version, use '= InnoDB' on line 8

You have a drop-down comma here:

  INDEX 'fk_cities_countries` (` country_id` ASC),  

and you have the end There is missing bracket in:

  Create a table if the number of 'BAKASUR_NU' is not in. 'CTI' (`ID` INT (11) unknown name not engagement,` name 'VAARAAR (255) Faucet Name ',' short_name ', VAARAR (255) No NULL COMMENT' short name ', `country_id` INT (11) unknown, primary key (` ID`), index `fk_cities_countries` (` country_id` ASC)) engine = InnoDB;  

Comments