MySQL 5.0 new features tutorial Stored Procedure

The following articles mainly describe the first lecture on the stored procedure in the new MySQL 5.0 feature tutorial. MySQL (the best combination with PHP) the main purpose of the 5.0 new feature tutorial is to learn about the latest features of MySQL 5.0 (the best combination of MySQL and PHP) to some extent.

In short, it introduces "stored procedures, triggers, views, and information architecture views"

I hope this book will be able to talk to you like an expert, so that you can learn the required knowledge with simple questions and examples. In order to achieve this purpose, I will gradually establish concepts for everyone from every detail, and finally show you a large practical example, before learning, you may think that this case is very difficult, but as long as you follow the course, I believe you will be able to master it soon.

Conventions and Styles Conventions and programming Styles

Every time I want to demonstrate the actual code, I will adjust the code displayed on the screen of the MySQL (best combination with PHP) client and change the font to Courier, make them look different from common text.

Here is an example: MySQL (the best combination with PHP)> drop function f; Query OK, 0 rows affected (0.00 sec)

If the instance is large, you need to add comments between some rows and paragraphs. At the same time, I will place the '<--' symbol on the right side of the page to emphasize.

For example:

 
 

  
  
MySQL (best combination with PHP)> create procedure p ()
  
  
-> BEGIN
  
  
->/* This procedure does nothing */<--
  
  
-> END; // Query OK, 0 rows affected (0.00 sec)
 
 

Sometimes I will remove the "MySQL (the best combination with PHP)>" and "->" system display in the example, you can directly copy the code to the MySQL (the best combination with PHP) client program. If you are not reading an electronic version, you can use MySQL (the best combination with PHP ). so the examples have been tested on Suse 9.2 Linux and MySQL (the best combination with PHP) 5.0.3 public edition.

When you read this book, MySQL5.0 (the best combination with PHP) already has a higher version and supports more operating systems, including Windows, Linux, and HP-UX. So the example here will run normally on your computer. However, if the operation still fails, you can consult your senior MySQL (the best combination with PHP) users for long-term support and help.