【讨论中】mysql5.5.30 system函数失效，客户端无法识别system命令

visician

操作系统是win server2008 64位，装的mysql5.5.30。

1. 
   
2. mysql> select  @@version;
   
3. +------------+
   
4. | @@version  |
   
5. +------------+
   
6. | 5.5.30-log |
   
7. +------------+
   
8. 1 row in set (0.00 sec)
   
9. 
   
10. mysql> system dir C:;
    
11. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
    
12. for the right syntax to use near 'system dir C:' at line 1
    
13. mysql> system(dir C:);
    
14. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
    
15. for the right syntax to use near 'system(dir C:)' at line 1
    
16. mysql> system ping 127.0.0.1;
    
17. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
    
18. for the right syntax to use near 'system ping 127.0.0.1' at line 1
    
19. mysql>

复制代码

visician

求高人答疑解惑啊

Shaquile

Because system command only works on unix/linux platform.

in Linux:

1. mysql> system dir /tmp
   
2. list.2248.md5   myreschown
   
3. createErr          list.17914.md5  list.22724.md5  mysql.sock
   
4. list.9364.md5   scripts
   

复制代码

http://stackoverflow.com/questions/7457056/mysql-system-command

visician

@Shaquile 多谢