create 'day' tables based on timestamp in mysql

Linux and Unix-Like UNIX and Linux Applications
1

How would one go about creating 'day' tables based on the timestamp field.

I have some 'import' tables which contains data from various days and would like to spilt that data up into 'days' based on the timestamp field in new tables.

TABLE_IMPORT1
TABLE_IMPORT2
TABLE_IMPORT3

TABLE_DAY1
TABLE_DAY2
TABLE_DAY3

thanks & regards

2

By day - do you mean day of the month 1..31 or day of the week?
Is this Oracle?

A general answer would be 'create a view against those tables'. Creating tables based on the date field when all of the other data is the same is not a good idea for database design. Ideally you put all common data into a single table or view and query against it.

3

Hello,

By day of the month, so I can run searches on each individual 'day' table instead of the whole database. This is mysql. Creating a view sounds like a good idea and I will give that a go...

Thanks & regards