像这样的语句能自动生成吗???
insert into attend select 1, '001 ', '2006-01-01 ', 8.0
union all select 2, '001 ', '2006-01-02 ', 8.0
union all select 3, '001 ', '2006-01-03 ', 8.0
union all select 4, '001 ', '2006-01-04 ', 8.0
union all select 5, '001 ', '2006-01-05 ', 8.0
union all select 6, '001 ', '2006-01-06 ', 8.0
union all select 7, '001 ', '2006-01-07 ', 8.0
union all select 8, '001 ', '2006-01-08 ', 8.0
union all select 9, '001 ', '2006-01-10 ', 10.0
union all select 10, '002 ', '2006-01-01 ', 8.0
union all select 11, '002 ', '2006-01-02 ', 8.0
union all select 12, '002 ', '2006-01-03 ', 8.0
union all select 13, '002 ', '2006-01-04 ', 8.0
union all select 14, '002 ', '2006-01-05 ', 8.0
union all select 15, '002 ', '2006-01-06 ', 8.0
union all select 16, '003 ', '2006-01-01 ', 8.0
union all select 17, '003 ', '2006-01-02 ', 8.0
union all select 18, '003 ', '2006-01-03 ', 8.0
像这样的语句能自动生成吗???
[解决办法]
用powerdesigner可以生成指定行数的测试数据