Page 2 of 2

Posted: Wed Jan 10, 2007 1:26 pm
by Ollie Saunders
boo_lolly wrote:you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL

Posted: Wed Jan 10, 2007 1:38 pm
by feyd
from what I've been told and see, backticks are a construct specific to MySQL.. so unless you know for absolute certainty that you aren't going to use another database management system, backticks are fine. It's better to use field and table names that aren't keywords more. :)

Posted: Wed Jan 10, 2007 1:39 pm
by Ollie Saunders
from what I've been told and see, backticks are a construct specific to MySQL..
Really?! Wow. But they are such a good idea in a keyword based language though.

Posted: Wed Jan 10, 2007 3:04 pm
by RobertGonzalez
I haven't found another RDBMS that uses backticks. I use them in my procedures, but not so much in direct calls (though those are going down dramatically now).

Posted: Wed Jan 10, 2007 3:23 pm
by volka

Posted: Wed Jan 10, 2007 10:22 pm
by RobertGonzalez
Dude, is there anything that you don't know (or can't find)? You got my vote for most helpful this year bro.

Posted: Thu Jan 11, 2007 9:17 am
by boo_lolly
ole wrote:
boo_lolly wrote:you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL
ole is pretty helpful too =)

Posted: Thu Jan 11, 2007 9:51 am
by Ollie Saunders
boo_lolly wrote:
ole wrote:
boo_lolly wrote:you've got back-ticks (`) around vehicles-temp, not single quotes (').
That is an encouraged practice in SQL
ole is pretty helpful too =)
Eh up! This year is going to be competitive :D