- 论坛徽章:
- 0
|
脚本如下
#!/bin/sh
sql="/usr/bin/mysql -h127.0.0.1 -P3306 -uroot -p123456 test -e\"insert into t1(f1,f2,f3,f4) values('1','2','3','4')\""
echo $sql
$sql
exit 0
~
执行提示错误:
/usr/bin/mysql -h127.0.0.1 -P3306 -uroot -p123456 test -e"insert into t1(f1,f2,f3,f4) values('1','2','3','4')"
/usr/bin/mysql Ver 14.14 Distrib 5.1.71, for redhat-linux-gnu (x86_64) using readline 5.1
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Usage: /usr/bin/mysql [OPTIONS] [database]
我理解是语句没完全识别,我想让它完整执行,该怎么写?求助!!! |
|