- 论坛徽章:
- 0
|
回复 #6 枫影谁用了 的帖子
库用的是utf编码 之前我也一直觉得是 编码问题 但后面查看后觉得不像
+----------------+--------------------------+------+-----+----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------------------+------+-----+----------+----------------+
| id | int(4) unsigned | NO | PRI | NULL | auto_increment |
| name | char(64) | NO | PRI | NULL | |
| placard | char(12 | YES | | NULL | |
| business_name1 | char(32) | YES | | 会长 | |
| business_name2 | char(32) | YES | | 副会长 | |
| business_name3 | char(32) | YES | | 理事 | |
| business_name4 | char(32) | YES | | 精英 | |
| business_name5 | char(32) | YES | | 会员 | |
| business_name6 | char(32) | YES | | 见习会员 | |
| found | int(4) unsigned zerofill | YES | | 0000 | |
| bijou | int(4) unsigned zerofill | YES | | 0000 | |
| LV | int(4) unsigned | YES | | 0 | |
| honor | int(4) unsigned zerofill | YES | | 0000 | |
| altar_info | varchar(1000) | YES | | NULL | |
| camp | tinyint(1) unsigned | NO | | 2 | |
+----------------+--------------------------+------+-----+----------+---------------
回复 #7楼 的帖子
select 本身并没有问题 ,只有在存储过程时会出这个问题。是在本机的终端上执行的并不会有网络问题。show processlist.没有发现任何执行语句,CPU也没占用。 |
|