数据库基本操作

#创建数据库
 create database people;
 create database people character set utf8;
 #进入数据库
 use people;
 #删除数据库
 drop database people;
 #创建表
 create table nan;
 #查看表
 show table nan;
 desc nan;
 #删除表
 drop table nan;
 id int,name varchar ,sex char
 #添加数据
 insert into nan(name,sex)value ('张三','男'); 
 #修改数据
 update nan set sex='nv' where name='张三';
 #删除数据
 delete from nan;//删除所有数据
 delete from nan where name='张三';//只删除名字叫张三的
 #查看数据
 select * from nan;//查看所有数据
 select sex from nan;//查看所有数据性别
 select sex from nan where name='张三';//只查看名字为张三的性别