CODEWITHSUNDEEP
mysqlsqlphpmyadmin
Nistor Alexandru
Nistor Alexandru

Reputation: 5393

Create table throws an error

Hi I am trying to create a table using SQL in Mysql but I keep getting an error.Here is my code:

USE e-commerce
  CREATE TABLE `categories` (
`id` SMALLINT NOT NULL AUTO_INCREMENT,
`category` VARCHAR( 30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

When I try to run this in phpmyadmin SQL console I get this error:

#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 'CREATE TABLE `categories` ( `id` SMALLINT NOT NULL AUTO_INCREMENT, `category` ' at line 2

What am I doing wrong?

Upvotes: 0

Views: 150

Answers (3)

Patrick van Efferen
Patrick van Efferen

Reputation: 406

In your code you have 2 queries. You should always end query with a semicolon.

So try the following

USE e-commerce;
CREATE TABLE `categories` (
`id` SMALLINT NOT NULL AUTO_INCREMENT,
`category` VARCHAR( 30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Upvotes: 2

Suresh Kamrushi
Suresh Kamrushi

Reputation: 16086

Add semicolon after use

USE e-commerce;
CREATE TABLE `categories` (
  `id` SMALLINT NOT NULL AUTO_INCREMENT,
  `category` VARCHAR( 30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Upvotes: 10

Sahal
Sahal

Reputation: 4136

Missing semi-colon

 USE e-commerce;
  CREATE TABLE `categories` (
`id` SMALLINT NOT NULL AUTO_INCREMENT,
`category` VARCHAR( 30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `category` (`category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Upvotes: 2

Related Questions