Re: [MySQL] What terminates a query?

[Ashley M. Kirchner]

Matt Young wrote:

>My sql command pipes its result to a perl program (in batch mode) . but the
>perl program has no waf to tell when the query is finished.
>HTTP uses a blank line to signal the end. but there is no such thing for
>mysql.


Why can't you append an extra line to your sql result (say ##END##) and have the perl program check for that string. Once found, it knows the sql command has finished.

--
W | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.






---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php