Re: Simple question on arrays and sql
- From: Captain Paralytic <paul_lautman@xxxxxxxxx>
- Date: Mon, 31 Mar 2008 08:26:12 -0700 (PDT)
On 31 Mar, 16:22, sheldonlg <sheldonlg> wrote:
Given that I have a 2D array in php, is there a sql syntax to insert the
entire array at once?
For example if I retrieve a set of data from one table in the database
with keys A, B and C, and suppose there are 100 records, and I build an
array $arr consisting of
$arr[$i]['A'], $arr[$i]['B'], and $arr[$i]['C']
where $i goes from 0 to 99,
is there a syntax to insert the entire $arr array at one time into
fields A, B, and C of a new table?
I really would like to avoid having 100 sql insert calls.
BTW, this is for an Oracle DB.
In the past I have only had to insert a few records at a time, so i
simply did multiple inserts. Of course for Oracle I could do the same
and only do a commit after all are done.
Why not use an INSERT ... SELECT syntax and do it all in SQL?
.
- Follow-Ups:
- Re: Simple question on arrays and sql
- From: sheldonlg
- Re: Simple question on arrays and sql
- References:
- Simple question on arrays and sql
- From: sheldonlg
- Simple question on arrays and sql
- Prev by Date: Simple question on arrays and sql
- Next by Date: Re: Simple question on arrays and sql
- Previous by thread: Simple question on arrays and sql
- Next by thread: Re: Simple question on arrays and sql
- Index(es):
Relevant Pages
|
