//SQLServer insert data
DECLARE @Myid INT
DECLARE @Myname INT
SET @Myid = 120
SET @Myname = 1000
WHILE (@Myname < 1100)
BEGIN
insert into sys_user values(@Myid,null,@Myname,@Myname,110,'E10ADC3949BA59ABBE56E057F20F883E','','',1,0,0,1,null,null,null);
insert into sys_userrole values(Myid,2);
insert into sys_userrole values(Myid,4);
insert into sys_userrole values(Myid,5);
insert into sys_userdept values(Myid,110);
SET @Myname = @Myname + 1
SET @Myid = @Myid + 1
END
//MySQL insert data
CREATE PROCEDURE p_insert(in callNum int,in callTime varchar(30))
BEGIN
DECLARE Myid INT;
DECLARE c_num int;
DECLARE Myname varchar(10);
select MAX(id) into Myid from callee_list;
SET Myid = Myid + 1;
SET Myname = 2100;
set c_num = 0;
while c_num < callNum do
insert into callee_list values(Myid,concat(concat('sip:',Myname),'@192.168.92.55'),'sip:annc@192.168.92.44:15060;play=waiting_music3.wav',null,'1',null,null,'0','1','2',null,'abc','1','0',null,'2010-09-17 16:15:56','','1','0',null,callTime,'1','2','waiting.wav','1',null,null);
SET Myname = Myname + 1;
SET Myid = Myid + 1;
set c_num =c_num + 1;
END while;
END;
call p_insert(100,'2010-09-21 14:11:00')
update agent_profile set telphone = embed_tel
update dr_gateways set address = replace(address,'5080','5090');
update dr_gateways set pri_prefix = replace(pri_prefix,'as','ucmedia');
select * from callee_list order by begin_time desc
sqlserver:
select * into table_new from table_old where id like 'abc';
oracle:
create table_new as select * from table_old where id like 'abc';