Results 1 to 2 of 2

Thread: Loading data into MySQL

  1. 06-18-2003, 05:47 AM #1
    amstel_za
    amstel_za is offline Registered User
    Join Date
    May 2003
    Posts
    3

    Loading data into MySQL

    Hey all,

    Is there anyway of customizing the Load Infile command?? I want to load data seperated by ";" or "," and not spaces?

    In addition, Can you create/load information into mysql tables without being connected? I have information being created by MapInfo and saved as txt files. I want to automatically create a MySQL data structure based on these txt files...

    Would I need a perl script to connect and load all the info?
    Reply With Quote Reply With Quote
  2. 06-18-2003, 10:05 AM #2
    nicc777
    nicc777 is offline Registered User
    Join Date
    Feb 2003
    Location
    Johannesburg, South Africa
    Posts
    145
    Regarding imports, make sure to checkout the MySQl documentation.

    In addition, Can you create/load information into mysql tables without being connected?
    You need to be connected to a database server in order to perform any updates/inserts etc.

    I want to automatically create a MySQL data structure based on these txt files.
    Also in the docs, near the bottom.

    Cheers
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules