cant't create table in sql

Question

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?

Answer 1

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

Answer 2

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

Answer 3

Hi
I had the same problem, you have to specify the name of the database in this way:
put "use [name of the database]" before the first sentence.

Answer 4

Hi Mehraveh!
Thanks for reaching out.

Thanks for sharing this piece of information with the Community!
The statement terminator (i.e. the semi-colon ;) after CREATE TABLE sales should be removed.

Hope this helps.
Best,
Tsvetelin

cant't create table in sql

Submit an answer

related questions