Tag : Trigger

ItSolutionStuff.com have tutorials for Trigger tag, here you can study articles of Trigger tag, Trigger tag posts collection, most popular and useful tutorials of Trigger tag, here you can find list of all relevant posts and example about Trigger tag, we have lists of tutorials and examples about Trigger tag. very simple and quick example collection of Latest Trigger tag.



Example of trigger on after delete with update query mysql

Sometimes we need to fire trigger like after delete update some fields of another tables. for example if you have chat_message tables and when remove row on this table then we need to update "remove_counter(remove_counter + 1)" on users table. i did give you bellow example you can see how to write trigger code: <strong class="example">Example:</strong> <pre class="prettyprint lang-php"> delimiter // CREATE TRIGGER add_ban_counter_in_users AFTER DELETE ON `chat_messages` FOR EACH ROW BEGIN UPDATE `users` SET remove_counter = users.remove_counter + 1 WHERE users.id = old.user_id.....

By Hardik Savani | April 5, 2016 | | 8443 Viewer | Category : PHP MySql SQL
READ MORE

    Laravel 5 - Generate Captcha code and Validation example using BotDetect package

    Laravel 5 - Generate Captcha code and Validation example using BotDetect package

    Open Post

    Simple Add remove input fields dynamically using jquery with Bootstrap

    Simple Add remove input fields dynamically using jquery with Bootstrap

    Open Post

    How to create quick apache virtual host in Ubuntu?

    How to create quick apache virtual host in Ubuntu?

    Open Post

    Codeigniter 3 - Basic CRUD application with MySQL Example with Demo

    Codeigniter 3 - Basic CRUD application with MySQL Example with Demo

    Open Post

    Laravel 5 - Create Dummy Data using tinker factory

    Laravel 5 - Create Dummy Data using tinker factory

    Open Post

    How to install composer using command line in ubuntu ?

    How to install composer using command line in ubuntu ?

    Open Post