Possiable Trigger Use
Hi All, I was wondering if This is possiable. I have a date column and want to have a trigger perform the following: Look at all of the dates and then if the data is 3 days old. Delete the corresponding tables related to that date, and then fianlly the row that told me what tables are related to that date. Thanks, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Possiable Trigger Use
On Monday 14 August 2006 12:35 pm, [EMAIL PROTECTED] wrote: Look at all of the dates and then if the data is 3 days old. Delete the corresponding tables related to that date, and then fianlly the row that told me what tables are related to that date. I'm kind of curious about the deleting of tables. Are you sure you didn't mean rows? Removing tables like will accept a table name and that's about it, you can't run conditions for it (as far as I know..). -- Chris White PHP Programmer/DBloomers Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]