SQL语句总结

本文主要总结本人工作中遇到过的SQL语句，学习，备忘

1.  select  *  from  tablename  a  where (select  count(*)  from  tablename  b  where  a.id<b.id) = 1  

注解：查询按id排序后的倒数第2条，（若=2，则是取倒数第3条，以此类推。。。）

2.UPDATE `location_data` l,(SELECT ga.`name` p,gb.`name` s FROM geo_data ga left outer join geo_data gb on ga.`id`=gb.`parent_id`) ok SET l.`UserBelongsProvince`=ok.p WHERE l.`UserBelongsCity`=ok.s;


UPDATE `location_data` l,(SELECT ga.`name` p,gb.`name` s FROM geo_data ga left outer join geo_data gb on ga.`id`=gb.`parent_id`) ok SET l.`UserBelongsArea`=ok.p WHERE l.`UserBelongsProvince`=ok.s;


SELECT ga.`name` p,gb.`name` s FROM geo_data ga left outer join geo_data gb on ga.`id`=gb.`parent_id`