I've been using MySQL and I need a column called “Status” in a table.
I know this word “Status” is a keyword in MySQL, and I would like to know if I will have problems with it if I write SQL statements like:
select t.Id, t.Name, t.Status from Table t
Or in triggers:
Set new.Status = 1;
if (new.Status <> old.Status) then
/* do something */
end if
Or should I rename it for another word?