CREATETABLEhat_area( idint(11)NOTNULLauto_increment, areaIDvarchar(50)defaultNULL, areavarchar(60)defaultNULL,
fathervarchar(6)defaultNULL,
primarykey(id)
)ENGINE=MyISAMAUTO_INCREMENT=3145DEFAULTCHARSET=utf8;
INSERTINTOhat_areaVALUES(1,'100','河北省','0');
INSERTINTOhat_areaVALUES(2,'220999','石家庄市','100');