LOAD
TABLE
ticket_type
(ticket_type ,
ticket_type_name ' \x0d\x0a ' )
FROM ' C:\\bcpData\\ticket_type.txt '
QUOTES OFF
ESCAPES OFF
FORMAT ASCII
DELIMITED BY ' \x09 '
ON FILE ERROR CONTINUE ;
COMMIT ;
(ticket_type ,
ticket_type_name ' \x0d\x0a ' )
FROM ' C:\\bcpData\\ticket_type.txt '
QUOTES OFF
ESCAPES OFF
FORMAT ASCII
DELIMITED BY ' \x09 '
ON FILE ERROR CONTINUE ;
COMMIT ;
换行符写在最后一个字段后面。