select id,CountryCode, 

      district,    

      (select count(*) from city c2 where c2.countrycode = c1.countrycode and c2.id <= c1.id) as seq    

from city c1;

'mysql' 카테고리의 다른 글

blocked because of many connection errors  (0) 2018.06.12
mac mysql 삭제  (0) 2018.01.21

+ Recent posts