注册
登录
| 关键词： nbsp sql pass statement shell shuser MySQL scripts manager user |
How do I call Oracle or MySQL sql statements in UNIX / Linux shell scripts? MySQL: Use SQL Directly In Shell Scripts#!/bin/shuser="dbuser"pass="dbpassword"db="dbnme"mysql -u "$user" -p"$pass" "$db" <<EOF sql-statement-1; sql-statement-2;EOFUsing Shell Variables In SQL#!/bin/shuser="dbuser"pass="dbpassword"db="dbnme"sql="select * from tal_name"mysql -u "$user" -p"$pass" <<EOF use $db; $sql;EOFOracle: Use SQL Directly In Shell Scripts#!/bin/shuser="system"pass="manager"sqlplus -S $user/$pass <<EOF sql-statement-1; sql-statement-2; exit;EOFUsing Shell Variables In SQL#!/bin/shuser="system"pass="manager"var="$1"sqlplus -S $user/$pass <<EOF SELECT * FROM tableName WHERE username=$var; exit;EOFYou can call sql statements from .sql file itself as follows:#!/bin/kshsqlplus -S system/manager @my_sql_script.sql |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
