Mysql学习:4、DML命令(增删改查)及密码修改
1、查询表中所有数据:
select * from students;
2、插入数据:
insert into students (id,name,email,address) values(1,'张三','129@163.com','湖北武汉');
3、一次插入多条数据:
insert into students (id,name,email,address) values(2,'李四','329@163.com','湖北武汉'),(3,'王五','132@qq.com','河西走廊');
4、修改单个字段:
update students set address='江南' where name='张三';
修改多个字段:
update students set email='lisi@qq.com',address='地球' where name='李四';
修改mysql密码:
mysqladmin -u root -p password 要修改的新密码;
Enter password: **** 输入旧密码
5、删除列:
delete from students where name='张三';
6、查询指定的列:
select name,email from students;
7、条件查询及where关键字:
在where中可以使用运算符及关键字:
select * from students where gender='男' and age=20;
8、查询语句:
9、模糊查询: