Hi,
> Table 1 is called: active_users
> Table 2 is called: deleted_users
>
> When "joe_smith" wishes to be deleted, I want to remove his entry
> from the active_users table, and place it into the delete_users
> table, with exactly the same information.
INSERT INTO deleted_users SELECT * FROM active_users WHERE user='joe_smith';
DELETE FROM active_users WHERE user='joe_smith';
Rgds,
Tfr
--==< [EMAIL PROTECTED] >==< MySQL development team >==< Tallinn / Estonia >==--
---------------------------------------------------------------------
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
