MySQL+foreach loop.........roy

2004-11-03 Thread Roime bin Puniran
0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Regards Roy

RE: MySQL+foreach loop.........roy

2004-10-26 Thread Chris Devers
On Tue, 26 Oct 2004, Bob Showalter wrote: > Chris Devers wrote: > > On Tue, 26 Oct 2004, Murphy, Ged (Bolton) wrote: > > > > > Going back a few years here, but does an SQL statement not have to > > > end in a semi-colon as above? > > > > I think it depends on your SQL interpreter. > > > > The

RE: MySQL+foreach loop.........roy

2004-10-26 Thread Bob Showalter
Chris Devers wrote: > On Tue, 26 Oct 2004, Murphy, Ged (Bolton) wrote: > > > Going back a few years here, but does an SQL statement not have to > > end in a semi-colon as above? > > I think it depends on your SQL interpreter. > > The MySQL command line interface `mysql` expect semi-colons, as d

RE: MySQL+foreach loop.........roy

2004-10-26 Thread Chris Devers
On Tue, 26 Oct 2004, Murphy, Ged (Bolton) wrote: > Going back a few years here, but does an SQL statement not have to end > in a semi-colon as above? I think it depends on your SQL interpreter. The MySQL command line interface `mysql` expect semi-colons, as does the `psql` tool for PostgreSQ

RE: MySQL+foreach loop.........roy

2004-10-26 Thread Murphy, Ged (Bolton)
Roime bin Puniran, wrote: >#Prepare the insert SQL >my $rec = $dbh->prepare("INSERT INTO t_flows(ipSrc, ipDst, pktSent, bytesSent, startTime, endTime, srcPort, >dstPort, tcpFlags, proto, tos) VALUES ('$value1', '$value2', '$value3', '$value4', '$value5', '$value6', >'$value7', '$value8', '$va

RE: MySQL+foreach loop.........roy

2004-10-26 Thread Charles K. Clarkson
Roime bin Puniran <[EMAIL PROTECTED]> wrote: : I have a script that read some text file in the directory. All : the data inside the text file then would be extracted into my : sql, and i used foreach loop to read the text file, then doing : some loop while data are sorted. Here is my code. Yo

MySQL+foreach loop.........roy

2004-10-25 Thread Roime bin Puniran
Hi all.. I have a script that read some text file in the directory...All the data inside the text file then would be extracted into my sql, and i used foreach loop to read the text file, the doing some loop while data are sorted..Here is my code. #!/usr/bin/per