mysql在cmd中详细操作步骤

1、//首页登入mysql -u root -p密码：//创建库：mydbcreate database mydb;//使用数据库use mydb;

2、//创建表：用户表 usercreate table user -> ( -> 坡纠课柩id int pri罪焐芡拂mary key auto_increment,//主键 -> username varchar(20) not null,//用户名 -> password varchar(20) not null,//密码 -> age int not null,//年龄 -> sex varchar(10) ,//性别 -> address varchar(20),//地址 -> hobby varchar(20),//爱好 -> createTime DateTime//注册时间 -> )charset=utf8;select now();

3、//1.认真插入存入10条测试数据insert into user(username,password,age,sex,addr髫潋啜缅ess,hobby,createTime) -> values('A','123',12,'man','jiangxi','chiji',now()), -> ('B','234',14,'man','beijing','dawangzhe',now()), -> ('C','345',16,'woman','shanghai','sleep',now()), -> ('D','456',18,'man','nanchang','eat',now()), -> ('E','567',20,'woman','yunnan','run',now()), -> ('F','678',38,'woman','hunan','basketball',now()), -> ('G','789',15,'woman','fujian','music',now()), -> ('H','890',19,'man','hangzhou','sing',now()), -> ('I','901',23,'man','HongKong','dance',now()), -> ('j','012',22,'woman','aomen','play',now());

4、//2.查询所有的用户信息select * from user;

5、//3.查询Id为3的用户信息select *from user where id=3;

6、//4.查询所有女生的信息select *from user where sex='woman';

7、//将所有男性年龄增加1岁update user set age=age+1 -> where sex='man';select *from user where sex='man';

8、//7.将爱好为“打代码”和“打农药“的用户信息查出来 select * from user -> where hobby='wangzhe'or hobby='dama';