M
M
Mikhail Mashkantsev2021-06-13 22:08:37
SQL
Mikhail Mashkantsev, 2021-06-13 22:08:37

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

1 answer(s)
D
d-stream, 2021-06-13
@d-stream

what dialect?
in MS SQL, either "GO" if a pack, or nothing is needed

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question