mysqlreserved-words

What is the "no" keyword used for in MySQL?


I just randomly found out that "no" is a reserved word/keyword in Mysql.

I searched on Google what is it used for, but couldn't find an answer.

Can someone explain or is there any link to article that explains each Mysql's reserved keyword usage?

https://dev.mysql.com/doc/refman/8.0/en/keywords.html


Solution

  • I searched the MySQL 8.0 grammar file, and found the NO token used in the following ways:


    For what it's worth, the NO keyword is not a reserved keyword. In the keywords documentation page you linked to, reserved keywords are noted with "(R)" but NO doesn't have that note. Therefore you can use NO as an identifier without necessarily delimiting it in back-ticks.

    mysql> create table no ( i int);
    Query OK, 0 rows affected (0.05 sec)