MySQL 5.0 Stored Procedure learning notes

At the beginning of this day, I learned the MySQL storage process. I just downloaded the new technical White Paper of MySQL 5.0 and carefully studied and practiced it. My personal summary is as follows:

1. When creating a stored procedure on the MySQL Command terminal:

Create procedure p1 () <-- note that there are spaces between PROCEDURE and p1, p1 and (). Otherwise, an error is returned !! See figure 1.

SELECT * FROM test;

Figure 1:

After you pay attention to the above issues, run this stored procedure function:

CALL p1 (); <--- pay attention to the space issue here !!

The result is as follows:

In the past, due to the differences in terminals, the space issue had been entangled for a long time. Today we finally solved it!

1 2 3 Next Page