mysql

create PROCEDURE copy_runtable_to_history_by_id(in RunTableId int)
BEGIN
set @TestTime = NOW();
INSERT INTO HistoryData(Id,BranchId,DownloadUrlBootId,DownloadUrl,Version,CreateTime,TestTime,ProductId,PinyinDataId) 
select Id,BranchId,DownloadUrlBootId,DownloadUrl,Version,CreateTime,@TestTime,ProductId,PinyinDataId from RunTable 
where Id = RunTableId;
END






create PROCEDURE copy_top_runtable_to_history(
in Id int,
in BranchId int,
in DownloadUrlBootId int,
in DownloadUrl varchar(255),
in Version varchar(25),
in CreateTime datetime,
in ProductId int,
in PinyinDataId int)
BEGIN
#set @ProductId = concat('select Product.Id from Product where Product.`Name` = \'',ProductName,'\'');    
#set @PinyinDataId = concat('select PinyinData.Id from PinyinData where PinyinData.`Name` = \'',PinyinDataName,'\'');
set @TestTime = NOW();
INSERT INTO HistoryData(Id,BranchId,DownloadUrlBootId,DownloadUrl,Version,CreateTime,TestTime,ProductId,PinyinDataId) 
VALUES (Id, BranchId, DownloadUrlBootId, DownloadUrl,Version,CreateTime,@TestTime,ProductId,PinyinDataId);
END








create procedure get_top_runtable()
BEGIN
select Id,BranchId,DownloadUrlBootId,DownloadUrl,Version,CreateTime from RunTable ORDER BY CreateTime desc LIMIT 0,1;
END


BEGIN
#Routine body goes here...
select RunTable.Id,BranchId,DownloadUrlBootId,DownloadUrl,Version,CreateTime,Product.ProductName,PinyinData.`Name` from RunTable
join Product on Product.Id = RunTable.ProductId join PinyinData on PinyinData.Id = RunTable.PinyinDataId
ORDER BY CreateTime desc LIMIT 0,1;
END