|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to get the original create timestamp? | aster007 | UNIX for Advanced & Expert Users | 3 | 08-20-2008 11:08 AM |
| Copy lines from a log file based on timestamp | ranjiadmin | UNIX for Advanced & Expert Users | 1 | 05-22-2008 04:16 AM |
| Purge files based on timestamp avl in file name | sureshg_sampat | Shell Programming and Scripting | 3 | 02-29-2008 11:28 AM |
| Timestamp in MySQL | nervous | UNIX for Dummies Questions & Answers | 1 | 11-12-2007 03:00 AM |
| Create file with old timestamp | Kris_Kart_101 | UNIX for Dummies Questions & Answers | 2 | 10-14-2005 02:18 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
03-09-2009
|
||||
|
||||
|
create 'day' tables based on timestamp in mysql
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 |
|
03-10-2009
|
||||
|
||||
|
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. |
|
03-10-2009
|
||||
|
||||
|
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 |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
