![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
weixin_39669410
从心开始,勇登高峰
展开
-
mysql dual 手动实现多条数据插到临时表的一列
select * from (select 1 as id from dual unionselect 2 as id from dual unionselect 3 as id from dual unionselect 4 as id from dual unionselect 1 as id from dual) tunion会合并重复数据原创 2021-12-13 15:45:44 · 924 阅读 · 0 评论 -
mysql模拟插入多条测试数据
1、建表CREATE TABLE user( user_id varchar(36), name varchar(64), email varchar(64), password varchar(64), address varchar(255), mobile varchar(255), PRIMARY KEY(user_id))ENGINE=InnoDB;2、原创 2020-06-26 18:25:16 · 361 阅读 · 0 评论