m*o
2 楼
有一个file, 里面有好几个select query，这几个select query之间用 echo 隔开，文
件是这样的：
\! echo "Number of emails ";
\! echo "-------------------------------------------------------------------
件是这样的：
\! echo "Number of emails ";
\! echo "-------------------------------------------------------------------
h*c
3 楼
tex文件里有若干个png file, latex sometex.tex之后，
在dvi里面可以看见，
dvips sometex.dvi -o sometex.ps之后
在sometex.ps里却看不见了，
如之奈何？
在dvi里面可以看见，
dvips sometex.dvi -o sometex.ps之后
在sometex.ps里却看不见了，
如之奈何？
s*y
4 楼
v*r
5 楼
I don't think you can invoke OS command inside mysql prompt. You can try:
1. Use tee to spool
mysql> tee all_tables.txt
Logging to file 'all_tables.txt'
mysql> show tables;
+--------------------------------+
| Tables_in_mypdc |
+--------------------------------+
| activemeasurement |
| calculatedmeasurement |
| calculatedmeasurementdetail |
| company |
| configurationentity |
| customactionadapter |
| customactionadapterdetail |
| custominputadapter |
| custominputadapterdetail |
| customoutputadapter |
| customoutputadapterdetail |
.......................
.......................
mysql> notee
2. Write a shell script to include multiple mysql command (one for each
query), something like this:
#!/bin/bash
...
# report header 1
echo "Number of emails "
mysql -t db < emails.sql >> output_report.txt
....
# report header 2
echo "Number of files "
mysql -t db < files.sql >> output_report.txt
....
【在 m******o 的大作中提到】
: 有一个file, 里面有好几个select query，这几个select query之间用 echo 隔开，文
: 件是这样的：
: \! echo "Number of emails ";
: \! echo "-------------------------------------------------------------------
1. Use tee to spool
mysql> tee all_tables.txt
Logging to file 'all_tables.txt'
mysql> show tables;
+--------------------------------+
| Tables_in_mypdc |
+--------------------------------+
| activemeasurement |
| calculatedmeasurement |
| calculatedmeasurementdetail |
| company |
| configurationentity |
| customactionadapter |
| customactionadapterdetail |
| custominputadapter |
| custominputadapterdetail |
| customoutputadapter |
| customoutputadapterdetail |
.......................
.......................
mysql> notee
2. Write a shell script to include multiple mysql command (one for each
query), something like this:
#!/bin/bash
...
# report header 1
echo "Number of emails "
mysql -t db < emails.sql >> output_report.txt
....
# report header 2
echo "Number of files "
mysql -t db < files.sql >> output_report.txt
....
【在 m******o 的大作中提到】
: 有一个file, 里面有好几个select query，这几个select query之间用 echo 隔开，文
: 件是这样的：
: \! echo "Number of emails ";
: \! echo "-------------------------------------------------------------------
a*e
6 楼
标准的dvips不支持png
用dvipdfmx或pdflatex试试
【在 h**********c 的大作中提到】
: tex文件里有若干个png file, latex sometex.tex之后，
: 在dvi里面可以看见，
: dvips sometex.dvi -o sometex.ps之后
: 在sometex.ps里却看不见了，
: 如之奈何？
用dvipdfmx或pdflatex试试
【在 h**********c 的大作中提到】
: tex文件里有若干个png file, latex sometex.tex之后，
: 在dvi里面可以看见，
: dvips sometex.dvi -o sometex.ps之后
: 在sometex.ps里却看不见了，
: 如之奈何？
m*o
7 楼
Thanks for reply.
In the second method you mentioned, is there any way I can combine the
output with echo? - instead of the output file with the query result, I
also want the header you mentioned.
Thanks a lot!
try:
【在 v*****r 的大作中提到】
: I don't think you can invoke OS command inside mysql prompt. You can try:
: 1. Use tee to spool
: mysql> tee all_tables.txt
: Logging to file 'all_tables.txt'
: mysql> show tables;
: +--------------------------------+
: | Tables_in_mypdc |
: +--------------------------------+
: | activemeasurement |
: | calculatedmeasurement |
In the second method you mentioned, is there any way I can combine the
output with echo? - instead of the output file with the query result, I
also want the header you mentioned.
Thanks a lot!
try:
【在 v*****r 的大作中提到】
: I don't think you can invoke OS command inside mysql prompt. You can try:
: 1. Use tee to spool
: mysql> tee all_tables.txt
: Logging to file 'all_tables.txt'
: mysql> show tables;
: +--------------------------------+
: | Tables_in_mypdc |
: +--------------------------------+
: | activemeasurement |
: | calculatedmeasurement |
h*c
8 楼
试验了若干办法，还是转EPS吧，这条比较DETERMINISITIC
【在 a**e 的大作中提到】
: 标准的dvips不支持png
: 用dvipdfmx或pdflatex试试
【在 a**e 的大作中提到】
: 标准的dvips不支持png
: 用dvipdfmx或pdflatex试试
v*r
9 楼
Same as re-directing and appending the output of mysql result:
echo "Heading ..." >> output_report.txt
【在 m******o 的大作中提到】
: Thanks for reply.
: In the second method you mentioned, is there any way I can combine the
: output with echo? - instead of the output file with the query result, I
: also want the header you mentioned.
: Thanks a lot!
:
: try:
echo "Heading ..." >> output_report.txt
【在 m******o 的大作中提到】
: Thanks for reply.
: In the second method you mentioned, is there any way I can combine the
: output with echo? - instead of the output file with the query result, I
: also want the header you mentioned.
: Thanks a lot!
:
: try:
b*n
10 楼
use pdflatex to include png & jpeg files.
m*o
11 楼
great! Thanks!
【在 v*****r 的大作中提到】
: Same as re-directing and appending the output of mysql result:
: echo "Heading ..." >> output_report.txt
【在 v*****r 的大作中提到】
: Same as re-directing and appending the output of mysql result:
: echo "Heading ..." >> output_report.txt
相关阅读
关于reference 作者格式一问Urgent! :How to make strikethrough?用listing引入C代码，怎么让关键字BOLD？.bib文件位置问题ps 怎么转pdf请教图片排版问题问个画图的问题 (转载)关于digram宏包一问用$$输入公式怎么让公式自动自己换行？借此地问一下，怎么从图形里面得到数据anyone has experience with floatflt?怎样用latex编排C语言源代码？紧急求救: 图的编码问题怎样从 tex 得到 doc 或者 rtf 文件winedt为什么把y坐标的标题改了？vim: how to spell check?no bounding box怎么办？About referring articleshow to make a pdf printable only?I am beginner for this !