Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

On balance, which feels more familiar to you? More appealing?

Answered: 1 week ago