23:44:21 unique key (email_adress) Error Code: 1064. You have an error in your SQL syntax; check the
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
2 answers ( 0 marked as helpful)
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
Please, I am having error code i creating sql table. Erroe 1094