citys.docVIP

citys drop table cities; create table cities( id int primary key, name varchar(50), parent int references id ); insert into cities values(1,鍖椾含甯?,0); insert into cities values(2,鍖椾含杈栧尯,1); insert into cities values(3,涓滃煄鍖?,2); insert into cities values(4,瑗垮煄鍖?,2); insert into cities values(5,宕囨枃鍖?,2); insert into cities values(6,瀹ｆ鍖?,2); insert into cities values(7,鏈濋槼鍖?,2); insert into cities values(8,涓板彴鍖?,2); insert into cities values(9,鐭虫櫙灞卞尯,2); insert into cities values(10,娴锋穩鍖?,2); insert into cities values(11,闂ㄥご娌熷尯,2); insert into cities values(12,鎴垮北鍖?,2); insert into cities val