mysql字段名是否可以为中文?
CREATE TABLE `zhichu` (
`id` INT( 3 ) NOT NULL ,
`品名` VARCHAR( 10 ) NOT NULL ,
`型号` VARCHAR( 8 ) NOT NULL ,
`个数` INT( 3 ) NOT NULL ,
`日期` DATE( 12 ) NOT NULL ,
`deal` VARCHAR( 6 ) NOT NULL
)
我用phpmyadmin创造的结果报错
MySQL 返回:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(12) NOT NULL, `deal` VARCHAR(6) NOT NULL)' at line 1
[文档]