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?

Regarding imports, make sure to checkout the MySQl documentation.

Quote:

---

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.

Quote:

---

I want to automatically create a MySQL data structure based on these txt files.

---

Also in the docs, near the bottom.

Cheers