mysql通过存储过程简化INSERT和UPDATE_MySQL

存储过程设计如下：

CREATE PROCEDURE `pro_SaveData`(IN `sinst` varchar(500),IN `supdt` varchar(500))
BEGIN
	#直接更新记录
     set @v_updsql=supdt;   
     prepare stmt from @v_updsql;  
     EXECUTE stmt;      
     
	#记录不存在，执行INSERT
	IF ROW_COUNT() =0 THEN
			set @v_intsql=sinst;
     prepare stmt from @v_intsql; 
     EXECUTE stmt;      
	END IF;
deallocate prepare stmt;    
END;

C#调用如下：

int r = data.ExecuteNonQuery(System.Data.CommandType.StoredProcedure,
                @"CALL pro_SaveData (&＃39; INSERT INTO `table` VALUES (&＃39;1&＃39;, &＃39;username&＃39;)&＃39;,
                &＃39;UPDATE table SET name=&＃39;table222&＃39; WHERE id=&＃39;1&＃39;;&＃39;)", null);