目录与学习目标
1:前置建表语句_DDL
2:插入数据
3:修改数据
4:删除数据
1:前置建表语句_DDL
DROP TABLE IF EXISTS `actor`;
CREATE TABLE `actor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(16) DEFAULT NULL,
`age` INT DEFAULT NULL,
`address` varchar(128) DEFAULT NULL,
`update_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) CHARSET=utf8;
2:插入数据
1:插入单条数据
INSERT INTO actor VALUES (1,'hsj',18,'广州市',NOW());
INSERT INTO actor VALUES (2,"hesj",18,"广州市",NOW());
2:针对某列插入数据
INSERT INTO actor(id,name,age,address,update_time) VALUES (3,"hesj",18,"广州市",NOW());
INSERT INTO actor(name,age,address,update_time) VALUES ("hesj_666",18,"广州市",NOW());
DELETE from actor;
INSERT INTO actor(name,age,address,update_time) VALUES ("hesj_666",18,"广州市",NOW());
最后的结果如下,前面已经插入过4条数据了,因此自增序列记录的序号为4,
哪怕把数据都删除了,使用自增去插入,序号也是从5开始。
3:一次性插入多行数据
INSERT INTO actor VALUES
(6,'hsj',18,'广州市',NOW()),
(7,'hsj',18,'广州市',NOW());
4: 针对某列一次性插入多行数据
INSERT INTO actor(name,age,address,update_time) VALUES
("hesj_1",18,"广州市",NOW()),
("hesj_2",18,"广州市",NOW()),
("hesj_3",18,"广州市",NOW());
3:修改数据
UPDATE actor SET name='何XX' WHERE id=1;
注意:
需要限制where的范围,否则会修改所有的数据
4:删除数据
DELETE FROM actor WHERE id=1;
注意:
需要限制where的范围,否则会删除所有的数据