sql
josnow
我有个小小的梦想:铁人三项
深刻比勤劳更重要
展开
-
模糊查询
SET @ssxx = 1; SET @lyid = null; SET @fj = '%2%'; SET @jfzt =NULL; SET @qyid = NULL; SET @cbny =NULL; SELECT sdfcb.id as id, sdfcb.cbny as cbny, fj.mc as ss, qy.mc as qy, ly.mc as ly原创 2017-05-17 13:02:56 · 253 阅读 · 0 评论 -
多表联查,两表之间相互关联,不一定需要有主外键关系,字段匹配就行
Set @dlr = 15001; SELECT school.name AS schoolName, xq.xqmc AS xqmc, qy.mc as qymc, ly.bz as lymc, fj.bz as fjmc FROM t_xsgy_ssap ssap LEFT JOIN t_xsgy_cwgl cwgl ON cwgl.id=ssap.cw原创 2017-05-18 17:53:30 · 20422 阅读 · 2 评论