MySQL Identifiers(标识符)

database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object这些在mysql中都被称为标识符(identifiers)

select是关键字,所以在使用select作为标识符时需要加上`,一般不需要加反引号和引号

SELECT * FROM `select` WHERE `select`.id > 100;

参考:
https://dev.mysql.com/doc/refman/8.0/en/literals.html