mysql典型sql示例(DML)

2019独角兽企业重金招聘Python工程师标准>>>

1、mysql多表连接更新

UPDATE 
-- (select * from
rel_route_assit_station
-- where cityCode = '130400'
-- ) 
t
,rel_route_assit_station_tool k
SET t.routeName = k.routeName,t.lineAlias = k.lineAlias WHERE t.routeId = k.routeId AND t.direction = k.direction AND t.cityCode = '130400'

UPDATE `rel_route_station` x, 
(
SELECT t.id,k.stationId FROM `rel_route_station_tool` t JOIN 
(SELECT * FROM `rel_route_station` WHERE cityCode = '130400')  k

ON t.GprsId = k.routeId AND t.OrderNo = k.stationNo AND t.Direction = k.direction
) 
y
SET x.stationId = y.id 
WHERE x.stationId = y.stationId

2、mysql根据汉字字典序排序

select citycode, cityname, busCompanyTitle, imgurl from base_service_ip 
order by convert(cityName using gbk) ASC

3、mysql update limit mysql更新限制语句用法

转载于:https://my.oschina.net/Howard2016/blog/1522672