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') kON 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

总结

以上是生活随笔为你收集整理的mysql典型sql示例(DML)的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。