Search code examples
mysqlmysql-error-1064

MYSQL - Cannot able to create table

I am using MYSQL 5.1. When i am going create a table, it throws error like this,

Query:

CREATE TABLE IF NOT EXISTS payment_status (
  STATUS_ID int(3) unsigned NOT NULL DEFAULT '0' ,
  STATUS_NAME varchar(50) NOT NULL DEFAULT '' ,
  DESC varchar(100) ,
  PRIMARY KEY (STATUS_ID),
  UNIQUE KEY XPKPAYMENT_STATUS (STATUS_ID)
)

Error:

Error Code : 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 'DESC varchar(100) ,
  PRIMARY KEY (STATUS_ID),
  UNIQUE KEY XPKPAYMENT_STATUS (S' at line 4
(0 ms taken)
Solution

  • DESC is a reserved word, wrap it around with backticks..

    `DESC`