Skip to content

Instantly share code, notes, and snippets.

@khunemz
Created August 19, 2018 09:18
Show Gist options
  • Save khunemz/308f1f2a20fccc01e9d518f985841234 to your computer and use it in GitHub Desktop.
Save khunemz/308f1f2a20fccc01e9d518f985841234 to your computer and use it in GitHub Desktop.
Thailand Province Eng List MySQL insert
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