(ZZ) phpMyAdmin setting mysql stored procedure and related issues

(ZZ) How does phpMyAdmin set the mysql stored procedure and its problems ??? The database needs to be used in the past few days. MySQL is used, and phpMyAdmin is used in the database management software. To create a stored procedure, you need to execute an SQL statement. The statement is as follows. An error is returned, the error message is as follows: "#1064

(ZZ) How does phpMyAdmin set the mysql stored procedure? ? ? The database needs to be used in the past few days. MySQL is used, and phpMyAdmin is used in the database management software. To create a stored procedure, you need to execute an SQL statement. The statement is as follows. An error is returned, the error message is as follows: "#1064-You have an error in your SQL syntax;

(ZZ) phpMyAdmin setting mysql stored procedure and Problems

? ? ? The database needs to be used in the past few days. MySQL is used, and phpMyAdmin is used in the database management software. To create a stored procedure, you need to execute an SQL statement. The statement is as follows. An error is returned, the following error is reported:

"#1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near'' at line 3"

After going online, I found that it was a classic error. Now the record is as follows, so that I will not encounter it again later:

?

Solution:

? ? ? ? First, make sure it is not an SQL statement problem. If it is a statement problem, you have to modify it yourself. If the statement is correct, you can correct it as follows:

? ? ? ? 1. I heard that the command line can be normally executed by inputting the correct SQL statement, and an error occurs in phpMyAdmin. I did not try this method. If you are interested, you can verify the following;

? ? ? ? 2. When you enter an SQL statement, the default Separator of phpMyAdmin is ";" (semicolon), instead of "//" (double slash ).

For example, an error is reported:

As shown in the following figure:

? ? ? ? The main problem here is embodied in the separator, which won't be encountered during command line input. This explains why method 1 is also feasible. Well, for personal guesses, please leave a message to anyone you know.

?

? ? ? ? There are also related posts on the well-known StackOverFlow website. If you are interested, you can follow these steps:

#1064-You have an error in your SQL syntax

?

View stored procedures

? ? ? ? To view the created stored procedure in phpMyAdmin, run the following statement to view the created stored procedure:

Show procedure status;

The result after I run the command is as follows:

Reprinted from http://blog.csdn.net/chenlong12580/article/details/7514960

?

?

?

?

?