Re: Mysql's equivalent of SQL Loader or BCP/DTS??
In the last episode (Jul 31), David Kramer said: > 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... Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html . It's a stripped-down version 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/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, at 01:42 PM, Venkata Sudheer Buddiga wrote: > > > > hi list, im giving this command > mysql>LOAD 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 address fields > > > > > > > > Regards, > Venkata Sudheer Buddiga. > Web Hosting Solutions, > Ext : 219, 250 > === > Venkata Sudheer Buddiga > Nettlinx Limited, 3rd Floor, My Home Sarovar Plaza, > Secretariat Road, Saifabad, Hyderabad- 500 004. > Tel: +91 (0)40 3232 200 Fax: +91 (0)40 3231 610 > http://www.nettlinx.com/ > === > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
loader
hi list, im giving this command mysql>LOAD 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 address fields Regards, Venkata Sudheer Buddiga. Web Hosting Solutions, Ext : 219, 250 === Venkata Sudheer Buddiga Nettlinx Limited, 3rd Floor, My Home Sarovar Plaza, Secretariat Road, Saifabad, Hyderabad- 500 004. Tel: +91 (0)40 3232 200 Fax: +91 (0)40 3231 610 http://www.nettlinx.com/ === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php