create user haige@'%' identified by '123456'

grant all privileges on *.* to haige@'%' identified by '123456';

grant all privileges on *.* to haige@'%' identified by '123456';

SET PASSWORD FOR 'haige6'@'192.168.10.%' = PASSWORD('123456');

flush privileges;

drop user haige@'192.168.10.%';

show databases;

create database king;

use king;

show tables;

create table if not exists tanks1 ( id int(12) not null default '0', name varchar(255) not null, skills varchar(255) not null, price int(11) not null, primary key (id) )engine=innodb default charset=uutf8;

insert into tanks1 (id,name,skills,price) values (2,'zhouwan','123234w大招回血','88');

select * from tank1;

select * from king.tanks1 order by price;

select * from king.tanks1 order by price desc;

delete from table名 where 列名='列值';

delete from table名;

update king.tanks1 set name=123 where name="猪八戒";

show create tables tanks1;

show create database king;

truncate from table;

drop table tanks1;

drop database king;