Getting an error when using 'souce [file]' in Navicat command line mode

138 views Asked by At

I have a file named 'test.txt' that contains some SQL statements. When I use PowerShell (Windows 8.1) and login MySQL, then use:

source d:/test.txt;

everything works out fine.

But when I use the same command in Navicat's (v11.0.10) command mode (press F6 in Navicat) I got an error like:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'source d:/test.txt;' at line 1

Anyone know the reason?

0

There are 0 answers