mysql的update语句_MySql常用语句更新（update...）

【其他相关】

# 刷新

flush privileges;

# 查看活动进程

show processlist

# 查看mysql版本信息

select version();

【权限相关】

# 授权并建账号

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

# 回收权限

revoke all on *.* from 'root'@'%';

【创建相关】

# create db

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

#创建数据库

create_db_sql="create database IF NOT EXISTS ${DBNAME}"

mysql -h -P -u-p${PASSWORD} -e ""

#创建表

create_table_sql="create table IF NOT EXISTS ${TABLENAME} ( name varchar(20), id int(11) default 0 )"

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e "$"

#插入数据

insert_sql="insert into ${TABLENAME} values('billchen',2)"

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e ""

【查询相关】

# view db grant

show create database demo;

# 查看mysql 执行进程列表

show processlist;

#查询是否锁表

show OPEN TABLES where In_use > 0;

# view user&grant information

select user,password,host from mysql.user;

#查询

select_sql="select * from ${TABLENAME}"

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e ""

#更新数据

update_sql="update ${TABLENAME} set id=3"

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e ""

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e ""

【删除相关】

delete from mysql.user where user='root' and host = '%';

#删除数据

delete_sql="delete from ${TABLENAME}"

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e ""

mysql -h -P -u-p${PASSWORD} ${DBNAME} -e ""