Insert single numerical value into MySQL column

Question

The query I'm trying to run is:

INSERT INTO albumtest (on) VALUES ('3')

Server type: MySQL Server version: 5.6.21

Syntax Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on) VALUES ('3')' at line 1

I've been looking over this for almost a day now, and I can't seem to figure out why I'm getting this syntax error.

Full code is here: http://pastebin.com/6mMbZ1Y1

But I know the rest of it is fine, because it can run other queries fine (such as $sql = "INSERT INTO gallery (title) VALUES ('".$title."')";)

you need to wrap the ``on`` into tick... maybe because it is a reserve word.. — Sam Teng Wong, Jul 22 '15 at 10:04
Yes, `ON` is in the [MySQL list of Reserved Words](https://dev.mysql.com/doc/refman/5.6/en/keywords.html) — Mark Baker, Jul 22 '15 at 10:27

score 2 · Accepted Answer · answered Jul 22 '15 at 10:04

2

this is the correct syntax

INSERT INTO `albumtest` (`on`) VALUES ('3')

answered Jul 22 '15 at 10:04

Ehab Eldeeb

722
4
12

Wow, It was originally order but I shortened it because I assumed 'order' would of been a keyword. Thanks for the fast reply. – user3529649 Jul 22 '15 at 10:09
you're welcome :) .. use the backticks always, even if the word is not reserved, and peace your mind – Ehab Eldeeb Jul 22 '15 at 10:10
Still getting the syntax error >.< Error: INSERT INTO albumtest ('on') VALUES ('3') – user3529649 Jul 22 '15 at 10:53
use `on` not 'on' .. use backtick not apostrophe – Ehab Eldeeb Jul 22 '15 at 10:55

score 1 · Answer 2 · answered Jul 22 '15 at 10:04

1

ON is reserved keyword of mysql it should be write inside backtics

INSERT INTO albumtest (`on`) VALUES ('3')

answered Jul 22 '15 at 10:04

Saty

22,443
7
33
51

score 0 · Answer 3 · answered Jul 22 '15 at 10:04

0

on is MySql reserved keyword. Dont use it as column name.

answered Jul 22 '15 at 10:04

syed suleman

542
2
6

do not answer if already same answer is present – LOKESH Jul 22 '15 at 10:07
they are both answered at the same time – Royal Bg Jul 22 '15 at 10:13

Insert single numerical value into MySQL column

3 Answers3