Hello-

i have created the following columns in my table:

apn INT(11) ---for a 6-10 digit number
company INT(1) ---for a 1 digit company code
property INT(11) ---for a 6-8 digit number
annualized DECIMAL (7,2) ---for a $ amt.
fee DECIMAL (6,2) ---for a $ amount

after i create the table i attempt to load a .csv like so:
LOAD DATA LOCAL INFILE '/nameoffile.csv' INTO TABLE table_name

the message says nothing is dropped, but there are tons of warnings? i check the table and the only thing that shows is the apn column.

am i declaring the datatypes properly?

do i already have to have a column with primary key, or can i add that column later?

i'm new to this.. thanks for your reply.