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
Bookmarks