My SQL; You have error in your SQL syntax error

Question

The table Book_Details is described here :-

This is the Category_Details Table :-

This is the Binding_Details Table :-

i dont understand what the syntax error is ?

Possible duplicate of [When to use single quotes, double quotes, and back ticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-back-ticks-in-mysql) — Madhur Bhaiya, Nov 12 '18 at 08:55

score 1 · Answer 1 · answered Nov 12 '18 at 08:48

The syntax of your insert query is incorrect. You have insert into table SOMETABLE(column1, column2,...

This must be like insert into SOMETABLE (column1, column2...) VALUES (...

score 0 · Answer 2 · answered Nov 12 '18 at 08:52

0

Please remove the keyword TABLE in your insert query. Then it will work fine

answered Nov 12 '18 at 08:52

Seena V P

2 Answers2