常用sql语句

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

update user set password=password('wangxiaohu') where user='root';

update table1 SET title=replace(title,'abc','123') where id=100;

flush privileges;

select *,FROM_UNIXTIME(udate, '%Y-%m-%d') as atime from think_cron_result where cron_id=6082928;