-
UID:454667
-
- 注册时间2011-03-06
- 最后登录2018-01-17
- 在线时间5677小时
-
- 发帖6808
- 搜Ta的帖子
- 精华0
- 黑豆158
- 威望24650
- 贡献值0
- 交易币0
- 红豆426
-
访问TA的空间加好友用道具
- 发帖
- 6808
- 黑豆
- 158
- 威望
- 24650
- 贡献值
- 0
- 交易币
- 0
- 红豆
- 426
|
本文为大家介绍下使用inner join 进行查询/删除/修改,具体实现如下,学习mysql的朋也可以学习下,希望对大家有所帮助
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]--查询 [/font][/color][/backcolor]
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]SELECT tp.tp_id, tp.tpmc, tp.leveid, tp.tpdz, tp.jgm, tp.scsj, tp.pbzyid, tp.ksbfsj, tp.jsbfsj, tp.status, tp.tpbz FROM qdgl_tupian tp INNER JOIN qdgl_pqb pq [/font][/color][/backcolor]
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]ON tp.tp_id=pq.tpid WHERE pq.bfjgm='27010825' AND ps_bfsj >= '2013-01' AND ps_bfsj< 2013-05-31 ; [/font][/color][/backcolor]
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]-- 修改 [/font][/color][/backcolor]
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]UPDATE jx_lsjl jx INNER JOIN isa_gtxx gt ON jx.ckid=gt.gtbh set jx.ckid=gt.gtid WHERE gt.jgm='27010825' AND jx.jgm='27010825' ; [/font][/color][/backcolor]
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]--删除 [/font][/color][/backcolor]
- [backcolor=#ddedfb][color=#333333][font=Arial, Tahoma, Verdana, sans-serif]DELETE FROM jx_lsjl jx INNER JOIN isa_gtxx gt ON jx.ckid=gt.gtbh WHERE gt.jgm='27010825' AND jx.jgm='27010825' ; [/font][/color][/backcolor]
|