Running with MySQL 5.6.36 on Windows 10, I am writing a script in .sql file. I need to run some shell command (in this case to concatenate two files).
How can i do it?
I tried this but it gives "compilation error":
\! ls
It says:
Syntax error: '\' escape operator is not valid input at this position
I can't reproduce the error:
File: /path/to/file/test.sql
SELECT VERSION();
SELECT 'system' `system`;
system ls -al myDir
SELECT '\\!';
\! ls -al myDir
MySQL Command Line:
mysql> \. /path/to/file/test.sql
+-----------+
| VERSION() |
+-----------+
| 5.7.11 |
+-----------+
1 row in set (0.00 sec)
+--------+
| system |
+--------+
| system |
+--------+
1 row in set (0.00 sec)
total 0
dr-------- 2 user user 10 Jan 12 00:00 .
dr-------- 23 user user 280 Jan 13 23:00 ..
+----+
| \! |
+----+
| \! |
+----+
1 row in set (0.00 sec)
total 0
dr-------- 2 user user 10 Jan 12 00:00 .
dr-------- 23 user user 280 Jan 13 23:00 ..
The system (\!) command works only in Unix., see 4.5.1.2 mysql Commands. Try using Windows Subsystem for Linux (WSL), see Windows 10 Installation Guide.