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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 有一个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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 有一个file, 里面有好几个select query,这几个select query之间用 echo 隔开,文
: 件是这样的:
: \! echo "Number of emails ";
: \! echo "-------------------------------------------------------------------
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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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 |
v*r
9 楼
Same as re-directing and appending the output of mysql result:
echo "Heading ..." >> output_report.txt
【在 m******o 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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.
相关阅读
如何修改一个document的left/right margin包子题: 见内容请问怎样在latex中引用一段话表格 caption 文字怎么设置左对齐投稿的论文,如何在页面左侧加上行码(line number)求助:插入图片后,图片页图片之后的正文字体总有问题这个错误改怎么解决?怎样把公式编号放在公式前面(页面左侧)?免费的latex 用户界面latex slides 标题下划线latex 排版问题求助:用Texlive,Xelatex编译,不能插入eps文件LED dvi 图象预览问题beamer的一个问题请教Book里figure编号的问题如何做equation or align里面写空格\section{Example},如何把example 放在中间?求助latex高手,小问题,如何加通讯作者 (转载)有没有感觉好的beamer模板共享一下,谢谢questions about reference