[dameon51]

Hey everyone. I've noticed that on some of the tools I use the produce sql code they put single quotes around table names and field names, so it would look like

select 'someField' from 'your_table'

Any idea why they add these? Just curious

[Ionut]

This way you can use reserved words as table names or column names(words like select, date).
Single quotes are used in MySQl, MSSQL uses square brackets. In MSSQL, using square brackets also permits you to use space in the name of the column/table(e.g. [Column Name])

[Atli]

Ionut, on 06 December 2011 - 03:21 PM, said:

Single quotes are used in MySQl

Actually, that's not correct. MySQL uses back-ticks (`) for identifiers and single-quotes (') for string values.

If you use single-quotes for database or table names, you will get a syntax error. If you use single-quotes for column names, you will get the column name as the value for every row. (Reads as: "Select the following string(s) for every row in the table.")

This post has been edited by Atli: 11 December 2011 - 03:29 AM

[ReekenX]

This is also documented in Mysql official documentation.

[Ionut]

Quote

MySQL uses back-ticks (`)

I always saw that character as being single quote. I thought that the form is from the font.

This post has been edited by Ionut: 19 December 2011 - 08:14 AM