DB2批量插入测试数据
- 作者: S属性大腹黑
- 来源: 51数据库
- 2022-08-17
INSERT INTO USER (USERID, MOBILE) SELECT CHAR(ROW_NUMBER() OVER()) AS USERID, CHAR(13900000000 + ROW_NUMBER() OVER()) AS MOBILE FROM SYSCAT.COLUMNS T1 JOIN SYSCAT.COLUMNS T2 ON T1.COLNAME != T2.COLNAME FETCH FIRST 10000 ROWS ONLY
推荐阅读