Hi Vince,
I assume you want to print to your printer from the mysql client (command
line) here is what I do:
0) set up a lp queue (line printer) and make sure it works then proceed to 1)
1a) mysql> pager /usr/bin/less
mysql> \P lp;
PAGER set to lp;
mysql> SHOW INNODB STATUS ;
request id is IPSIO8000-2DPS-129 (1 file(s))
1 row in set (0.01 sec)
or you do it like this
1b) mysql> <command> \T ~/outputfilename
mysql> \t
The first command in 1b) starts the output into th file (parallel to the
screen) the second (\t) will stop the output.
Use the normal print command to print the file.
I hope that helps.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 07:27、Vince さんは書きました:
> I am new to SQL and was wondering if there was a query that would allow
> me to print to my printer. I have tried the TO PRINTER, TO FILE, |lpr,
> and others, but get the syntax error. I am running MySQL on a WIndows XP
> Home system. My company has asked me to transfer a clients file to forms
> for printed output. My queries can get the information needed, with the
> exception of output.
>
> Thanks!
>
> Vince Bravdica
> [EMAIL PROTECTED]
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
