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

Question

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

kindly help me on this

Answer 1

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.

Answer 2

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

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

Submit an answer

related questions