02-07-2006, 12:12 PM
Quote:eazy wrote:
The quotes are a specialty of mySql. In SQL language you don't need quotes for field names - and you can leave them away in mySql as well,
but if you set them it doesn't matter. Field names with blanks are not allowed anyway.
Yes they are, I use some aircraft names, that need special certification in our VA, as field names in the user_profile table, and they have blanks and
the "-" character. The only thing is you need to use the "`" character to quote them, otherwise MySQL will get the first characters until the first
blank as the field name.