CODEWITHSUNDEEP
mysql
Jordan Hochstetler
Jordan Hochstetler

Reputation: 1416

Simple Create Table error

I don't understand why I am getting an error at the dateCreated line.

CREATE TABLE 'MediaContent'(

media_id int(11),
tag varchar(255),
dateCreated varchar(255),
title varchar(255),
subtitle varchar(255),
rating int(1),
dataLocation varchar(255)
PRIMARY KEY (media_id)
)

Upvotes: 0

Views: 20

Answers (1)

juergen d
juergen d

Reputation: 204924

Use backticks to escape column and table names, not quotes

CREATE TABLE `MediaContent`
(
    media_id int(11) PRIMARY KEY,
    tag varchar(255),
    dateCreated varchar(255),
    title varchar(255),
    subtitle varchar(255),
    rating int(1),
    dataLocation varchar(255)
)

Upvotes: 3

Related Questions