查看数据库　　show databases;

使用数据库　　use xxxxx;

查看该数据库下的所有表　　show tables;

创建数据库　　create database haotest charset utf8;

删除数据库　　drop database haotest;

创建简单的表　　

mysql> create table stu (

-> snum int,

-> sname varchar(10)

-> )engine myisam charset utf8;

删除表　　mysql> drop table stu;

修改表明　　mysql> rename table stu to student;

插入数据

mysql> insert into student values

-> (1, 'zhangsan'),

-> (2,'lisi'),

-> (3,'wangwu');

删除一张表　　mysql> truncate student;

truncate和delete差别：truncate相当于删除表并重建空表，delete删除行

 

增

插入多行

mysql> insert into class

-> (sname, gender, salary)

-> values

-> ('yoki', '女', 50)，

-> ('sampson', '男', 100);

 

删

mysql> delete from class where expr;

改

mysql> update class

-> set fanbu=1234

-> where id=6;

 

 

mysql> update class

-> set company='tencent'

-> ,fanbu=1000

-> where id=11

-> ;

查

select sname,gender, id from class where epxr;