Question: I need an example of a bash shell
script to select rows from a MySQL table.
I would also like a script example that shows how to use a shell
script to insert data into a MySQL table from UNIX/Linux.
Answer: It is simple to use any shell
script to access a database, and using a shell script to select
MySQL table rows is as simple as executing the /usr/bin/mysql
executable and passing he SQL query as aeguments to MySQL.
Below is a sample bash shell script accesses a MySQL
database.
#! bin/bash
#**************************
# Define the MySQL query
#**************************
qry="select * from mytable"
#********************************************
# Now we connect to
the MySQL database
# and execute the query from the shell script
#********************************************
/usr/bin/mysql
-u dbuser << eof
$qry
eof
#end of script to select rows
You can insert rows into a MySQL table from
a shell sceipr using the same format, replacing the select statement
in $qry with an insertion statement.
#! bin/bash
insvar="insert into mytab
values ('a','b','c')"
#********************************************
# Now we connect to
the MySQL database
# and execute the query from the shell script
#********************************************
/usr/bin/mysql
-u dbuser << eof
$insvar
eof
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|