mysql EOF

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

mysql shell 执行脚本 #!/bin/bash   export PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/mysql-5.6/bin:/usr/local/mysql/bin   mysql  -H   -uroot -p'mysqlpass' -S /ssd/mysql/3306/tmp/mysql.sock   <<EOF     use db_name;   update lo_xx_order a set a.member_name='xx' where and a.member_name='0';     exit EOF