Hi
> Would you happen to have a nice little example-script for me/us? :-)
yup, here's a little example:
$condition = "WHERE username LIKE 'm%'"
if (mysql_query("INSERT AuthCopy SELECT * FROM Auth $condition"))
mysql_query("DELETE FROM Auth $condition");
This assumes the two tables are identical with regard to column
order/type but not name, and that you want to copy and remove the data
from the first table.
The whole operation is performed by the MySQL server, so requires almost
zero processing by PHP and should be faster. However, it also means you
don't get to verify each insert as it is made, but that should not be a
major problem.
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
