/*定义日志记录的存储过程*/
CREATE PROCEDURE PRO_LOGTAKNOTES(IN OPERATETYPE VARCHAR(10),IN TABLENAME VARCHAR(20),IN NOTECOMMENTS VARCHAR(256),IN OPERATEPEOPLE VARCHAR(20))
BEGIN
/*根据operateType获得操作类型*/
DECLARE TYPE VARCHAR(10);
DECLARE TBNAME VARCHAR(20);
DECLARE NOTES VARCHAR(256);
DECLARE PEOPLE VARCHAR(20);
@SET TYPE = OPERATETYPE;
@SET TBNAME = TABLENAME;
@SET NOTES = NOTECOMMENTS;
@SET PEOPLE = OPERATEPEOPLE; @SET CREATETM = ;
@SET INSERTSQL = CONCAT('INSERT INTO TT_HOS_LOG_COMMENTS C C.OPERATE_TYPE,C.TABLE_NAME,C.NOTE_COMMENTS,C.OPERATE_PEOPLE,C.CREATE_TM VALUES (?,?,?,?,?)')
PREPARE STMTINSERT FROM @INSERTSQL;
EXECUTE STMTINSERT USING @TYPE,@TBNAME,@NOTES,@PEOPLE,current_timestamp();
DEALLOCATE PREPARE STMTINSERT;
END
CREATE PROCEDURE PRO_LOGTAKNOTES(IN OPERATETYPE VARCHAR(10),IN TABLENAME VARCHAR(20),IN NOTECOMMENTS VARCHAR(256),IN OPERATEPEOPLE VARCHAR(20))
BEGIN
/*根据operateType获得操作类型*/
DECLARE TYPE VARCHAR(10);
DECLARE TBNAME VARCHAR(20);
DECLARE NOTES VARCHAR(256);
DECLARE PEOPLE VARCHAR(20);
@SET TYPE = OPERATETYPE;
@SET TBNAME = TABLENAME;
@SET NOTES = NOTECOMMENTS;
@SET PEOPLE = OPERATEPEOPLE; @SET CREATETM = ;
@SET INSERTSQL = CONCAT('INSERT INTO TT_HOS_LOG_COMMENTS C C.OPERATE_TYPE,C.TABLE_NAME,C.NOTE_COMMENTS,C.OPERATE_PEOPLE,C.CREATE_TM VALUES (?,?,?,?,?)')
PREPARE STMTINSERT FROM @INSERTSQL;
EXECUTE STMTINSERT USING @TYPE,@TBNAME,@NOTES,@PEOPLE,current_timestamp();
DEALLOCATE PREPARE STMTINSERT;
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货