Linux下shell执行SQL
2020-04-03 本文已影响0人
咗嚛
mysql -P 端口号 -u用户名 -p密码 -e"use数据库名;待执行的sql语句;"
取消用户密码有效期，关闭修改密码
/usr/local/u-mail/service/mysql/bin/mysql -uumail -p`cat /usr/local/u-mail/config/mysql_password.conf` -e "use umail;update umail.core_mailbox set pwd_days ='0',change_pwd='-1',first_change_pwd='-1';"
mysql -P 3306 -uroot -p123456 -e"
use fish;
update t_user set username='张三';
删除禁用账号的个人通讯录
/usr/local/u-mail/service/mysql/bin/mysql -uumail -p`cat /usr/local/u-mail/config/mysql_password.conf` -e "use umail;delete from wm_addrbook_contact WHERE email<>'' AND email IN(SELECT `mailbox` FROM `core_mailbox` WHERE `disabled`='1');“
