What happens if i name a field in a mysql table with "when"

Question

I created a table with 3 columns ID (Primary key), when (some varchar value), Created_date(timestamp)

Will naming a field with "When" creates any issue?

I have been querying like update table set table.when='$when' where ID='1'

Please suggest

Ya sure, But actually i have a huge collection of web services, and so i have to alter them. Thanks — Ramaraju.d, Feb 01 '13 at 09:03

score 7 · Accepted Answer · answered Feb 01 '13 at 08:51

7

it's ok as long as you have to use the tableName along with the column name

update `table` 
set `table`.when='$when' 
where ID='1'

otherwise, wrap it with backticks

update `table` 
set `when`='$when' 
where ID='1'

Other Link:

if possible don't use names or identifiers which are on the reserved keyword list to avoid problems.

answered Feb 01 '13 at 08:51

John Woo

if i make sure that i place a back ticks as 'when', code will not be effected right? By mistake i have added system reserved keyword. Thanks for your reply @JW – Ramaraju.d Feb 01 '13 at 08:59
yes but be sure that you will use backticks and not singe quotes. `:D` – John Woo Feb 01 '13 at 09:08

1 Answers1