Page 2 of 2
Posted: Tue Feb 14, 2006 2:03 pm
by ody
Well I just implemented a new module in the system I develop.. I use replication to two slaves (MySQL) and the slaves are V5 the master V4, and once apon a time I thought the use of backticks was overkill.. untill today. Turns out a simple addition of a reserved word in V5 did not effect offcourse the master V4 but caused the halt of both replicaton servers that keep the running backups.. I eat my own hat. Use the backticks!
Posted: Tue Feb 14, 2006 2:09 pm
by mikebr
I now use back ticks in all my queries and have been since the time I got replies to my post... always!
Thanks for the warning.
Posted: Mon Feb 20, 2006 3:32 am
by CoderGoblin
We had a situation once where backticks were required using Postgres. The reason, simply mixing upper and lowercase in table names. Hence we now always use all lowercase. Haven't run into any problems. I have heard ORACLE requires all uppercase characters for tablenames though...
Posted: Mon Feb 20, 2006 4:22 am
by JayBird
Yep, i pretty much always use backticks now, after i moved an application from one server to another which required backticks for queries to work.
Not a bad habit to get into