MySQL trigger update syntax error

Question

I wander to set a trigger after update , and if the number of product.Quanity less then 200 , it will be 200. And it's my code , how can i improve it?

The error message said that the error at line 4.

IF  (SELECT product.Quanity<200)
THEN
UPDATE product
SET product.Quanity = 200

Using phpmyadmin - sql

first of all, you need to tell us what database engine you are using — Lamak
– Lamak, Commented Jun 21, 2016 at 21:11
sorry , i 'd updated the question , and my engine is phpmyadmin-sql — Zi-yan Tseng
– Zi-yan Tseng, Commented Jun 21, 2016 at 21:14
that's not a database engine. Are you using MySQL?, SQL Server?, Oracle?, Postgresql? — Lamak
– Lamak, Commented Jun 21, 2016 at 21:15
If you're using PhpMyAdmin to work with your database, then you're working with MySQL - not (Microsoft) SQL Server ..... — marc_s
– marc_s, Commented Jun 21, 2016 at 21:47

Fabio Noth · Accepted Answer · 2016-06-21 21:20:22Z

2

Yo need use where for solve.

UPDATE product
SET product.Quanity = 200
WHERE product.Quanity < 200

:-D

answered Jun 21, 2016 at 21:20

Fabio Noth

857 bronze badges

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

Collectives™ on Stack Overflow

MySQL trigger update syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related