mysql syntax error why?

Question

mysql query

CREATE TABLE IF NOT EXISTS 'sadakin'.'gcm_users' (

     'id' int( 11 ) NOT NULL AUTO_INCREMENT ,
     'gcm_regid' text,
     'name' varchar( 50 ) NOT NULL ,
     'email' varchar( 255 ) NOT NULL ,
     'imei' varchar( 20 ) NOT NULL ,
     'created_at' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
     PRIMARY KEY ( 'id' ) ,
     KEY 'imei' ( 'imei' ) 
    ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

Error message:

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 ''sadakin'.'gcm_users' (

      'id' int( 11 ) NOT NULL AUTO_INCREMENT ,
          'gcm_' at line 1

I don't find error. Help me!

Sirko · Accepted Answer · 2014-03-28 06:48:00Z

4

Use backticks to enclose identifiers. Quotes are just for strings:

CREATE TABLE IF NOT EXISTS `sadakin`.`gcm_users` (

         `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
         `gcm_regid` text,
         `name` varchar( 50 ) NOT NULL ,
         `email` varchar( 255 ) NOT NULL ,
         `imei` varchar( 20 ) NOT NULL ,
         `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
         PRIMARY KEY ( `id` ) ,
         KEY `imei` ( `imei` ) 
        ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

answered Mar 28, 2014 at 6:48

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

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

1 Comment

sadakin Over a year ago

The basic mistake. Thank You

Mad Angle · Accepted Answer · 2014-03-28 06:54:54Z

0

There is no need of any single quotes on column names

CREATE TABLE IF NOT EXISTS sadakin.gcm_users (

         id int( 11 ) NOT NULL AUTO_INCREMENT ,
         gcm_regid text,
         name varchar( 50 ) NOT NULL ,
         email varchar( 255 ) NOT NULL ,
         imei varchar( 20 ) NOT NULL ,
         created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
         PRIMARY KEY ( id ) ,
         KEY imei ( imei ) 
        ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

answered Mar 28, 2014 at 6:54

Mad Angle

2,3301 gold badge18 silver badges33 bronze badges

Comments

Sathish D · Accepted Answer · 2014-03-28 07:16:34Z

0

You have to use back-ticks instead of single quotes. Quotes are used for string literals.

Check this: http://dev.mysql.com/doc/refman/5.0/en/string-literals.html

A string is a sequence of bytes or characters, enclosed within either single quote (“'”) or double quote (“"”)

Try:

CREATE TABLE IF NOT EXISTS `sadakin`.`gcm_users` (

     `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
     `gcm_regid` TEXT,
     `name` VARCHAR( 50 ) NOT NULL ,
     `email` VARCHAR( 255 ) NOT NULL ,
     `imei` VARCHAR( 20 ) NOT NULL ,
     `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
     PRIMARY KEY ( `id` ) ,
     KEY `imei` ( `imei` ) 
    ) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

edited Mar 28, 2014 at 7:16

answered Mar 28, 2014 at 6:57

Sathish D

5,04433 silver badges46 bronze badges

Collectives™ on Stack Overflow

mysql syntax error why?

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