mysql的简单使用
打开命令行,输入
mysql -u root -p
退出mysql
exit;
创建数据库myuser
create database myuser;
使用数据库,这句话一定不能少
use myuser;
创建user表格
create table user( id int, name varchar(16) )
插入数据
Insert into user values{"2","zheng"}
查询user
select * from user;
修改数据
update user set name="admin",password="admin" where id=1;
查询数据库中所有表
show tables;
删除表
drop table user;
查询mysql中所有数据
show databases;
删除一个数据库
drop database dbname;
常见查询
SELECT * FROM user WHERE id=889 SELECT * FROM user WHERE id BETWEEN 345 AND 678 SELECT id name a.money-b.money As money FROM user AS a,user AS b WEHRE a.id=b.id+1 SELECT a.id,a.name,a.money-b.money FROM user a,user b WHERE a.id=b.id+1 AND a.id BETWEEN 200 AND 300; SELECT * FROM USER WHERE id = (SELECT MAX(id) FROM user);
注意:当你关闭命令行后,它就不记得你要用哪个数据库了
因此使用之前,要
use myuser;
来定位你的数据库