mysql在cmd中详细操作步骤

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

3、//1.认真插入存入10条测试数据insert into user(username,password,age,sex,address,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());

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

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