MySql入门-插入|修改|删除数据

插入数据

语法：
INSERT INTO table_name ( field1, field2,field3) VALUES ( value1, value2,value3 );

INSERT INTO test.z_tool (id, title, url, source, createTime) VALUES (‘1’, ‘java基础’, 'https://www.runoob.com/java/java-tutorial.html ', ‘菜鸟课程’, ‘2020-05-07 10:59:10’);
INSERT INTO test.z_tool (id, title, url, source, createTime) VALUES (‘2’, ‘MYSQL菜鸟课程’, 'https://www.runoob.com/java/java-tutorial.html ', ‘菜鸟课程’, ‘2020-05-07 10:59:10’);
INSERT INTO test.z_tool (id, title, url, source, createTime) VALUES (‘3’, ‘Postman学习’, 'https://www.runoob.com/java/java-tutorial.html ', ‘菜鸟课程’, ‘2020-05-07 10:59:10’);
INSERT INTO test.z_tool (id, title, url, source, createTime) VALUES (‘4’, ‘JMETER性能测试入门’, ‘https://edu.csdn.net/course/detail/22948’, ‘CSDN’, ‘2020-05-07 10:59:10’);
INSERT INTO test.z_tool (id, title, url, source, createTime) VALUES (‘5’, ‘linux从入门到实战’, ‘https://edu.csdn.net/course/detail/28103’, ‘CSDN’,‘2020-05-07 10:59:10’);

id	title	url	source	createTime
1	java基础	https://www.runoob.com/java/java-tutorial.html	菜鸟课程	2020-05-07 10:59:10
2	MYSQL菜鸟课程	https://www.runoob.com/java/java-tutorial.html	菜鸟课程	2020-05-07 10:59:10
3	Postman学习	https://www.runoob.com/java/java-tutorial.html	菜鸟课程	2020-05-07 10:59:10
4	JMETER性能测试入门	https://edu.csdn.net/course/detail/22948	CSDN	2020-05-07 10:59:10
5	linux从入门到实战	https://edu.csdn.net/course/detail/28103	CSDN	2020-05-07 10:59:10

查询数据

select * from z_tool ;

更新数据

update z_tool set title=‘linux从入门到实战123’ where id=5 ;
select * from z_tool where id=5 ;

删除数据

delete from z_tool where id=5; #删除id=5的记录

delete from z_tool ; #删除所有