Getting started with stored procedures

 - Select Customer Name 

Masukan Kode : 

SELECT 

    customerName, 

    city, 

    state, 

    postalCode, 

    country

FROM

    customers

ORDER BY customerName;

Hasil output nya:

Created GetCustomers

Masukan kode :

DELIMITER $$

CREATE PROCEDURE GetCustomers()

BEGIN

SELECT 

customerName, 

city, 

state, 

postalCode, 

country

FROM

customers

ORDER BY customerName;    

END$$

DELIMITER ;

Hasil Output nya: