您好,欢迎访问一九零五行业门户网

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 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
其它类似信息

推荐信息