On Tue, Feb 25, 2003 at 01:30:52AM -0500, g gnanaraj wrote: > 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
mysql -e "UPDATE foo SET bar=1 WHERE baz=2;" test For more information check the output of mysql -? Cheers! -- Zak Greant <[EMAIL PROTECTED]> MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Debian: Yep, that's GNU/Linux (http://debian.org) --------------------------------------------------------------------- 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
