Mysql simplifies INSERT and UPDATE through the stored procedure, and mysqlinsert
Processing purpose: Execute UPDATE when the target record exists in the data table. When the target record does not exist in the data table, execute INSERT. This reduces the process of querying the database once.
The storage process is designed as follows:
Create procedure 'Pro _ savedata' (IN 'sinst' varchar (500), IN 'supdt 'varchar (500) BEGIN # directly update the record set @ v_updsql = supdt; prepare stmt from @ v_updsql; EXECUTE stmt; # the record does not exist. Run INSERTIF ROW_COUNT () = 0 THENset @ v_intsql = sinst; prepare stmt from @ v_intsql; EXECUTE stmt; end if; deallocate prepare stmt; END;
C # The call is as follows:
Int r = data. executeNonQuery (System. data. commandType. storedProcedure, @ "CALL pro_SaveData ('insert INTO 'table' VALUES ('1', 'username ')', 'Update table SET name = 'table222 'WHERE id = '1';') ", null );