I have one table with about 86,000 records and I want to archive the data in that table once a day and keep that archive for 5 days. I setup a php script to insert into table_b select * from table_a; and cron'd wget to execute it once a day. I realized I needed a date field to expire the old stuff. So I added a data stamp field. However this broked my insert. Is the information in the date stamp field not auto generated like the a field set to auto_increment? Anyway, any guideance would be appriciated.
fyi i'm running:
mysql: 3:22:32
php: 4.0.3pl1
fyi i'm running:
mysql: 3:22:32
php: 4.0.3pl1