getyourbiglobst — Tue, 22 Jan 2002 19:50:59 +0000

here are some actual column names and values.

APN
------
417666

COMPANY_ID
----------
2

PROPERTY_ID
-----------
8231501

ANNUALIZED
----------
444.00

FEE
----
14.67

wil- just curious as to why i should change to small INT?
thanks for the help.

Wil — Sat, 19 Jan 2002 18:27:30 +0000

It would also help to see a sample of the data you're trying to import into your database.

You're also going to save some memory by changing those to SMALLINT.

mairving — Sat, 19 Jan 2002 02:06:57 +0000

If you use the load data statement, MySQL is expecting a text file that is tab delimited, i.e. no commas. I think the proper syntax for a comma delimited file is:
LOAD DATA LOCAL INFILE "pathtofile/filename.csv" fields terminated by , into TABLE tablename;

You can also optionally select which fields to import. For instance, if your company name was the same, just leave the field out and change the column default to the company name. So if field 4 had a default value, just leave it off of your load data statement. Then do it like so:
LOAD DATA LOCAL INFILE "pathtofile/filename.csv" fields terminated by , into TABLE tablename (fieldname1, fieldname2, fieldname3, fieldname5);