Import data into MySQL from a bcp output file - SQL Snipplr Social Repository

Revision: 36822

at November 27, 2010 03:14 by eddequincey

Initial Code

LOAD DATA INFILE 'table_name.bcp' into table table_name
FIELDS TERMINATED BY '@**@'  LINES TERMINATED BY '*@@*';

Initial URL

Initial Description

Initial Title

Import data into MySQL from a bcp output file

Initial Tags

mysql, sql

Initial Language

SQL