Results 1 to 3 of 3
Thread: MySQL Datatypes
Jan 18, 2002, 19:42 #1
- Join Date
- Feb 2001
- 0 Post(s)
- 0 Thread(s)
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.