hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an alternative way instead of typing (INSERT INTO.. 10x) statement repeatedly. thanks.
arvin2006
1
Junior Poster in Training
Recommended Answers
Jump to PostHi,
I dont think so such query exist but u can use like this
INSERT INTO VALUES ( .... ) , ( .... ) , ....Make such SQL and Execute the single query.
All 2 Replies
selvaganapathy
31
Posting Pro
Hi,
I dont think so such query exist but u can use like this
INSERT INTO VALUES ( .... ) , ( .... ) , ....Make such SQL and Execute the single query.
debasisdas
580
Posting Genius
Featured Poster
you can use loop inside a sub program for the purpose.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.