mysql: tool to export a query into a new table?

Discussion in 'MySQL' started by falcondriver, Jun 25, 2006.

0
  1. #1
    i use navicat here, but you can only export the full table. quite useless, just because this table its to big to export or import it via phpmyadmin. any other ideas....?
     
    falcondriver, Jun 25, 2006 IP
  2. iconv

    iconv Well-Known Member

    Messages:
    189
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    108
    #2
    This is probably what you're looking for:

    CREATE TABLE new_tbl SELECT * FROM orig_tbl WHERE 1;

    Adjust the select query as necessary.
     
    iconv, Jun 26, 2006 IP
    falcondriver likes this.