mysql建表语句中如果列名是mysql的保留字符时,需要用到反引号(反引号不是单引号, 反应号是键盘数字1左边的按键)来特别标明。
例如我在建表是列名为 describe 和 status 为保留字符。所以建表语句为:
create table book_info(
id VARCHAR(50) PRIMARY Key,
book_ID VARCHAR(255) NOT NULL,
book_name VARCHAR(255) NOT NULL,
price FLOAT8,
count INTEGER,
`describe` VARCHAR(2048),
`status` INTEGER
)
同理在查询数据是如果查询列名为保留字段,也要用反应号来标明。
SELECT id, book_id AS bookId, book_name AS bookName, price, count, `describe`, `status`
FROM book_info AS book
WHERE book.book_Id ='123456';