MySql copy from one table to another

[cip6791]

Hi all,

 

I have a question. I currently use a classifieds script that deletes the ad after a certain amount of time. So I lose the e-mail which was used to post the ad. I would like to copy the existing email from the ads table to another table and keep them there for future use. Does anybody have any idea how this can be done? I would like it to be automatically copied into the new table.

 

Thanks

[AjBaz100]

when the script that runs deletes the ad, you could add another query to first insert the records into another table.

 

I can't remember the exact syntax of the top of my head, but if you look into using the INSERT INTO query.

[cooldude832]

try something like

Insert into `emails` (AdName, Email) Values(Select Name, Email from `ads` where Id = IDHERE))

and then delete

[fenway]

try something like

Insert into `emails` (AdName, Email) Values(Select Name, Email from `ads` where Id = IDHERE))

and then delete

No, not at all... that won't work.

 

I have a question. I currently use a classifieds script that deletes the ad after a certain amount of time. So I lose the e-mail which was used to post the ad.

Why not use a datetime field to mark the record as expired, instead of deleting it?

[Mchl]

Why not insert email when inserting the ad, not when deleting it? You'll need it anyways.