Jump to content

Yurko

Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

 Content Type 

Posts posted by Yurko

    Stored Procedure

    in SQL

    Posted

    It doesn't work for MySQL Workbench:

    CREATE PROCEDURE SelectAllCustomersAS
    SELECT * FROM Customers
    GO;
    EXEC SelectAllCustomers;

    But it is working:

    DELIMITER //

    CREATE PROCEDURE SelectCategory()
    BEGIN
        SELEC    T * FROM category;
    END //

    CALL SelectCategory();    

     

×
×
  • Create New...