MySql error in syntax

Question

I am trying to create these two tables for a simple script I downloaded but when running the sql command it returns a syntax error.

The error I get is:

CREATE TABLE `usrsig` (
  `id` int(9) NOT NULL auto_increment,
  `url` varchar(255) default NULL,
  `user` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
  KEY `user_own` (`user`) 
);

#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 'KEY `user_own` (`user`) )' at line 6

And the following for the 2nd tabel:

CREATE TABLE `usruser` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `pass` varchar(30) default NULL,
  `last` datetime default NULL,
  `hits` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
  KEY `name_index` (`name`) 
);

#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 'KEY `name_index` (`name`) )' at line 8

If anyone could be so kind as to help me out I would be greatly appreciative.

Thanks

Michael Berkowski · Accepted Answer · 2012-01-25 03:49:37Z

2

You're just missing a comma after PRIMARY KEY (id)

CREATE TABLE `usrsig` (
  `id` int(9) NOT NULL auto_increment,
  `url` varchar(255) default NULL,
  `user` int(9) NOT NULL default '0',
  /* Comma needed... */
  PRIMARY KEY  (`id`),
  KEY `user_own` (`user`) 
);


CREATE TABLE `usruser` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `pass` varchar(30) default NULL,
  `last` datetime default NULL,
  `hits` int(9) NOT NULL default '0',
  /* Comma needed... */
  PRIMARY KEY  (`id`),
  KEY `name_index` (`name`) 
);

As a tip, about 99% of the time, the error as reported by MySQL occurs exactly one character before the place identified. So look one character or symbol before KEY name_index:

check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY name_index

answered Jan 25, 2012 at 3:49

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

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

2 Comments

Barry Schulman Over a year ago

Thank you so much 100% spot on. Sorry only got to answer now but system never informed me of answer to my post. Thanks again

Michael Berkowski Over a year ago

@BarrySchulman Welcome to Stack Overflow. Unlike other forums and things, answers here come within mintes or seconds of asking questions for all but the most esoteric things. So next time check back right away. We'll help out and send you along on your way :)

jgritty · Accepted Answer · 2012-01-25 03:50:25Z

0

I think you are just missing a comma after the PRIMARY KEY ('id') line.

answered Jan 25, 2012 at 3:50

jgritty

12k3 gold badges41 silver badges62 bronze badges

Comments

gprathour · Accepted Answer · 2012-01-25 03:51:24Z

0

The way you are putting Primary key and other key is the syntax problem.

Primary Key (id),

Put a comma after this.

answered Jan 25, 2012 at 3:51

gprathour

15.4k5 gold badges72 silver badges92 bronze badges

Comments

Dennis · Accepted Answer · 2012-01-25 03:53:38Z

0

CREATE TABLE usrsig (
  id int(9) NOT NULL  AUTO_INCREMENT,
  url varchar(255) DEFAULT NULL,
  user int(9) NOT NULL DEFAULT 0,
  PRIMARY KEY  (id),
  KEY user_own (user) 
);

CREATE TABLE usruser (
  id int(9) NOT NULL  AUTO_INCREMENT,
  name varchar(30) NOT NULL DEFAULT '',
  pass varchar(30) DEFAULT NULL,
  last datetime DEFAULT NULL,
  hits int(9) NOT NULL DEFAULT 0,
  PRIMARY KEY  (id),
  KEY name_index (name) 
);

answered Jan 25, 2012 at 3:53

Dennis

4,0277 gold badges28 silver badges44 bronze badges

Comments

Khan · Accepted Answer · 2021-07-03 18:13:24Z

0

Any primary key error - fix

//delete all

Drop-Database
Remove-Migration
Remove-Migration
Remove-Migration until you clear all migration
Add-Migration
Update-Database

success

answered Jul 3, 2021 at 18:13

Khan

1491 silver badge4 bronze badges

Collectives™ on Stack Overflow

MySql error in syntax

5 Answers 5

2 Comments

Comments

Comments

Comments

Any primary key error - fix

success

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Any primary key error - fix

success

Comments

Your Answer

Sign up or log in

Post as a guest

Related