学习mysql数据库

1、显示数据库列表。 
show databases; 
2、显示库中的数据表： 
use mysql;

show tables;

3、显示数据表的结构： 

describe 表名; 
4、建库： 
create database 库名; 
5、建表： 
use 库名； 
create table 表名 (字段设定列表)； 
6、删库和删表: 
drop database 库名; 
drop table 表名； 
7、将表中记录清空： 
delete from 表名; 
8、显示表中的记录： 
select * from 表名

例如：

create database chatroom;
use chatroom;
create table user(
	id int primary key auto_increment,
	username varchar(20),
	password varchar(20),
	type varchar(20)
);

insert into user values(null,'aaa','aaa','admin');
insert into user values(null,'bbb','bbb','user');
insert into user values(null,'ccc','ccc','admin');
insert into user values(null,'ddd','ddd','user');

9.where语句

select * from user where username='aaa'

10.update语句

update user set username='eee' where username='aaa'

11.like语句

select * from user where username like "%a"