lexical error in javadb
i through mysqldump loaded all my create definition in a sql file now i am copying the data from that sql file into the netbeans sql editor while working on java db , the following error is coming :
Error code -1, SQL state 42X02: Lexical error at line 1, column 14. Encountered: "`" (96), after : "".
why this is coming even when the same script is running succesfully in mysql.
Because MySQL'y SQL syntax is seemingly slightly different from JavaDBs, which isn't surprising since JavaDB is completely SQL 92/98 conformant and MySQL is not.