Using MYSQL reserved words as column name
I recently ran into problem with a script that has one of it's column names as "signal". The script keeps giving erorr and failing whenever I run the SQL command. Checking MYSQL documentation, I realised that signal is one of MYSQL reserved words.
To solve this, use backticks `.
CREATE TABLE my_table (
`signal` varchar(100)
)
Remember to always use them in your queries as well eg SELECT `signal` FROM my_table
I really won't use reserved words for column names if I worked on this though, but in this case I guess I need to.
