u010606701的博客

先为表加上唯一键约束ALTER TABLE table_name ADD UNIQUE (column)然后新增操作INSERT INTO man values (id,age,name) value (2,29,name) ON DUPLICATE KEY UPDATE age values(age),name values(name)若该数据的主键值/ UNIQUE KEY 的值已经在表中存在,则执行更新操作, 即UPDATE 后面的操作。UPDATE后的字段为会被更新的字段纯属记录一下。

一级标题DROP PROCEDURE IF EXISTS work_order_num;CREATE PROCEDURE work_order_num( IN proId VARCHAR(255), IN userName VARCHAR(64))BEGINSET @EE='';SET @proId = proId;SET @userName = userName;SELECT b.* into @EE from ( SELECT @EE:=CONCAT(@EE,'SUM(I