Home about IT Motivation Course Sales Project About Me

Saturday, August 21, 2010

sql query from command line

below example for auto update query at mysql from command line;

please write below script and save as coba.bat
then set as autorun use scheduler task from windows

mysql -u root -p4321 -D fos -e "update jns_cuti set lama_jcuti = 1 where date_jcuti = CURDATE()"

No comments: