By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,158 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,158 IT Pros & Developers. It's quick & easy.

Time Frame

P: 5
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.
Dec 4 '11 #1
Share this Question
Share on Google+
1 Reply


100+
P: 122
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.
Dec 7 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.