mysql:
服务器: Localhost via UNIX socket
服务器版本: 5.1.33-log
协议版本: 10
用户: root@localhost
MySQL 字符集: UTF-8 Unicode (utf8)错误:
SQL 查询: CREATE TABLE `paynet`.`emailHistory ` (`EmailID` INT NOT NULL
) ENGINE = MYISAM ;MySQL 返回: #1103 - Incorrect table name 'emailHistory '
服务器: Localhost via UNIX socket
服务器版本: 5.1.33-log
协议版本: 10
用户: root@localhost
MySQL 字符集: UTF-8 Unicode (utf8)错误:
SQL 查询: CREATE TABLE `paynet`.`emailHistory ` (`EmailID` INT NOT NULL
) ENGINE = MYISAM ;MySQL 返回: #1103 - Incorrect table name 'emailHistory '
) ENGINE = MYISAM ;注意`emailHistory ` 中的空格!
->
-> `EmailID` INT NOT NULL
-> ) ENGINE = MYISAM ;
ERROR 1103 (42000): Incorrect table name 'emailHistory '
mysql> CREATE TABLE `test`.`emailHistory` (
->
-> `EmailID` INT NOT NULL
-> ) ENGINE = MYISAM ;
Query OK, 0 rows affected (0.05 sec)mysql> desc emailHistory;
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| EmailID | int(11) | NO | | NULL | |
+---------+---------+------+-----+---------+-------+
1 row in set (0.06 sec)