Sql insert into

Expand Post »

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.

Similar Threads

How to insert data into database? in JSP
php / sql insert script error in PHP
SQL Query inserts junk data as well in ASP
$rs=mysql_query($sql) or die("error in common.inc.php at line 257"); in PHP
Rows not added correctly when using 'INSERT' in PHP

arvin2006

Reputation Points: 15

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since Sep 2006

Permalink

Feb 20th, 2009

Re: Sql insert into

Hi,

I dont think so such query exist but u can use like this

SQL Syntax (Toggle Plain Text)
   INSERT INTO VALUES ( .... ) , ( .... ) , ....
   INSERT INTO VALUES ( .... ) , ( .... ) , ....

Make such SQL and Execute the single query.

selvaganapathy

Reputation Points: 44

Solved Threads: 101

Posting Pro

Offline

547 posts
since Feb 2008

Permalink

Feb 21st, 2009

Re: Sql insert into

you can use loop inside a sub program for the purpose.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: What is the purpose of each visual basic project file type?

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Deleting listview checked data using delete button

DaniWeb Message

Cancel Changes

User Name
Password