An ERROR 1064 occurs while creating a table using MySQL

Question

I'm creating a new table after starting MySQL service.

I code it at Win10, on MySQL 8.0 command line Client. The code now is shown as below:

create table 't8' ('id1' timestamp not null default current_timestamp,'id2' datetime default null);

Then I got an error while I was executing it:

ERROR 1064 (42000): 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 ''t8' ('id1' timestamp not null default current_timestamp,'id2' datetime defaul' at line 1

What should I do to fix it?

Remove the ' around the tables and column names and replace it with ` — Thallius, Sep 25 '19 at 06:55
https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql — P.Salmon, Sep 25 '19 at 07:17

score 0 · Accepted Answer · answered Sep 25 '19 at 06:56

0

Use it like this.

create table t8 (
    `id1` timestamp not null default current_timestamp,
    `id2` datetime default null
);

answered Sep 25 '19 at 06:56

Bilal Ahmed

119
1
11

Because table and column names are not meant to define with single quote notation, because according to sql code syntax the way to define table and columns is this ` You can check in phpmyadmin or any other tool to generate any query like create update or delete. – Bilal Ahmed Sep 27 '19 at 07:18

score 0 · Answer 2 · answered Sep 25 '19 at 06:56

0

Try below - instead of single quote '' you need to use back tick `` or you can keep it just id1 or id2

create table t8
(
  id1 timestamp not null default current_timestamp,
  id2 datetime null
)

answered Sep 25 '19 at 06:56

Fahmi

37,315
5
22
31

An alternative way! Thx~ – Eve Liu Sep 26 '19 at 00:46

An ERROR 1064 occurs while creating a table using MySQL

2 Answers2