I got some problem on my button. Any ideas, please?
Asked
Active
Viewed 83 times
-3

Shayan Shafiq
- 1,447
- 5
- 18
- 25

C1sc0
- 21
- 4
-
3Possible duplicate of [Insert into certain columns](https://stackoverflow.com/questions/11087410/insert-into-certain-columns) – Teneko Oct 18 '17 at 04:13
-
2Correct usage: `INSERT INTO [TableName] (column1, column2, ...) VALUES (value1, value2, ...)`. If the column name contains spaces, wrap it inside square brackets, e.g. `[Column Name]` (NB: avoid using spaces as column name). – Tetsuya Yamamoto Oct 18 '17 at 04:23
1 Answers
3
The insert query you are executing is wrong, it should be
INSERT INTO <TABLE_NAME> (<COLUMN1, COLUMN2, ...>) VALUES (<VALUE1, VALUE2, ...>)
You just have written VALUE
instead of VALUES
and there is no comma between column names

Ipsit Gaur
- 2,872
- 1
- 23
- 38