I want to ensure every serial number in a table has the same amount after each update to avoid a situation where the same serial number holds different values in different rows .
CREATE TRIGGER myupdate (a,b)
AFTER INSERT ON myTable
FOR EACH ROW
BEGIN
SELECT a=lastInsertedA mount
SELECT b=lastInsertedS erialNumber
END
CREATE PROCEDURE myUpdate(a,b)
BEGIN
UPDATE myTable...