how do you insert to a column name that is similar to an SQL statement? in MySQL

Question

Hi I have a column name called "condition", and I don't know if this is an SQL statement but its in color pink in my phpmyadmin sql. so how do you insert to a column that shares the same name to an SQL statement. I could just change it to another variable but this idea have me intrigued. I tried this:

How to deal with SQL column names that look like SQL keywords?

but it only works for select statements.

So does anyone have an idea how to do this using Insert, Update, and Delete?

Thank you

score 5 · Accepted Answer · answered May 23 '13 at 21:18

5

These words are called reserved words and in MySQL you will need to escape them using backticks:

insert into yourtable (`condition`)
select yourValue
from yourOtherTable;

My suggestion would be to stay away from using these words for tables and columns.

answered May 23 '13 at 21:18

Taryn

242,637
56
362
405

1

Backtick = left of the '1' key, in case you don't use it often. – Hart CO May 23 '13 at 21:19
left of 'z' on Mac! ;) – Matt Humphrey May 23 '13 at 21:21
1

or left of backspace with german layout. but i guess we should stop this ;) – Marco Forberg May 23 '13 at 21:22
@MarcoForberg we'll never know when we'll be using a foreign keyboard so might as well continue lol – magicianiam May 23 '13 at 21:25
3

ALT+'9' then '6' universal backtick? – Hart CO May 23 '13 at 21:30
Num9 and Num6 would be more precise ;) – Marco Forberg May 23 '13 at 21:34

score 1 · Answer 2 · answered May 23 '13 at 21:20

1

In mySQL you can use

`condition`

instead of

[condition]

of mssql

answered May 23 '13 at 21:20

Domus71

151
1
5

how do you insert to a column name that is similar to an SQL statement? in MySQL

2 Answers2