Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.3.14
-
Fix Version/s: N/A
-
Component/s: Scripts & Clients
-
Labels:
Description
proc
CREATE PROCEDURE remove_emp (employee_id NUMBER) AS tot_emps NUMBER; |
BEGIN |
DELETE FROM employees |
WHERE employees.employee_id = remove_emp.employee_id; |
tot_emps := tot_emps - 1;
|
END; |
/
|
error:
MariaDB [test]> CREATE PROCEDURE remove_emp (employee_id NUMBER) AS tot_emps NUMBER; |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 |