create table customers ( customer_id int primary key, first_name varchar(10), last_name varchar(10), email_adress varchar(10), number_of_complains int, unique key (email_adress) ); try this and find this code problem

Hi Ahmed! Thanks for reaching out. I tested the code and also obtained the same error. Then, run it again without the empty space between the UNIQUE KEY and () like this UNIQUE KEY(). Both are correct but sometimes Workbench gives an error when there are some additional spaces. So, we need to stick to the good practices. Hope this helps. Best, Tsvetelin

Follow this topic

Ahmed Hesham

Last answered:

14 Nov 2022

Posted on:

11 Nov 2022

23:44:21 unique key (email_adress) Error Code: 1064. You have an error in your SQL syntax; check the

in SQL / UNIQUE Constraint

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

14 Nov 2022

23:44:21 unique key (email_adress) Error Code: 1064. You have an error in your SQL syntax; check the

Submit an answer

related questions