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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started