Breaking News: Grepper is joining You.com. Read the official announcement!

mysql create procedure

Heini van Biljon answered on May 19, 2023 Popularity 10/10 Helpfulness 4/10

answer mysql create procedure

related mysql stored procedure example

mysql create procedure

Comment

-- Basic example [mySQL]

DELIMITER &&
CREATE PROCEDURE Users()
BEGIN
	SELECT * FROM users;
END &&
DELIMITER ;

CALL Users()

-- Example with parameters
DELIMITER &&
CREATE PROCEDURE getUser(inputID int)
BEGIN
	SELECT * FROM users
    WHERE user_ID = inputID;
END &&
DELIMITER ;

CALL getUser(1)

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: mysql procedure sql

Link to this answer
Share Copy Link

Contributed on Sep 27 2023

Heini van Biljon

0 Answers Avg Quality 2/10

Closely Related Answers

mysql stored procedure example

Comment

DELIMITER $$


DELIMITER $$

CREATE PROCEDURE SpGetAllStudents()
BEGIN
	select * from students;
END $$

DELIMITER ;

#CALL SpGetAllStudents(); // calling the sp

#DROP PROCEDURE SpGetAllStudents; // deleting the sp

// call using php
$conn = mysqli_connect("hostname", "user", "password", "db", "port");

//run the store proc
$result = mysqli_query($conn, "CALL SpGetAllStudents");

//loop the result set
$rows = mysqli_fetch_assoc($result);
print_r($rows);

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: call

Link to this answer
Share Copy Link

Contributed on May 19 2023

@CodeGrepperManu

0 Answers Avg Quality 2/10

mysql create procedure

Contents

More Related Answers

mysql create procedure

Closely Related Answers

mysql stored procedure example

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.