0 55 00:22:30 ALTER TABLE customers ADD COLUMN gender ENUM('M', 'F') AFTER last_name Error Code: 10

in SQL / UNIQUE Constraint

i face this problem when I execute the code in assignment

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

14 Nov 2022

Hi Ahmed!
Thanks for reaching out!

Could you please support your question with the entire code you’ve executed, as well as a screenshot containing the entire error message you’ve encountered? This can help us assist you better. Thank you.

Looking forward to your answer.
Best,
Tsvetelin

Submit an answer

related questions

Rhys Morgan

Rollback not reverting DB state after using INSERT INTO

Islam Elkhateeb

Resolved: can't add row, I do may trail and it all back with errors

THOMAS BELL

14. SQL JOINs - Error Code: 1055 (only_full_group_by)

Harsha Dharmabandu

Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty

Sivarajan Sivakumar

Cannot insert 999903 into the dept_emp table?

yenni kosasih

error code 1140 : in aggregated query without group by

Donald Trenholm

Resolved: Getting error code 1140 even after trying the fixes.

Christopher Watts

Error Code: 1364. Field 'customer_id' doesn't have a default value