Shulou(Shulou.com)05/31 Report--

This article mainly explains "the process of storing data in mysql database". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the process of storing data in mysql database".

The stored procedure is as follows:

Java code

Create procedure proc_name (in parameter integer)

BEGIN

Declare variable varchar (20)

If parameter=1 THEN

Set variable='mysql'

ELSE

Set variable='java'

End if

Insert into tb (name) values (variable)

End

Test statement:

Call proc_name (3)

Java code

Create procedure abin (in parameter int)

BEGIN

If parameter=1 THEN

Select * from tb order by id asc

ELSE

Select * from test order by id asc

End if

End

Test statement:

Call abin (2)

Java code

Create procedure abin_1 (in parameter int)

BEGIN

Declare variable varchar (20)

If parameter=1 THEN

Set variable=''

ELSE

Set variable='linux'

End if

Select parameter

End

Test statement:

Call abin_1 (1)

Call abin_1 (2)

Java code

Create procedure bing ()

BEGIN

DECLARE temp int

Set temp='java'

Update tb set name='abin' where id=1

End

Thank you for your reading, the above is the content of "the process of storing data in mysql database". After the study of this article, I believe you have a deeper understanding of the process of storing data in mysql database, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.