Mysql常用sql语句汇总

SELECT `pe2e_user_to_pany`.pany_name, `pe2e_user_to_pany`.pany_code, `users`.name, `users`.uid, `users`.mail, `pe2e_email_notification_email`.`email_` FROM `users` , `pe2e_user_to_pany` LEFT JOIN `pe2e_email_notification_email` ON `pe2e_user_to_pany`.`uid` = `pe2e_email_notification_email`.`uid` WHERE `users`.`uid` = `pe2e_user_to_pany`.`uid` into outfile '/tmp/users.csv' fields terminated by ',' enclosed by '"' lines terminated by '\r\n'; 

[root@166087 mysql]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.f --datadir=/data/mysql --skip-grant-tables

mysql> update user set authentication_string=password('123456') where user='root';

update user set host='%' where user='root' and host='localhost';

flush privileges;    #刷新权限表，使配置生效

use mysql        #打开mysql数据库

update user set host='localhost' where user='root';    #将host设置为localhost表示只能本地连接mysql

flush privileges;    #刷新权限表，使配置生效

update user set password=password('123456') where User='root';#修改密码

flush privileges ; #刷新权限表，使配置生效

grant all on . to 'yuancheng'@'%' identified by '123456';

flush privileges;

update t_ment SET avatar = replace(avatar, 'http', 'https');//替换

update t_log set message=concat("https",message);//前面追加