MySQL: the difference between ', `,' and"

Question

When viewing SQL code on the Internet and in manuals, it seems that a lot of what is used to label strings (or at least what I think they do?) Changes a lot.

Is there a difference between using `, ',' or '? Are they all the same? Or do some of them have special meanings? Should some be used in some cases and others in other cases?

Answer 1

`` limits identifiers and 'and' limits lines. Between the last two

'does not make sense in mysql

Answer 2

Backticks (`) , , , , . , , :

SELECT `from`, to FROM messages WHERE to = 'Joe';

, WHERE . .

:

• MySQL 5.1