Re: How to execute a insert and delete query from Shell script

[Amernath Vellaiyan]

U can use this script to insert and delete records into the table

RESULT=`/usr/bin/mysql -u username -p password<<SQL
use DatabaseName
insert into tablename (column1,..) values ( value1,...);
delete from tablename where conditions;
quit
SQL`