MySQL Forums
Forum List  »  Knowledge Base

Re: How to execute a insert and delete query from Shell script
Posted by: Amernath Vellaiyan
Date: October 12, 2007 05:58AM

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`

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to execute a insert and delete query from Shell script
25130
October 12, 2007 05:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.