An error occurred while creating the stored procedure using SQL statements in MySQL and DOS: Error 1064 (42000 ):

 

The content of update1. SQL is

Drop procedure if exists pcname;
Create procedure pcname ()
Begin
Select 'a ';

End;

 

Execute the following command in DOS:

C: \ szxys \ metsdatabase \ mysql \ bin> mysql-uUnsername-PPassword Dbname<Update1. SQL

Syntax Error reported

Error 1064 (42000): You have an error in your SQL syntax;Www.kobsky.cn eye-catching world'

Check the manual that corresponds to your MySQL Server version...

Cause:

In dos, the semicolon (;) is used as the end character of the stored procedure, so an error occurs.

Solution: add the delimiter keyword and declare the symbol as the delimiter for the end of the stored procedure. Modify the symbol as follows to execute

 

Drop procedure if exists pcname;

Delimiter $
Create procedure pcname ()
Begin
Select 'a ';
End;

$

Delimiter;