Tag : Old

ItSolutionStuff.com have tutorials for Old tag, here you can study articles of Old tag, Old tag posts collection, most popular and useful tutorials of Old tag, here you can find list of all relevant posts and example about Old tag, we have lists of tutorials and examples about Old tag. very simple and quick example collection of Latest Old 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 | | 3946 Viewer | Category : PHP MySql SQL
READ MORE

    Multi select autocomplete jquery example with code

    Multi select autocomplete jquery example with code

    Open Post

    Laravel - Dynamically Add or Remove input fields using JQuery

    Laravel - Dynamically Add or Remove input fields using JQuery

    Open Post

    AngularJS - convert comma separated string to array example

    AngularJS - convert comma separated string to array example

    Open Post

    Laravel 5.5 Simple CMS Website example using asgardcms

    Laravel 5.5 Simple CMS Website example using asgardcms

    Open Post

    Codeigniter 3 Datatables Ajax Example From Scratch

    Codeigniter 3 Datatables Ajax Example From Scratch

    Open Post

    How to make simple dependent dropdown using jquery ajax in Laravel 5?

    How to make simple dependent dropdown using jquery ajax in Laravel 5?

    Open Post