I cant crack insert table exercise 1 where im getting an error because im trying to insert 3 values into title which has four columns
'1997-10-01'); But there are four columns in titles: emp_no,
from_dateto_date many thanks, dean
Create table customers
Customer_ID INT auto_increment,
Primary Key (Customer_ID)
Drop table customer;
Insert into customers(Customer_ID,First_Name,Last_Name,Address,City,Post_Code,Country) Value ('18','Harry','Potter','67 Atlanta','Nantes','44000','France');
Thanks for reaching out.
What is the question exactly, please? Is it that you are referring to a "customers" database while during the course we've only created "sales" that is relevant to the "customers" table?
Other than that, your code for table creation is correct.
Hope this helps.