Results 1 to 4 of 4

Thread: Export hugh data from MySQL

  1. #1
    Join Date
    Jul 2007
    Location
    Kongtechnology.com
    Posts
    14
    Rep Power
    0

    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?

  2. #2
    Join Date
    Sep 2005
    Location
    in my body lar...
    Posts
    1,325
    Rep Power
    0
    may i know what is a "hugh table"? Is it a table name or it actually "huge table"?

  3. #3
    Join Date
    Jul 2001
    Location
    Jail
    Posts
    228
    Rep Power
    220
    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..

  4. #4
    Join Date
    Jun 2001
    Location
    Mystic Kingdoms
    Posts
    2,749
    Rep Power
    271
    my eye largely open..
    wow!.. mozaks.

    OMG OMG.. hell long time no see :P

    KongTech.. i think soo.. you nee to do sql query.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How PHP and MySQL helped voter data analysis
    By saengch in forum Showcase
    Replies: 1
    Last Post: 16-01-2009, 05:47 PM
  2. save data from hyperterminal into mysql through vb.net
    By areah in forum Website Programming
    Replies: 5
    Last Post: 23-12-2008, 03:40 PM
  3. How do i fix data truncated error in mysql?
    By silentD in forum Website Programming
    Replies: 3
    Last Post: 14-01-2008, 03:19 PM
  4. How do i display data from mysql database?
    By silentD in forum Website Programming
    Replies: 2
    Last Post: 14-01-2008, 10:16 AM
  5. mcmana nak export excel ke mysql
    By poshberry in forum Website Programming
    Replies: 15
    Last Post: 04-06-2004, 04:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112