Using IF ELSE and LOOP inside a mySql event

Question

I've never done this before, but why do I keep getting and error when I try to create this event. I'm using HeidiSql to do this. Also, can LOOPS, WHILE, IF ELSE be used in events?

BEGIN

DECLARE x TIMESTAMP;
DECLARE y INT;
DECLARE a VARCHAR(50); // Here's where the error is.

SET x = current_timestamp();
insert into checked (stamp) values (x);

SELECT count(stamp) INTO y FROM checked;
        IF y > 10 THEN// It also throws an error here.
            a = 'PASS';
            else
            a = 'FAIL';
        END IF;  

insert into checked (timeCount) values (a);

END

@Daniel I'm creating an event. I get /* SQL 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 '= 'PASS'; else a = 'FAIL'; END IF; inser' at line 17 */ — Norman
– Norman, Commented May 9, 2013 at 9:53

Deniyal Tandel · Accepted Answer · 2013-05-09 09:56:06Z

3

Use

SET  a = 'PASS';

instead of

a = 'PASS';

Every where you assign value.

answered May 9, 2013 at 9:56

Deniyal Tandel

6324 silver badges14 bronze badges

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

1 Comment

Norman Over a year ago

Thanks for helping. Like I said I'm doing an even the first time. I was following this: stackoverflow.com/questions/7031469/…

Deniyal Tandel · Accepted Answer · 2013-05-09 09:47:26Z

0

Use "DELIMITER" to execute entire block in mysql

such as.....

DELIMITER

//Your code 

DELIMITER;

answered May 9, 2013 at 9:47

Deniyal Tandel

6324 silver badges14 bronze badges

Collectives™ on Stack Overflow

Using IF ELSE and LOOP inside a mySql event

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related