Mysql's equivalent of SQL Loader or BCP/DTS??

Im looking for info on Mysql's Bulk Data Loading Utility? Does it even have one? Does it just use Perl's DBI? Any syntax would be greatly appreciated... Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889

Re: Mysql's equivalent of SQL Loader or BCP/DTS??

of Oracle's SQL*Loader syntax, but useable for most purposes. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

loader

hi list, im giving this command mysqlLOAD DATA LOCAL INFILE c:/phani/phani.txt INTO TABLE phani1; the columns in phani1 are equal to columsn in phani.txt There are totally 3 columsn (empno, ename, address) when i say select * from phani1; im getting only empno and null values for ename and

Re: loader

Specify the format of the text field in your query. For example, if the fields are tab-delimited and each line is a new row, you would use load data local infile 'c:\phani\phani.txt' into table phani1 fields terminated by '\t' rows terminated by '\n'; Ben Gollmer On Tuesday, May 8, 2001,