Mysql Statments
#4

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 `.

Код:
CREATE TABLE IF NOT EXISTS example (
    `update` INT NOT NULL DEFAULT '0'
);
This would work, you would have a column named "update". But I'm sure this isn't common practice.
Reply


Messages In This Thread
Mysql Statments - by nezo2001 - 04.06.2015, 14:04
Re: Mysql Statments - by Luis- - 04.06.2015, 14:06
Re: Mysql Statments - by Konstantinos - 04.06.2015, 14:09
Re: Mysql Statments - by dusk - 04.06.2015, 16:28
Re: Mysql Statments - by nezo2001 - 05.06.2015, 10:17
Re: Mysql Statments - by Konstantinos - 05.06.2015, 10:24
Re: Mysql Statments - by nezo2001 - 05.06.2015, 10:38
Re: Mysql Statments - by dusk - 05.06.2015, 10:42
Re: Mysql Statments - by nezo2001 - 05.06.2015, 10:52
Re: Mysql Statments - by Konstantinos - 05.06.2015, 10:56

Forum Jump:


Users browsing this thread: 2 Guest(s)