当大家做新项目时,如果需要使用数据库里的数据,恰好此时数据库里有没有测试数据,那怎么办呢?
相对于手动一个一个插入,有一个好办法,可以相对而言比较省事地向数据库插入测试数据,那就是递归SQL: P
下面是用到的SQL语句:
with tempTestData(Tlogin_name,Taddress,Tphone,Temail,Treal_name,Tcountry,TcityId,Tpassword,Trole) as
(
select [login_name],[address],[phone],[email],[real_name],[country],[cityId],[password],[role]
from [dbo].[per_users] where uid = '12'
union all
select Tlogin_name,Taddress,Tphone = 1 + Tphone,Temail,Treal_name,Tcountry,TcityId = 1 + TcityId,Tpassword,Trole
from tempTestData
where Tphone < 101
)
insert into [dbo].[per_users] ([login_name],[address],[phone],[email],[real_name],[country],[cityId],[password],[role])
select * from tempTes