Do you know that you can run mysql in batch mode? So you can achieve what you want by this. Read the below:
http://www.mysql.com/doc/en/Batch_mode.html Regards, Joseph >-----Original Message----- >From: g gnanaraj [mailto:[EMAIL PROTECTED] >Sent: Tuesday, February 25, 2003 7:31 AM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Start MySQL along with a update statement. > > >I need to start MySQL using a script which does the following: > >1. login to MySQL >2. use a specific database >3. run a update statement >4. exit > > >I have been able to achieve 1 & 2 by doing the following but >not the others. > >mysql -D test > >Can anyone help me please ? > >Thanks. > > > > >_____________________________________________________________ >Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for >$19.95/year. >http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmt plus --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php