The following content mainly introduces the basic content of MySQL5.0. at the same time, this article also lists the actual application code in MySQL5.0. I hope you will understand the actual content of MySQL5.0 after browsing. The following describes the specific content of this article. CREATEPROCEDURE creates a stored procedure for tables stored in the MySQL5.0 database. C
The following content mainly introduces the basic content of MySQL 5.0. at the same time, this article also lists the actual application code in MySQL 5.0. I hope you will understand the actual content of MySQL 5.0 after browsing. The following is the detailed description of the article. CREATEPROCEDURE creates a stored procedure for tables stored in the MySQL5.0 database. C
The following content mainly introduces the basic content of MySQL 5.0. at the same time, this article also lists the actual application code in MySQL 5.0. I hope you will understand the actual content of MySQL 5.0 after browsing. The following is the detailed description of the article.
- CREATE PROCEDURE
Create a table stored in the MySQL5.0 database.
- CREATE FUNCTION
Create a user-defined function, especially the stored procedure of the returned data.
- ALTER PROCEDURE
Change the pre-specified stored PROCEDURE created with create procedure without affecting the stored PROCEDURE or function ..
- ALTER FUNCTION
Change the pre-specified stored procedure created using the create function without affecting the stored procedure or FUNCTION ..
- DROP PROCEDURE
Delete one or more stored procedures from the MySQL 5.0 table.
- DROP FUNCTION
Delete one or more storage functions from the MySQL table.
- SHOW CREATE PROCEDURE
Returns the text of a pre-specified stored PROCEDURE created using create procedure. This statement is an SQL: 2003 Standard MySQL extension.
- SHOW CREATE FUNCTION
Returns the pre-specified Stored Procedure text created using the create function. This statement is an SQL: 2003 Standard MySQL 5.0 extension.
- SHOW PROCEDURE STATUS
Returns the features of a pre-specified stored procedure, including the name, type, creator, creation date, and change date. This statement is an SQL: 2003 Standard MySQL extension.
- SHOW FUNCTION STATUS
Returns the features of a pre-specified storage function, including name, type, creator, creation date, and change date. This statement is an SQL: 2003 Standard MySQL extension.
- CALL
Call a pre-specified stored PROCEDURE created using create procedure.
- BEGIN ... END
Contains multiple declarations executed by a group.
- DECLARE
It is used to specify local variables, environments, processors, and pointers.
- SET
Used to change the value of local and global server variables.
- SELECT ... INTO
Used to store the column of the DISPLAY variable.
- OPEN
Used to open a pointer.
- FETCH
Use a specific pointer to obtain the next column.
CLOSE
Used to close and open pointers.
IF
An if-then-else-end if statement.
CASE... WHEN
Structure of a case statement
LOOP
A simple loop structure; you can use the LEAVE statement to exit.
LEAVE
Used to exit the IF, CASE, LOOP, REPEAT, and WHILE statements.
ITERATE
Used to re-start the loop.
REPEAT
The test cycle at the end.
WHILE
Testing cycle at the beginning.
RETURNS
Returns the value of a stored procedure.
MySQL5.0 supports stored procedure statements.