Professional Web Applications Themes

fill column with external file list - MySQL

Hello, I have found many tutorials on how to fill a TABLE from an external file with the values (not sql, just one value per line see for this: http://www.mysql.org/doc/refman/5.1/en/loading-tables.html ). My question is: can I fill **just one COLUMN** from a table, with such a file? Thank you for any hint. François...

Sponsored Links
  1. #1

    Default fill column with external file list

    Hello,

    I have found many tutorials on how to fill a TABLE from an external
    file with the values (not sql, just one value per line see for this:
    http://www.mysql.org/doc/refman/5.1/en/loading-tables.html ).

    My question is: can I fill **just one COLUMN** from a table, with such
    a file?

    Thank you for any hint.

    François

    Sponsored Links
    f-x.p@laposte.net Guest

  2. #2

    Default Re: fill column with external file list

    net wrote: 

    Yes, see the page
    http://www.mysql.org/doc/refman/5.1/en/load-data.html
    in the same manual.

    Particularly this paragraph:
    "By default, when no column list is provided at the end of the LOAD DATA
    INFILE statement, input lines are expected to contain a field for each table
    column. If you want to load only some of a table's columns, specify a column
    list:
    LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);"


    Paul Guest

  3. #3

    Default Re: fill column with external file list

    Really Thank you Paul,

    this is exactly what I was looking for. Sorry I didn't read the
    complete manual carefully enough.

    Thanks again

    François

    f-x.p@laposte.net Guest

Similar Threads

  1. Converting a 3 column pdf address list to a one column MS word doc
    By Jay_Jump@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: February 9th, 06:46 PM
  2. Searching a column containing a list against a form list
    By DixieGal in forum Coldfusion Database Access
    Replies: 3
    Last Post: October 19th, 02:21 AM
  3. Password Column - fill with dots
    By Dave in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: December 5th, 10:07 PM
  4. select from drop list to fill table column with text -- HOW ?
    By Richard Galli in forum PHP Development
    Replies: 0
    Last Post: June 25th, 08:18 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