Delete one table and move data to another table
| From: | endro mei a. | Date: | Wed, 26 Sep 2007 10:26:04 +0000 |
| Subject: | Delete one table and move data to another table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44057@lists.php.net to get a copy of this message | ||
I have a table1 it contents (3 column) :
id int(11)
name varchar(200)
address varchar(255)
I want to delete table1 and insert data to table2 it contents (5 column) :
id
name
addres
date_delete datetime
who_delete varchar(50)
Code on php and mysql ???
Anyone can help me.
========================================================================================
"Sambil berpuasa, ikuti Netkuis Ramadhan 1428 H. Menangkan Laptop, Ipod dan HP Nokia di akhir periode netkuis dan dapatkan Flash disk di tiap minggunya dengan mengikuti Netkuis di http://netkuis.telkom.net/"
========================================================================================