GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

BULK INSERT command not running successfully

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • BULK INSERT command not running successfully

    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.
Working...
X