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?

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

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

Follow this topic

Longyin Li

Last answered:

15 Jul 2021

Posted on:

12 Jul 2021

cant't create table in sql

in SQL / Creating a table

2 answers ( 0 marked as helpful)

Longyin Li

Posted on:

14 Jul 2021

Martin Ganchev

Posted on:

15 Jul 2021

cant't create table in sql

Submit an answer

related questions