字段没找到？

Question

mysql> describe lsb_mc_tm_rkzl;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| 商品名称 | char(50) | YES  |     | NULL    |       |
| 商品条码 | char(50) | YES  |     | NULL    |       |
| 总量     | int(11)  | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
3 rows in set (0.01 sec)mysql> describe lsb_mc_tm_kc;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| 商品名称 | char(50) | YES  |     | NULL    |       |
| 商品条码 | char(50) | YES  |     | NULL    |       |
| 库存     | int(11)  | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
3 rows in set (0.00 sec)mysql> delete from lsb_mc_tm_rkzl where lsb_mc_tm_rkzl.商品名称 = lsb_mc_tm_kc.
商品名称;
ERROR 1054 (42S22): Unknown column 'lsb_mc_tm_kc.鍟嗗搧鍚嶇О' in 'where clause'

Answer 1

sigh, 最好不要用中文字段名啊。楼主这是何苦呢？

Answer 2

检查你的当前字符集设置。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码