Linux下shell执行SQL

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');“