SQL Trigger - Check for string

Question

Is it possible to run a trigger whenever a new row is inserted into lets say shipping_rate, and it will check column company within that row for a certain string. If that certain string is is there, I then want to perform an equation on column cost to change the current number. Is this feasible in MySQL?

Aida Paul · Accepted Answer · 2013-05-03 08:05:56Z

2

Yes, it is entirely possible as trigger can do essentially anything to the database that a normal query could. You can read up on how to do that in official manual.

answered May 3, 2013 at 8:05

Aida Paul

2,72020 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

SQL Trigger - Check for string

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