insert query with 10 records at at a time

SreeRam Kondagorla

9y936

i have two columns with name city, country .i want to insert two columns with one query.country name should be same but city names different.how can i insert with one query please help me ..thank oyu

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
Its not big deal in sql,
you can use like this,,
insert into tbl (name,city,country) values ('Bikesh','Noida','India'),('Bikesh1','Noida1','india1'),........................()
As per this query you insert n number of item in a single query.
0
Mayank9y ago
INSERT INTO Table (field1, field2) VALUES
('string1','string2'),
('stringA','stringB')
0
Nigel Fernandes9y ago
Use a for loop
create a transaction and
then insert 10 at a time and commit
0
Nitin Sontakke9y ago
It is confusing because it so basic. Really not sure what you are expecting, but giving technically correct answer.

insert into table_name (country, city) values ('India', 'Delhi');

If you wish to insert more records at a time, use:

insert into table_name (country, city) values
('India', 'Delhi'),
('India', 'Mumbai'),
('India', 'Chennai'),
('India', 'Kolkota'),
('India', 'Jaipur'),
('India', 'Ahmedabad'),
('India', 'Bhopal'),
('India', 'Nagpur'),
('India', 'Surat')
The above syntax has limitation of 1000 records.

Hope it helps!
+1

Mayank9y ago

https://www.techonthenet.com/sql_server/insert.php

Abhishek Chadha9y ago
You can use parameters for insert query
fix the country parameters and change the city parametes for insert query

Rest please clerify your question what you want ??
0
Aravindkumar Karunanithi9y ago
Im confusing on your question. Why you are trying to insert instead of update?
-1