基础的mysql操作
1、启动mysql,并且输入密码
mysql-uroot-p
2、修改密码
set password = password("XXXX");
3、进入数据库
mysql -h localhost -u root -p;
4、查看当前服务器上管理的所有数据库
show databases;
5、建立库、选择数据库
create database xupt;
use xupt;
6、在库里建表
CREATETABLEstu(
id int PRIMARY KEY not null,
name varchar(25) not null,
sex enum('M','F') default 'M',
ageint(2) default 19
);
7、修改表
alter table stu ADD email varchar(45) not null [aftername|first];
alter table stu MODIFY name varchar(45) not null [aftername|first];
alter table stu CHANGE name varchar(45) [aftername|first];
alter table stu DROP age;
alter table stu RENAMETO stu 0
8、查看表结构
desc stu(表名);
9、查看当前数据库下有多少表
show tables;
10、在表中的基本操作
插入
insert into stu0( sname,email,sex) values('lisi','lisi@163.com','M');
insert into stu0 values(null,'wangwu','sss@qq.com','F');
insert into stu0 set sname='zhangsan',email="sss@qq.com";
insert into stu0 (sname,email,sex)select name,birth,sexfromstu1;
修改
update stu0 SET email='aaa@qq.com';
update stu0 SET email='bb@qq.com'where id=4;
update stu0 SET email='ddd@qq.com',sname='angel',sex='F'where id=5;
删除数据
delete from stu0 where id>3;
还没整理完,遇到再更新