Professional Web Applications Themes

SELECT INTO OUTFILE - MySQL

Hi there, I'd like to dump the result of a select query such as e.g. select * from table where clause = 'true' into outfile 'outfile.csv'; but not into CSV format, but into SQL statements. I also tried mysql -e "select * from table where clause = 'true'" > outfile.sql to no avail. Any pointer would be very much appreciated. Cheers, Neo...

  1. #1

    Default SELECT INTO OUTFILE

    Hi there,

    I'd like to dump the result of a select query such as e.g.

    select * from table where clause = 'true' into outfile 'outfile.csv';

    but not into CSV format, but into SQL statements.

    I also tried

    mysql -e "select * from table where clause = 'true'" > outfile.sql

    to no avail. Any pointer would be very much appreciated.

    Cheers,
    Neo

    Thomas Guest

  2. Moderated Post

    Default Re: SELECT INTO OUTFILE

    Removed by Administrator
    Radoulov, Guest
    Moderated Post

  3. #3

    Default Re: SELECT INTO OUTFILE


    Radoulov, Dimitre wrote: 

    Thanks for your answer, Dimitre.

    I want to create a standard MySQL dumpfile that can later on be
    imported with

    mysql -uuser -ppass database < dumpfile.sql

    .... but of course based on a select query as decribed before.

    Cheers,
    Neo

    Thomas Guest

  4. Moderated Post

    Default Re: SELECT INTO OUTFILE

    Removed by Administrator
    Radoulov, Guest
    Moderated Post

Similar Threads

  1. Replies: 3
    Last Post: August 17th, 02:20 PM
  2. Question about OUTFILE?
    By Mark Weisman in forum PERL Beginners
    Replies: 1
    Last Post: November 2nd, 11:53 AM
  3. Replies: 0
    Last Post: September 24th, 03:24 AM
  4. Replies: 0
    Last Post: September 11th, 12:19 AM
  5. Replies: 0
    Last Post: April 15th, 01:22 PM

Bookmarks

Posting Permissions

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

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 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139