How to fix SQL syntax error when inserting data with column names containing spaces in MySQL?

Question

ScanSolve AI Tutor · Accepted Answer

The error ERROR 1064 (42000): You have an error in your SQL syntax for the INSERT INTO Salary statement is due to the column name Basic Salary containing a space. In MySQL, column names with spaces must be enclosed in backticks (` ``). Here is the corrected command for inserting into the Salary table: Step 1: Ensure you have successfully inserted the employee into the Employee table first (as per the previous step). Step 2: Insert the salary details for the new employee into the Salary table, enclosing Basic Salary in backticks. INSERT INTO Salary (SalaryID, EmpID, Basic Salary, Bonus) VALUES (11, 11, 18000, NULL); Execute this command after the Employee insertion.

How to fix SQL syntax error when inserting data with column names containing spaces in MySQL?

Answer

Step-by-step solution

Ensure you have successfully inserted the employee into the `Employee` table first (as per the previous step).

Insert the salary details for the new employee into the `Salary` table, enclosing `Basic Salary` in backticks.

Still stuck on this one?

More Computer Science Questions