Computing.NET Answers Forum Latest Questions

computing
  • 0
  • 0

CREATE DEFINER=`root`@`localhost` PROCEDURE `sample_move`(IN FILEPATH VARCHAR(64)) BEGIN DECLARE VAR1 VARCHAR(200); DECLARE VAR2 VARCHAR(200); DECLARE VAR3 VARCHAR(200); DECLARE VAR4 VARCHAR(200); SET SQL_SAFE_UPDATES=0; INSERT INTO TABLE_ARC (SELECT * FROM TAB1); SET VAR1=(SELECT ROW_COUNT()); SET VAR2=(SELECT CONCAT( NOW() ,’ ‘ ‘ROWS INSERTED => ‘,VAR1)); SELECT SQL_CALC_FOUND_ROWS * FROM TAB1; SET ...