We read your photo as:

How do I fix the SQL error 'ERROR 1064 (42000): You have an error in your SQL syntax' when inserting data into Employee and Salary tables?

Computer Science

ScanSolve AI Answer

This answer stops before the end.

It was cut off when it was first written. Ask ScanSolve this question again for the full working.

The error ERROR 1064 (42000): You have an error in your SQL syntax occurs because the VALUES clause cannot stand alone; it must be part of an INSERT INTO statement. Additionally, you need to insert data into two separate tables: Employee and Salary.

Here are the corrected SQL commands to add the new employee and their salary:

Step 1: Insert the new employee into the Employee table.
The BonusMonth column is a generated column, so it should not be included in the INSERT statement.

INSERT INTO Employee (EmpID, FirstName, LastName, Email, DeptID, DOE) \\ \text{VALUES (11, 'Erasmus
Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp