how to fix unknow command error

  • mohd.elfakharany

    SSC Journeyman

    Points: 81

    I created a database with a table based on an output from a finger scanner device, which export a .dat file extension. im trying to import that file into my table using mysql, i get the following errors (screen shot in the attached file)

  • robert.gerald.taylor

    SSChampion

    Points: 13130

    I'm guessing this isn't SSRS related and that you'd probably have better luck asking a MySQL load question on forums specifically for MySQL as opposed to MS SQL Server.

    Good luck,

    Rob

  • podmate

    SSCommitted

    Points: 1666

    This is definitely a MySQL syntax issue.

    You would be better served by posting this on a MySQL specific site, but I'll give it a stab as I have a soft spot for MySQL.

    Verify that your LOAD DATA file path is enclosed in commas and not MS Word's version of commas. Common issue on the command line if you are cutting and pasting (from Word or a web site) especially in a Windows environment.

    I can't tell based on the images attached, but does your LOAD command actually load into a table?

    Example:

    LOAD DATA LOCAL INFILE

    'C:\Program Files\MySQL\MySQL Server 5.6\bin\attlog' INTO TABLE YOUR_TABLE_NAME_HERE;

    You might need a lines terminated by statement as well depending on your file.

    Example:

    LOAD DATA LOCAL INFILE

    'C:\Program Files\MySQL\MySQL Server 5.6\bin\attlog'

    INTO TABLE YOUR_TABLE_NAME_HERE

    LINES TERMINATED BY '\r';

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply