Advertisement
Guest User

Untitled

a guest
Oct 24th, 2014
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. CREATE PROCEDURE ADD_COMMIT2 (IN a INT,IN b DATE,IN c INT,IN d,INT(11))
  2. BEGIN
  3. INSERT INTO `Commit` (`programmer`, `date`, `new`,`del`) VALUES (a,b,c,d)
  4. ON DUPLICATE KEY UPDATE `new` = `new` + c,`del`=`del` + d;
  5. END;
  6.  
  7. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement