MySql常用语句更新（update...）

# create db
create database if not exists demo default character set = 'utf8';

# view db grant
show create database demo;

grant all privileges on demo.* to 'demo'@'x.x.x.x' identified by '123456';

# view user&grant information
select user,password,host from mysql.user;

 

# 查看mysql 执行进程列表

show processlist;

 

#查询是否锁表

show OPEN TABLES where In_use > 0;

 

转载于:https://www.cnblogs.com/Cong0ks/p/11088911.html