MySQL stored procedure without parameters

Question

I'm trying to create a procedure but it gives me syntax error. I am not certain of what seems to be the problem

        delimiter $$
        create
        procedure inactivity()
        LANGUAGE SQL
        begin
        [mysql block]
        end $$
        delimiter;

@w5m, this is the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create procedure question_inactivity() begin delete from questions_temp where ' at line 2 — Wabbit
– Wabbit, Commented May 14, 2013 at 18:05
TIP: write each SQL statement properly, end line with ; wherever necessary , inside the [ mysql block ] — xkeshav
– xkeshav, Commented May 15, 2013 at 5:12

Hackerman · Accepted Answer · 2013-05-14 19:14:46Z

4

Try this sql code:

delimiter $$
drop procedure if exists question_inactivity;
create procedure question_inactivity()
begin
delete from questions_temp where active= 1;
update questions set active = 0 where question_id in(select question_id from questions_temp);
drop table questions_temp;
end $$
delimiter;

------------------------------UPDATE------------------------------------

I running this in phpmyadmin and it'works:

delimiter $$

create procedure question_inactivity()
begin
delete from questions_temp where active= 1;
update questions set active = 0 where question_id in(select question_id from questions_temp);
drop table questions_temp;
end 

$$

In the Delimiter input field i put this value: $$

edited May 14, 2013 at 19:14

answered May 14, 2013 at 18:03

Hackerman

12.3k2 gold badges37 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wabbit · Accepted Answer · 2013-05-15 05:07:43Z

4

I figured it out by myself. What was wrong is that there was no space between delimiter and the semicolon.

answered May 15, 2013 at 5:07

Wabbit

1492 gold badges4 silver badges12 bronze badges

Collectives™ on Stack Overflow

MySQL stored procedure without parameters

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related