View Review Details


Book:   Learning SQL
Subject:   Failed to open file error
Date:   2008-11-03 19:14:22
From:   cj brown
Response to: Failed to open file error

Rating:  StarStarStarStarStar

Looks like the example needs to be compiled before I can use... I get this error.


-> source C:\Users\CJ\Desktop\LearningSQLExample_sql.txt;



ERROR:
Unknown command '\U'.
mysql: Character set 'JDesktopLearningSQLExample_sql.txt;' is not a compiled cha
racter set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file
Charset is not found


Any assistanve will be appreciated.
Respectfully,
CJ

Full Threads Oldest First
  • Failed to open file error,  November 14 2008
    Rating: StarStarStarStarStar
    Submitted by johns2947   [Respond | View]

    Check the name of your file. When you download it, it should be :

    LearningSQLExample.sql

    You can use that at is, without changing it to a .txt file

    Make sure you opened the database first, as in the book instruction.

    mysql> use bank;

    then run source