MySQL Forums
Forum List  »  MySQL Administrator

Create daily tables
Posted by: trid gell
Date: April 09, 2010 04:58PM

I want to create a table called audit_log. However, data into the table is so huge that I want to create tables with that name everyday. So that every day data will go to table for that day. However, I dont want to bring this logic into my PHP applicaiton. I want MySQL to handle that logic. Is there a way to do this in MySQL ...create a table called audit_log and mysql will take care of storing data in appropriate table every day.

Options: ReplyQuote

Written By
Create daily tables
April 09, 2010 04:58PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.