Answer the question
In order to leave comments, you need to log in
Error creating procedure..?
I write the following code:
delimiter//
create procedure spisok_rabot (IN num INT, in date1 DATE, in date2 DATE)
begin
select work_type, count(work_type)
from works where number=num and date_in between date1 and date2
group by work_type;
END
error like this:
ERROR: syntax error (example position: "delimiter")
LINE 1: delimiter //
please help
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question