Question: While loading data into a database into MySQ, I get the following error: Syntax error: INSERT (insert) is not valid input at this position. Here

While loading data into a database into MySQ, I get the following error: Syntax error: "INSERT" (insert) is not valid input at this position.

Here is the data.

INSERT INTO EMPLOYEE VALUES( 'George', 'Jones', 'Production', '360-287-8620', 'George.Jones@WPC.com'); INSERT INTO EMPLOYEE VALUES( 'Ken', 'Numoto', 'Marketing', '360-287-8710', 'Ken.Numoto@WPC.com'); INSERT INTO EMPLOYEE(FirstName, LastName, Department, Email) VALUES('James', 'Nestor', 'InfoSystems', 'James.Nestor@WPC.com')

(This is where I get the error) INSERT INTO EMPLOYEE VALUES( 'Rick', 'Brown', 'InfoSystems', '360-287-8820', 'Rick.Brown@WPC.com');

I am loading the info straight from the Database book but not sure what I am missing.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!