Created
August 19, 2018 09:18
-
-
Save khunemz/308f1f2a20fccc01e9d518f985841234 to your computer and use it in GitHub Desktop.
Thailand Province Eng List MySQL insert
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Bangkok" , now() , now() , -1 , -1 , 1); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Amnat Charoen" , now() , now() , -1 , -1 , 2); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Ang Thong" , now() , now() , -1 , -1 , 3); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Bueng Kan" , now() , now() , -1 , -1 , 4); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Buriram" , now() , now() , -1 , -1 , 5); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chachoengsao" , now() , now() , -1 , -1 , 6); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chainat" , now() , now() , -1 , -1 , 7); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chaiyaphum" , now() , now() , -1 , -1 , 8); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chanthaburi" , now() , now() , -1 , -1 , 9); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chiang Mai" , now() , now() , -1 , -1 , 10); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chiang Rai" , now() , now() , -1 , -1 , 11); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chonburi" , now() , now() , -1 , -1 , 12); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Chumphon" , now() , now() , -1 , -1 , 13); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Kalasin" , now() , now() , -1 , -1 , 14); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Kamphaeng Phet" , now() , now() , -1 , -1 , 15); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Kanchanaburi" , now() , now() , -1 , -1 , 16); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Khon Kaen" , now() , now() , -1 , -1 , 17); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Krabi" , now() , now() , -1 , -1 , 18); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Lampang" , now() , now() , -1 , -1 , 19); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Lamphun" , now() , now() , -1 , -1 , 20); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Loei" , now() , now() , -1 , -1 , 21); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Lopburi" , now() , now() , -1 , -1 , 22); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Mae Hong Son" , now() , now() , -1 , -1 , 23); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Maha Sarakham" , now() , now() , -1 , -1 , 24); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Mukdahan" , now() , now() , -1 , -1 , 25); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nakhon Nayok" , now() , now() , -1 , -1 , 26); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nakhon Pathom" , now() , now() , -1 , -1 , 27); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nakhon Phanom" , now() , now() , -1 , -1 , 28); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nakhon Ratchasima" , now() , now() , -1 , -1 , 29); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nakhon Sawan" , now() , now() , -1 , -1 , 30); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nakhon Si Thammarat" , now() , now() , -1 , -1 , 31); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nan" , now() , now() , -1 , -1 , 32); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Narathiwat" , now() , now() , -1 , -1 , 33); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nong Bua Lamphu" , now() , now() , -1 , -1 , 34); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nong Khai City" , now() , now() , -1 , -1 , 35); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Nonthaburi" , now() , now() , -1 , -1 , 36); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Pathum Thani" , now() , now() , -1 , -1 , 37); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Pattani" , now() , now() , -1 , -1 , 38); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phang Nga" , now() , now() , -1 , -1 , 39); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phatthalung" , now() , now() , -1 , -1 , 40); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phayao" , now() , now() , -1 , -1 , 41); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phetchabun" , now() , now() , -1 , -1 , 42); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phetchaburi" , now() , now() , -1 , -1 , 43); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phichit" , now() , now() , -1 , -1 , 44); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phitsanulok" , now() , now() , -1 , -1 , 45); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phra Nakhon Si Ayutthaya" , now() , now() , -1 , -1 , 46); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phrae" , now() , now() , -1 , -1 , 47); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Phuket" , now() , now() , -1 , -1 , 48); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Prachinburi" , now() , now() , -1 , -1 , 49); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Prachuap Khiri Khan" , now() , now() , -1 , -1 , 50); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Ranong" , now() , now() , -1 , -1 , 51); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Ratchaburi" , now() , now() , -1 , -1 , 52); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Rayong" , now() , now() , -1 , -1 , 53); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Roi Et" , now() , now() , -1 , -1 , 54); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Sa Kaeo" , now() , now() , -1 , -1 , 55); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Sakon Nakhon" , now() , now() , -1 , -1 , 56); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Samut Prakan" , now() , now() , -1 , -1 , 57); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Samut Sakhon" , now() , now() , -1 , -1 , 58); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Samut Songkhram" , now() , now() , -1 , -1 , 59); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Saraburi" , now() , now() , -1 , -1 , 60); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Satun" , now() , now() , -1 , -1 , 61); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Sing Buri" , now() , now() , -1 , -1 , 62); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Sisaket" , now() , now() , -1 , -1 , 63); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Songkhla" , now() , now() , -1 , -1 , 64); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Sukhothai" , now() , now() , -1 , -1 , 65); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Suphan Buri" , now() , now() , -1 , -1 , 66); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Surat Thani" , now() , now() , -1 , -1 , 67); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Surin" , now() , now() , -1 , -1 , 68); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Tak" , now() , now() , -1 , -1 , 69); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Trang" , now() , now() , -1 , -1 , 70); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Trat" , now() , now() , -1 , -1 , 71); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Ubon Ratchathani" , now() , now() , -1 , -1 , 72); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Udon Thani" , now() , now() , -1 , -1 , 73); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Uthai Thani" , now() , now() , -1 , -1 , 74); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Uttaradit" , now() , now() , -1 , -1 , 75); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Yala" , now() , now() , -1 , -1 , 76); | |
insert into tb_sys_catitem (CatId , CatItemDesc , CreatedDate , UpdatedDate , CreatedByUserId , UpdatedByUserId , OrderRank) values (2 , "Yasothon" , now() , now() , -1 , -1 , 77); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment