2015-12-12 22:50 GMT+01:00 Keith Medcalf <kmedcalf at dessus.com>: > > > One other point: The use of grave accents to quote column names is a > > > mysql-ism. SQLite also supports that for compatibility. But you > > > still shouldn't do it. The proper SQL-standard way is double-quote. > > > ?That is funny: I did not use them at first (or double). But I am using > 'DB > > Browser for SQLite' and this shows those, so I thought that > > ?I should use them.? > > Like the Windows Veneer of Long File Names and permitting embedded > "special characters" in filenames, you only need to use quotes identifying > field names if you are making the atrocious error of using restricted > symbols or words as column names. If you do not do that, then you do not > need them. >
?I can go back to not using them. :-D -- Cecil Westerhof
