Create a table in mysql

Question

Here is the mysql code. I can't find the error here. when I execute this bunch of code it shows syntax error.

 CREATE TABLE Movie(
-> title            varchar(100),
-> year             int,
-> length           int,
-> inColor          BIT(1),
-> studioName       varchar(50),
-> producerC#       int,
-> PRIMARY KEY      ('title'));

I would recommend removing the # from the column producerC#, it's a non standard character and may cause problems further down the line. — Nigel Ren
– Nigel Ren, Commented Jul 5, 2017 at 6:19

Surya · Accepted Answer · 2017-07-05 05:30:24Z

2

Try this. You have quotes in the primary key!

CREATE TABLE `movie` (
  `title` VARCHAR(100),
  `year` INT(11),
  `length` INT(11),
  `inColor` BIT(1),
  `studioName` VARCHAR(50),
  `producerC#` INT(11),
  PRIMARY KEY (`title`)
)

answered Jul 5, 2017 at 5:30

Surya

437 bronze badges

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

1 Comment

Fabian Pijcke Over a year ago

+1 to counterbalance -1. This answer is clearer than the other as it explains where the problem comes from.

Aman Sahni · Accepted Answer · 2017-07-05 05:20:11Z

1

You can use below query to create table:

CREATE TABLE Movie(
title VARCHAR(100) PRIMARY KEY,
year INT,
length INT,
inColor BIT(1),
studioName VARCHAR(50),
producerC# int
)

answered Jul 5, 2017 at 5:20

Aman Sahni

2121 silver badge8 bronze badges

Comments

Shashank M · Accepted Answer · 2017-07-05 05:50:16Z

0

CREATE TABLE `movie` (
  `title` VARCHAR(100),
  `year` INT(11),
  `length` INT(11),
  `inColor` BIT(1),
  `studioName` VARCHAR(50),
  `producerC#` INT(11),
  PRIMARY KEY (`title`)
)

answered Jul 5, 2017 at 5:50

Shashank M

3163 silver badges11 bronze badges

Collectives™ on Stack Overflow

Create a table in mysql

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related