56,678
社区成员
发帖
与我相关
我的任务
分享
mysql> select B.id,B.stuname,B.stuid from jj.ks_studentdata as B where B.stucode="31!36!32!";
+-------+----------+-----------+
| id | stuname | stuid |
+-------+----------+-----------+
| 22866 | 228CAC82 | 31!36!32! |
+-------+----------+-----------+
1 row in set (0.05 sec)
mysql> select B.id,B.stuname,B.stuid from jj.ks_studentdata as B where B.stucode="31!36!32!"; +-------+----------+-----------+ | id | stuname | stuid | +-------+----------+-----------+ | 22866 | 228CAC82 | 31!36!32! | +-------+----------+-----------+ 1 row in set (0.05 sec)
SELECT * FROM ks_studentdata stucode = "31!36!32!"