Answers for "mysql stored procedure with in and out parameters"

SQL

stored procedure with parameters mysql

-- Stored Procedure with parameters with default

DELIMITER $$

CREATE PROCEDURE get_clients_by_state
(
	state CHAR(2)
)
BEGIN
	IF state IS NULL THEN
    	SET state = 'CA';
    END IF;

	SELECT 
		*
	FROM
		clients c
    WHERE c.state =  state;
END $$

DELIMITER ;


-- Once you save the stored procedure, you can invoke it by using the CALL statement:

CALL get_client_by_state(NULL);

Posted by: Guest on May-21-2021

stored procedure with parameters mysql

-- Stored Procedure with parameters

DELIMITER $$

CREATE PROCEDURE get_clients_by_state
(
	state CHAR(2)
)
BEGIN
	SELECT 
		*
	FROM
		clients c
    WHERE c.state =  state;
END $$

DELIMITER ;


-- Once you save the stored procedure, you can invoke it by using the CALL statement:

CALL get_client_by_state('CA');

Posted by: Guest on May-21-2021

Code answers related to "mysql stored procedure with in and out parameters"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "mysql stored procedure with in and out parameters"

Code answers related to "mysql stored procedure with in and out parameters"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us