Time Frame

[ashabanu]

hi all,
i have two questions,
1) I have a huge data set, I need to separate them into three different time frame (equally). What is the fastest way to do so.

2) After performing a select statement ( a query from the original database) how can i save the output into a different database with a different name so that i could use the selected result other purpose.

thank u.

[adriancs]

select * from tablename where dateTime = '2011-12-07 00:00:00';
select * from tablename where dateTime > '2011-12-07 00:00:00';
select * from tablename where dateTime < '2011-12-07 00:00:00';
select * from tablename where dateTime > '2011-01-01 00:00:00' and dateTime < '2011-12-01 00:00:00';

answer for question 2:
just create another MySqlConnection which point to another database.