Professional Web Applications Themes

loading a table using a text file with insert syntax - MySQL

I have a text file with INSERT INTO Customers VALUES ( ..... , ...... , etc ) lines and would like to know how do I tell mysql to use this file to load a table which I have created.........

  1. #1

    Default loading a table using a text file with insert syntax

    I have a text file with INSERT INTO Customers VALUES ( ..... , ...... ,
    etc ) lines and would like to know how do I tell mysql to use this file to
    load a table which I have created......


    don Guest

  2. #2

    Default Re: loading a table using a text file with insert syntax

    don wrote:
    > I have a text file with INSERT INTO Customers VALUES ( ..... , ...... ,
    > etc ) lines and would like to know how do I tell mysql to use this file to
    > load a table which I have created......
    You can do this with the mysql command-line tool.

    [url]http://dev.mysql.com/doc/refman/5.0/en/batch-mode.html[/url]

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. read text file insert into database
    By navee in forum Macromedia ColdFusion
    Replies: 2
    Last Post: April 11th, 08:08 AM
  2. Replies: 0
    Last Post: July 23rd, 11:30 PM
  3. loading variables from a text file...
    By Zerox Millienium webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 9
    Last Post: February 12th, 03:22 PM
  4. need to automatically insert a text file into image
    By cluciano in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 3
    Last Post: July 31st, 07:45 PM
  5. Insert into <table w/ text column> select distinct ...
    By Adam Nester in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 30th, 04:38 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