04.06.2015, 16:28
The character '`' is used to distinguish mysql keywords from field/table names.
For example, the word "update" is a mysql keyword. You CAN NOT use it as a colum name unless you surround it with `.
This would work, you would have a column named "update". But I'm sure this isn't common practice.
For example, the word "update" is a mysql keyword. You CAN NOT use it as a colum name unless you surround it with `.
Код:
CREATE TABLE IF NOT EXISTS example ( `update` INT NOT NULL DEFAULT '0' );