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
Get step-by-step solutions from verified subject matter experts
