返回顶部

收藏

DB2批量插入测试数据

更多
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

标签:sql

收藏

0人收藏

支持

0

反对

0