Last answered:

25 Nov 2023

Posted on:

15 Nov 2023

0

INSERT INTO customers (first_name, last_name, gender, email_address, number_of_complaints) VALUES ('

After running the code , i get the error message as seen above yet am following the lecture.

kindly help me on this


2 answers ( 0 marked as helpful)
Posted on:

17 Nov 2023

0

Bro, I alos got the same error saying Error Code 1364: Field "customer_id" doesn;t have default view.
for this write:
insert into customers(customer_id,first_name,last_name,gender,email_address,number_of_complaints)
values('1','john','mackinley',m',johnmackinley@365datascience.com',0)
Run this code, hope it'll resolve.

Instructor
Posted on:

25 Nov 2023

0

Hi Simon and Mirza!

Thanks for reaching out.


@Mirza: Thank you very much for sharing a relevant solution!

@Simon: Can you please double check that you've previously executed the same CREATE TABLE customers query as the one shown in the course? If not, please ensure you've used the one we've shared. If yes, please feel free to specify the error message you obtained, Mirza? 


Hope this helps.
Best,
Martin

Submit an answer