mysql

1)创建数据库 create database wpj1105;

2)创建数据库 create database wpj1105;

3)判断是否存在库 : drop database if exists wpj1105;

4)使用该数据库 use wpj1105; 5)#显示数据库中的表 show tables;

6)创建表create table student( id int auto_increment primary key, name varchar(50) not null, sex varchar(20), date varchar(50), content varchar(100) )default charset=utf8;

7)查找表 select xxxxx from student;

8)显示表的结构：desc student;

9)添加数据 insert into student values(null,’aa’,’男’,’1988-10-2’,’……’);

10)修改数据表的编码方式:ALTER TABLE test DEFAULT CHARACTER SET utf8

11)ALTER TABLE test CHANGE name name VARCHAR(36) CHARACTER SET utf8 NOT NULL; 该命令用于将表test中name字段的编码方式改为utf8

12)修改某一条数据update student set sex=’男’ where id=4;

13)delete from student where id=5;

14删除数据delete from student where id=5; 15)# and 且select from student where date>’1988-1-2’ and date<’1988-12-1’; 16)# or 或 select from student where date<’1988-11-2’ or date>’1988-12-1’; 17)#between select * from student where date between ‘1988-1-2’and’1988-12-1’;

18)修改数据update c set age=66 where id=2;update c set name=’花花’,age=21,sex=’女’ where id=2