Hi,
There is a CPAN module that formats queries just like the mysql monitor does.
I want this so that I can send some query results in emails without having
to format them myself.
But horror of horrors I can't find the module that I know is there which I
noticed while browsing a short while ago.
Can anyone point me to it?
Just in case this is ambiguous, I am looking for the module that will
product this kind of output to text given a query.
mysql> select ord_num,ord_date from orders limit 10;
+--------------------+---------------------+
| ord_num | ord_date |
+--------------------+---------------------+
| 103247012113695002 | 0000-00-00 00:00:00 |
| 103247046534543002 | 0000-00-00 00:00:00 |
| 103288159755501002 | 0000-00-00 00:00:00 |
| 103488006360019001 | 0000-00-00 00:00:00 |
| 10341254991616002 | 1900-01-01 00:00:00 |
| 103412474981993002 | 1900-01-01 00:00:00 |
| 103412478307044002 | 1900-01-01 00:00:00 |
| 103412403504111002 | 2001-07-08 17:29:58 |
| 103412403507079002 | 2001-07-08 19:42:39 |
| 103412403398044002 | 2001-07-10 21:09:40 |
+--------------------+---------------------+
Thanks,
Eric
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
- Understanding MySQL column type SET Lopez David E-r9374c
- RE: Understanding MySQL column type SET Eric
- RE: Understanding MySQL column type SET Artem Koltsov
- re: RE: Understanding MySQL column type SET Victoria Reznichenko
- RE: Understanding MySQL column type SET Luc Foisy