I get an error when importing a csv file.
Query OK, 16394 rows affected, 176 warnings (0.27 sec)
Records: 16394 Deleted: 0 Skipped: 0 Warnings: 176
LOAD DATA LOCAL INFILE '/path/janfeb2008.csv'
into table tablename
fields terminated by ','
lines terminated by '\r\n'
(
ticket_number,
title,
incident_type,
@date_occurred,
@date_resolved,
keyword,
sub_component,
priority,
c1_customer,
reporter_name,
c2_resolvedby,
sub_application,
env_location,
component,
logged_by_dep,
route_queue,
contact_name
)
set
date_occurred = str_to_date(@date_occurred, '%m/%d/%Y'),
date_resolved = str_to_date(@date_resolved, '%m/%d/%Y')
I can't seem to find the problem. Not all rows of all columns contain data but I didn't think this was an issue.
Version info:
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386) using readline 5.0
Query OK, 16394 rows affected, 176 warnings (0.27 sec)
Records: 16394 Deleted: 0 Skipped: 0 Warnings: 176
LOAD DATA LOCAL INFILE '/path/janfeb2008.csv'
into table tablename
fields terminated by ','
lines terminated by '\r\n'
(
ticket_number,
title,
incident_type,
@date_occurred,
@date_resolved,
keyword,
sub_component,
priority,
c1_customer,
reporter_name,
c2_resolvedby,
sub_application,
env_location,
component,
logged_by_dep,
route_queue,
contact_name
)
set
date_occurred = str_to_date(@date_occurred, '%m/%d/%Y'),
date_resolved = str_to_date(@date_resolved, '%m/%d/%Y')
I can't seem to find the problem. Not all rows of all columns contain data but I didn't think this was an issue.
Version info:
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386) using readline 5.0