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.