Professional Web Applications Themes

Simple import of comma delimited files - MySQL

I'd like to import about 11 plain text files with between 5 to 30 comma delimited fields. Can I import these files into a new database without having to design each table first? I don't mind doing it one file at a time but I'm trying to avoid manually creating each table for each file in mySQL. Thanks....

  1. #1

    Default Simple import of comma delimited files

    I'd like to import about 11 plain text files with between 5 to 30
    comma delimited fields. Can I import these files into a new database
    without having to design each table first? I don't mind doing it one
    file at a time but I'm trying to avoid manually creating each table
    for each file in mySQL. Thanks.
    Pete Guest

  2. #2

    Default Re: Simple import of comma delimited files

    Pete wrote:
     


    is this a one-off or will you be loading 11 files from other sources on a
    regular basis? do they tables already exist?

    http://dev.mysql.com/doc/refman/5.0/en/load-data.html

    If you do not properly design a database - you might as well use spreadsheets or
    even worse... MSAccess. Without a proper design, you will unnecessarily
    duplicate information, have poor performance and waste programming time to make
    all of the data fit together. There is a reason it is called "relational".
    There must exist a relationship between tables. There are very few reasons to
    have a table that does not have a relation to at least one other table.


    --
    Michael Austin
    Database Consultant
    Domain Registration and Linux/Windows Web Hosting Reseller
    http://www.spacelots.com
    Michael Guest

  3. #3

    Default Re: Simple import of comma delimited files

    On Sat, 17 Feb 2007 04:18:11 GMT, Michael Austin wrote:
     

    I've imported data from spreadsheets and from Access. I'll take the
    Access-sourced stuff most day, thank you...
     

    Sure there are! We call them "grocery lists".

    --
    Premature optimization is the root of all evil.
    -- Sir Tony Hoare
    Peter Guest

Similar Threads

  1. Comma delimited array into DB problems
    By Arne de Booij in forum ASP Database
    Replies: 3
    Last Post: August 10th, 04:28 PM
  2. Creating a comma delimited list
    By Ryann in forum ASP Database
    Replies: 3
    Last Post: October 4th, 02:05 PM
  3. comma delimited list problem
    By Shaun Perry in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: February 16th, 12:09 PM
  4. Parsing Comma Delimited Strings
    By Word of Mouth Productions in forum Macromedia Director Lingo
    Replies: 5
    Last Post: September 17th, 08:38 PM
  5. generate CSV or comma delimited
    By shank in forum ASP
    Replies: 4
    Last Post: July 9th, 04:00 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