Basic MySQL Stored Procedure Syntax Problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Penstar
    New Member
    • Apr 2007
    • 8

    Basic MySQL Stored Procedure Syntax Problem

    I have a basic Stored proc and keep getting a Syntax error. The SQL works fine, but not in the stored proc.

    CREATE DEFINER=`time`@ `%` PROCEDURE `spAppendTimesh eet`();
    BEGIN
    UPDATE tempam1t SET tempam1t_eventi d=4;
    END

    Can someone please point out where I am wrong?

    Thanks
    Penny
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Please find the details of the syntax here.

    Comment

    • Penstar
      New Member
      • Apr 2007
      • 8

      #3
      Thanks for your help

      Comment

      Working...