I wrote the exact same code as the 'creating a table' as follows using mysql 8.0: create table sales ( purchase_number int not null primary key auto_increment, date_of_purchase date not null, customer_id int, item_code int varchar(10) not null ); However, error 1064 keeps popping up like this: May I know what's going wrong?

need to add database name in front of table name in MySql 8.0

Hi Longyin! Thanks for reaching out. Please remove the statement terminator (i.e. the semi-colon ;) after CREATE TABLE sales and retry. Hope this helps. Best, Martin

back

Follow this topic

Longyin Li

Last answered:

July 15, 2021

Posted on:

July 12, 2021

cant't create table in sql

in SQL / Creating a table

2 answers ( 0 marked as helpful)

Longyin Li

Posted on:

July 14, 2021

Martin Ganchev

Posted on:

July 15, 2021

Submit an answer

Content

cant't create table in sql

Submit an answer

related questions