Create the “customers” table from Sales database
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
USE sales;
CREATE TABLE customers,
(
customers_Id INT,
first_name VARCHAR(255)
last_name VARCHAR(255)
email_address VARCHAR(255)
number_of_complaints INT
);
Then I press execute. But its giving me an error message. Please assist me. What am I doing wrong
1 answers ( 0 marked as helpful)
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.