After the lesson (Creating a Table). I tried attempting the exercise, which is;
Create the “customers” table in the “sales” database. Let it contain the following 5 columns: customer_id, first_name, last_name, email_address, and number_of_complaints. Let the data types of customer_id and number_of_complaints be integer, while the data types of all other columns be VARCHAR of 255.
But it didn’t pull through when I input the execute icon, showing me an error message. This is my attempt
CREATE TABLE customers,
Then I press execute. But its giving me an error message. Please assist me. What am I doing wrong
Commas, you forget commas, my friend.
You should not use comma after table name ‘customers’. And you have to use commas in the end of each expression in brackets except the last one.