SQL Query To Insert Tamilnadu Distrcits

Leave a Comment
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');


0 comments:

Post a comment