如何解决 MySQL 错误“您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，以了解要使用的正确语法？”

DELIMITER //
   CREATE PROCEDURE yourProcedureName()
   BEGIN
      Statement1,
      .
      .
   N
END;
//
DELIMITER ;

mysql> DELIMITER //
mysql> CREATE PROCEDURE sp_getAllRecords()
-> BEGIN
-> SELECT *FROM employeetable;
-> END;
-> //
Query OK, 0 rows affected (0.二3 sec)
mysql> DELIMITER ;

CALL yourStoredProcedureName();

mysql> CALL sp_getAllRecords();

+------------+--------------+----------------+
| EmployeeId | EmployeeName | EmployeeSalary |
+------------+--------------+----------------+
| 二 | Bob | 1000 |
| 3 | Carol | 两500 |
+------------+--------------+----------------+
两 rows in set (0.00 sec)
Query OK, 0 rows affected (0.0两 sec)