Mysql count one to it

Question

User-1290459327 posted

Hi all,

I have a stored procedure and i want

If user excist update customers automaticly Increase column " Ordernr" with 1.

My procedure is not working, but cannot find out why it is not working,

Can u helps me?

BEGIN
 IF EXISTS (select * from customers where Email = `@Email`) THEN
    update customers set Ordernr = Ordernr + 1 where Email = `@Email`;
  ELSE 
    insert into klanten (Email, Ww, FirstName, LastName, expenses) values (`@Email, @Ww, @FirstName, @LastName, @expenses`);
  END IF;
END

 

Answer 1

User2103319870 posted

My procedure is not working, but cannot find out why it is not working,

You are using single quotes when using paramters, so the value which will pass to query is '@Email' instead of the value in variable.

Try removing the single quotes like below

BEGIN
 IF EXISTS (select * from customers where Email = @Email) THEN
    update customers set Ordernr = Ordernr + 1 where Email = @Email;
  ELSE 
    insert into klanten (Email, Ww, FirstName, LastName, expenses) values (@Email, @Ww, @FirstName, @LastName, @expenses);
  END IF;
END

Answer 2

User-1290459327 posted

Hi a2h,

Thanks for replu but it isn't working, today i found what was wrong, i had to place ( ) in my update

BEGIN
 IF EXISTS (select * from customers where Email = `@Email`) THEN
    update customers set Ordernr = (Ordernr + 1) where (Email = `@Email`);
  ELSE 
    insert into customers (Email, Ww, FirstName, LastName, expenses) values (`@Email, @Ww, @FirstName, @LastName, @expenses`);
  END IF;
END