[snip] >That will only result in deletion,I want it to be displayed >and simultaneously deleted.more precisely the effect of following >two commands in one > >SELECT from data where name='harsh'; >DELETE from data where name='harsh'; [/snip]
Write a .sql script with both queries and call it from the command line? mysql>\. /usr/database/stuff/show_and_delete.sql HTH! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]