How do I create a stored procedure in mysql?



How do I create a stored procedure in mysql?..

Answer / Ankit Sachan

To create a stored procedure in MySQL, you can use the CREATE PROCEDURE command. Here's an example:

```sql
DELIMITER //
CREATE PROCEDURE <procedure_name>()
BEGIN
-- Your SQL code here
END; //

DELIMITER ;
```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is mysql a odbc?

1 Answers  


What is database url for mysql?

1 Answers  


What is strict mode in mysql?

1 Answers  


What is root password?

1 Answers  


What is blob and text in mysql?

1 Answers  


Is there an object-oriented version of MySQL library functions?

1 Answers  


What is the current mysql version?

0 Answers  


What are the ways in which you can retrieve data in the result set of mysql using php?

1 Answers  


What are the differences between char and nchar?

1 Answers  


What is the datatype of image in mysql?

1 Answers  


Can mysql handle big data?

1 Answers  


How to delete the repeated records from a table?

1 Answers  


Categories