Friday, August 21, 2009
Shellscript MySQL
Shellscript MySQL
Executing a mysql query from shellscript
There is an option mysql provides to execute the query from bash/sh shell without actually logging into the mysql control prompt
This will help us processing the data from within the shell script.
Thanks to "-e" option in mysql
Featured Blog Topics:
Executing a mysql query from shellscript
There is an option mysql provides to execute the query from bash/sh shell without actually logging into the mysql control prompt
shell# ./mysql -u root -padmin@sak -e "show databases"
This will help us processing the data from within the shell script.
Thanks to "-e" option in mysql
Featured Blog Topics:
- Xml in MySQL - http://kathyravan.blogspot.com/2008/03/xml-in-mysql.html
- Forgot mySQL root Password? - http://kathyravan.blogspot.com/2008/02/forgot-mysql-root-password.html
- Samba - Installation & Configuration - http://kathyravan.blogspot.com/2008/02/samba-installation-configuration.html
- Enabling HTTP Authentication in Apache - http://kathyravan.blogspot.com/2008/08/enabling-http-authentication-in-apache.html
- PHP Function: isFTPFileExists (Searching a FILE in FTP) - http://kathyravan.blogspot.com/2008/12/php-function-isftpfileexists-searching.html
- Shell Scripting & Linux - http://kathyravan.blogspot.com/search/label/Shell%20Scripts
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment