請問一個BASH的問題?(sql查詢後存檔 - Linux

By Bennie
at 2012-07-14T23:47
at 2012-07-14T23:47
Table of Contents
請問BASH要怎麼樣下完sql後,再將結果存入檔案
有找到的範例如下,但是只能查詢,不會存檔。
#!/bin/sh
user="dbuser"
pass="dbpassword"
db="dbnme"
mysql -u "$user" -p"$pass" "$db" <<EOF
sql-statement-1;
sql-statement-2;
EOF
請問有人知道要如何解這一問題嗎?
--
有找到的範例如下,但是只能查詢,不會存檔。
#!/bin/sh
user="dbuser"
pass="dbpassword"
db="dbnme"
mysql -u "$user" -p"$pass" "$db" <<EOF
sql-statement-1;
sql-statement-2;
EOF
請問有人知道要如何解這一問題嗎?
--
Tags:
Linux
All Comments

By Charlie
at 2012-07-15T22:28
at 2012-07-15T22:28

By Brianna
at 2012-07-17T17:54
at 2012-07-17T17:54

By Caitlin
at 2012-07-22T15:46
at 2012-07-22T15:46
Related Posts
awk 用法

By Edward Lewis
at 2012-07-14T13:36
at 2012-07-14T13:36
awk 用法

By Lucy
at 2012-07-14T13:02
at 2012-07-14T13:02
awk 用法

By Bennie
at 2012-07-14T12:13
at 2012-07-14T12:13
awk 用法

By Queena
at 2012-07-14T00:36
at 2012-07-14T00:36
想透過AD做帳號認證 需要加入網域嗎?

By Hedda
at 2012-07-13T22:17
at 2012-07-13T22:17