SQL Query To Insert Tamilnadu Distrcits

Here is the insert SQL query to insert list of Tamilnadu districts.

INSERT INTO `districts` (`id`, `district_name`, `state_id`) VALUES
(1, 'Ariyalur',31),
(2, 'Chennai',31),
(3, 'Coimbatore',31),
(4, 'Cuddalore',31),
(5, 'Dharmapuri',31),
(6, 'Dindigul',31),
(7, 'Erode',31),
(8, 'Kanchipuram',31),
(9, 'Kanyakumari',31),
(10, 'Karur',31),
(11, 'Krishnagiri',31),
(12, 'Madurai',31),
(13, 'Nagapattinam',31),
(14, 'Namakkal',31),
(15, 'Nilgiris',31),
(16, 'Perambalur',31),
(17, 'Pudukkottai',31),
(18, 'Ramanathapuram',31),
(19, 'Salem',31),
(20, 'Sivaganga',31),
(21, 'Thanjavur',31),
(22, 'Theni',31),
(23, 'Thoothukudi (Tuticorin)',31),
(24, 'Tiruchirappalli',31),
(25, 'Tirunelveli',31),
(26, 'Tiruppur',31),
(27, 'Tiruvallur',31),
(28, 'Tiruvannamalai',31),
(29, 'Tiruvarur',31),
(30, 'Vellore',31),
(31, 'Viluppuram',31),
(32, 'Virudhunagar',31);

Here is Tamilnadu districts SQL insert query without state id .

INSERT INTO `districts` (`id`, `district_name`) VALUES
(1, 'Ariyalur'),
(2, 'Chennai'),
(3, 'Coimbatore'),
(4, 'Cuddalore'),
(5, 'Dharmapuri'),
(6, 'Dindigul'),
(7, 'Erode'),
(8, 'Kanchipuram'),
(9, 'Kanyakumari'),
(10, 'Karur'),
(11, 'Krishnagiri'),
(12, 'Madurai'),
(13, 'Nagapattinam'),
(14, 'Namakkal'),
(15, 'Nilgiris'),
(16, 'Perambalur'),
(17, 'Pudukkottai'),
(18, 'Ramanathapuram'),
(19, 'Salem'),
(20, 'Sivaganga'),
(21, 'Thanjavur'),
(22, 'Theni'),
(23, 'Thoothukudi (Tuticorin)'),
(24, 'Tiruchirappalli'),
(25, 'Tirunelveli'),
(26, 'Tiruppur'),
(27, 'Tiruvallur'),
(28, 'Tiruvannamalai'),
(29, 'Tiruvarur'),
(30, 'Vellore'),
(31, 'Viluppuram'),
(32, 'Virudhunagar');