14-07-2007, 10:05 AM
|
||||
|
||||
Export hugh data from MySQL
Let's say I have a hugh table in a hugh MySQL database. The table has tens of thousands of records. One of the field is a date field. How do I selectively export the data from the table, for example only the date from 2006-Jun-10 to 2007-Feb-25?
I don't think the tool I usually use, PhpMyAdmin can allow me to do that?     
|
|
14-07-2007, 03:51 PM
|
||||
|
||||
|
may i know what is a "hugh table"? Is it a table name or it actually "huge table"?
|
|
16-07-2007, 04:30 PM
|
||||
|
||||
|
you can manually put a query in phpmyadmin SQL query textbox... for example..
select * from table_x where month>6 and year>2006 and month<2 and year<2007 hope this example helps..
__________________
Malaysia's Best Web Hosting
|
|
16-07-2007, 04:35 PM
|
||||
|
||||
|
my eye largely open..
 wow!.. mozaks. OMG OMG.. hell long time no see :P KongTech.. i think soo.. you nee to do sql query.
|
 |
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| data in sql | jauzakamilia | Website Programming | 8 | 17-09-2007 01:39 PM |
| ASP.NET - DataGrid Export to Excel - Alignment problem | genzy | Website Programming | 2 | 15-04-2007 11:21 AM |
| sorting data | gundam_seat | Website Programming | 2 | 06-08-2005 10:16 AM |
| mcmana nak export excel ke mysql | poshberry | Website Programming | 15 | 04-06-2004 04:29 PM |
| Camane nak export flash jadi movie clip ? | myravens | Website Design | 0 | 12-08-2003 05:07 PM |
All times are GMT +8. The time now is 01:05 PM.
Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.
