mysql create table ... what am i doing wrong

Question

  CREATE TABLE 'behandelingen' (
  'behandeling_id' int(10) NOT NULL auto_increment,
  'behandeling' varchar(35) NOT NULL default '',
  'kosten' float NOT NULL default '0',
  'bank_reknr' varchar(20) NOT NULL default '',
  PRIMARY KEY  ('behandeling_id'),
  UNIQUE KEY 'behandeling' ('behandeling')
);

Trying to import a database / tables to a my local server using phpmyadmin. I keep coming up with the following 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 ''behandelingen' ( 'behandeling_id' int(10) NOT NULL auto_increment, 'behan' at line 1 Static analysis:

4 errors were found during analysis.
A symbol name was expected! (near "'behandeling_id'" at position 34)
At least one column definition was expected. (near "'behandeling_id'" at position 34)
Unexpected beginning of statement. (near "10" at position 55)
Unrecognized statement type. (near "NOT NULL" at position 59)

can some one shed some light on it ... I am using Server version: 5.7.14 - MySQL Community Server (GPL)

Possible duplicate of When to use single quotes, double quotes, and backticks in MySQL — Jens
– Jens, Commented Aug 11, 2017 at 6:11

Zayn Ali · Accepted Answer · 2017-08-11 08:37:34Z

1

Use backticks instead of single quotes on the table name and column names. See below:

CREATE TABLE `behandelingen` (
    `behandeling_id` int(10) NOT NULL auto_increment,
    `behandeling` varchar(35) NOT NULL default '',
    `kosten` float NOT NULL default '0',
    `bank_reknr` varchar(20) NOT NULL default '',
    PRIMARY KEY  (`behandeling_id`),
    UNIQUE KEY `behandeling` (`behandeling`)
);

edited Aug 11, 2017 at 8:37

Zayn Ali

4,9351 gold badge32 silver badges41 bronze badges

answered Aug 11, 2017 at 5:15

Avery

647 bronze badges

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

3 Comments

Apurva Over a year ago

so the only issue was i should remove the single quotes ???? ... it does work... but this was never an issue ...any ideas why the quotes are an issue all of a sudden ?

Avery Over a year ago

you should use ` , not ' :-)

Apurva Over a year ago

I chose this ..as it was the first answer

Faisal Rehman · Accepted Answer · 2017-08-11 05:35:29Z

1

CREATE TABLE behandelingen ( behandeling_id int(10) NOT NULL auto_increment, behandeling varchar(35) NOT NULL default 'default' , kosten float NOT NULL default 0, bank_reknr varchar(20) NOT NULL default 'default' , PRIMARY KEY (behandeling_id), UNIQUE KEY behandeling (behandeling) );

answered Aug 11, 2017 at 5:35

Faisal Rehman

1621 silver badge5 bronze badges

Comments

Rudy Palacios · Accepted Answer · 2017-08-11 05:20:14Z

0

I can't test it right now, but I think that you shouldn't be using single quotes to define the name of the column: e.g.

CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );

answered Aug 11, 2017 at 5:20

Rudy Palacios

1322 silver badges8 bronze badges

Collectives™ on Stack Overflow

mysql create table ... what am i doing wrong

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

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

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

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related