mysql EOF

最新推荐文章于 2022-11-14 21:00:00 发布

weixin_30552635

最新推荐文章于 2022-11-14 21:00:00 发布

阅读量566

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/52shaidan/p/10107222.html

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

转载于:https://www.cnblogs.com/52shaidan/p/10107222.html