Home » Performance » MySQL » BULK INSERT command not running successfully
BULK INSERT command not running successfully [message #3414] Tue, 12 August 2008 03:00
sudhir  is currently offline sudhir
Messages: 4
Registered: August 2008
Junior Member
Hi friends
gd mornig to all .


I m trying to insert "," seperated data of a file "Myfile" into table "Mytable" using BULK INSERT command. while i m running the following script it gives an error in Mysql syntax :

BULK INSERT Mydb 'Mytable' FROM 'Myfile'
WITH
(
FIELDTERMINATOR = ',' ,
)

can anyone suggest me how i can run above comand successfully.
any help will be appreciated.


Previous Topic:Help optimizing a query not to use filesort
Next Topic:conumdrum
Goto Forum:
  



Current Time: Fri Dec 5 11:11:15 EST 2008

Total time taken to generate the page: 0.00925 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge