- MYSQL 8 基本操作之10 (实现for循环逐个遍历)
- 如果只是简单的插入,也可以:
要求表people1必须存在,才可以复制数据从表people到表people1。
INSERT INTO people1 SELECT * FROM people WHERE 条件
要求表people1必须不存在,才可以复制数据从表people到表people1
select * into people1 from people WHERE 条件
- 简单更新:
update people1 set name = (SELECT name FROM people WHERE id = people1.id);
MYSQL 8 基本操作之10 (实现for循环逐个遍历)
最新推荐文章于 2024-07-08 02:51:24 发布