MySql Error 1064 - Created using MySQL WorkBench

Question

I created this using MySQL WorkBench

CREATE  TABLE IF NOT EXISTS `bakasura_new`.`cities` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(255) NOT NULL COMMENT 'City Name' ,
  `short_name` VARCHAR(255) NOT NULL COMMENT 'Short Name' ,
  `country_id` INT(11) UNSIGNED NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_cities_countries` (`country_id` ASC) ,
ENGINE = InnoDB;

I am getting this error

MySQL said: Documentation

#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 '= InnoDB' at line 8

Daniel Vassallo · Accepted Answer · 2010-09-26 10:31:59Z

6

You have a dangling comma here:

INDEX `fk_cities_countries` (`country_id` ASC) ,

And you also have a missing parenthesis at the end:

CREATE  TABLE IF NOT EXISTS `bakasura_new`.`cities` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(255) NOT NULL COMMENT 'City Name' ,
  `short_name` VARCHAR(255) NOT NULL COMMENT 'Short Name' ,
  `country_id` INT(11) UNSIGNED NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_cities_countries` (`country_id` ASC)
) ENGINE = InnoDB;

answered Sep 26, 2010 at 10:31

Daniel Vassallo

346k72 gold badges514 silver badges447 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Vassallo Over a year ago

@Harsha M V: Just tried it myself, and it worked. Note that I removed a comma and added a closing parenthesis.

DrColossos · Accepted Answer · 2010-09-26 10:33:12Z

1

There is a ) missing at the end of the last )

INDEX `fk_cities_countries` (`country_id` ASC) )

answered Sep 26, 2010 at 10:33

DrColossos

13.1k3 gold badges49 silver badges68 bronze badges

7 Comments

Harsha M V Over a year ago

thank you. works now :D Mysql Workbench had created Constraints which i wanted to remove. guess i deleted the bracket bymistake. any idea how to export from mysql Workbench with out constraints

Daniel Vassallo Over a year ago

@Harsha: What type of constraints did Workbench create? Can you give an example?

Harsha M V Over a year ago

CREATE TABLE IF NOT EXISTS areas ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , name VARCHAR(255) NOT NULL , slug VARCHAR(255) NULL , zipcode INT(11) NULL , latitude VARCHAR(255) NULL , longitude VARCHAR(255) NULL , city_id INT(11) UNSIGNED NOT NULL , PRIMARY KEY (id) , CONSTRAINT fk_areas_cities1 FOREIGN KEY (city_id ) REFERENCES cities (id ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; CREATE INDEX fk_areas_cities1 ON areas (city_id ASC) ;

Daniel Vassallo Over a year ago

@Harsha: It looks like you want to remove the foreign key on city_id. I think you can remove the foreign key from the EER diagram: dev.mysql.com/doc/workbench/en/wb-relationship-tools.html. Just delete the link. By removing that constraint manually, you were effectively removing the constraint on the link.

Harsha M V Over a year ago

but i want the linking between the two tables. otherwise i am not able to link them right ?

|

Collectives™ on Stack Overflow

MySql Error 1064 - Created using MySQL WorkBench

#1064 - You have an error in your SQL syntax; check the manual that

2 Answers 2

1 Comment

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

#1064 - You have an error in your SQL syntax; check the manual that

2 Answers 2

1 Comment

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related