DB2批量插入测试数据
来源：动视网
责编：小采
时间：2020-11-09 16:12:00
DB2批量插入测试数据
DB2批量插入测试数据:DB2 DB2 INSERT INTO USER (USERID, MOBILE)SELECT CHAR(ROW_NUMBER() OVER()) AS USERID, CHAR(13900000000 + ROW_NUMBER() OVER()) AS MOBILEFROM SYSCAT.COLUMNS T1 JOIN SYSCAT.COLUMNS T2 ON T1.COLNAME != T2.COLNAME FETCH FIRST 10000 ROWS ONLY DB2
导读DB2批量插入测试数据:DB2 DB2 INSERT INTO USER (USERID, MOBILE)SELECT CHAR(ROW_NUMBER() OVER()) AS USERID, CHAR(13900000000 + ROW_NUMBER() OVER()) AS MOBILEFROM SYSCAT.COLUMNS T1 JOIN SYSCAT.COLUMNS T2 ON T1.COLNAME != T2.COLNAME FETCH FIRST 10000 ROWS ONLY DB2
DB2 DB2 INSERT INTO USER (USERID, MOBILE)SELECT CHAR(ROW_NUMBER() OVER()) AS USERID, CHAR(13900000000 + ROW_NUMBER() OVER()) AS MOBILEFROM SYSCAT.COLUMNS T1 JOIN SYSCAT.COLUMNS T2 ON T1.COLNAME != T2.COLNAME FETCH FIRST 10000 ROWS ONLY
DB2
DB2
$velocityCount-->
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
DB2批量插入测试数据
DB2批量插入测试数据:DB2 DB2 INSERT INTO USER (USERID, MOBILE)SELECT CHAR(ROW_NUMBER() OVER()) AS USERID, CHAR(13900000000 + ROW_NUMBER() OVER()) AS MOBILEFROM SYSCAT.COLUMNS T1 JOIN SYSCAT.COLUMNS T2 ON T1.COLNAME != T2.COLNAME FETCH FIRST 10000 ROWS ONLY DB2
