软件开发培训班 >> 编程开发 >> MySQL


MYSQL使用inner join 进行 查询/删除/修改示例

　　本文标签：MYSQL,inner,join

复制代码 代码如下:

--查询
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
ON tp.tp_id=pq.tpid WHERE pq.bfjgm=27010825 AND ps_bfsj >= 2013-01 AND ps_bfsj< 2013-05-31 ;

复制代码 代码如下:

-- 修改
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 ;

复制代码 代码如下:

--删除
DELETE FROM jx_lsjl jx INNER JOIN isa_gtxx gt ON jx.ckid=gt.gtbh WHERE gt.jgm=27010825 AND jx.jgm=27010825 ;