Example of trigger on after delete with update query mysql
In this post we will give you information about Example of trigger on after delete with update query mysql. Hear we will give you detail about Example of trigger on after delete with update query mysqlAnd how to use it also give you demo for it if it is necessary.
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:
How can make an array from the values of another array's key?
In this post we will give you information about How can make an array from the values of another array's key?. Hear we will give you detail about How can make an array from the values of another array's key?And how to use it also give you demo for it if it is necessary.
If you are working on PHP or other PHP framework and you want to create array of another array value. now you can see on following example how can you make array form another multidimensional array key's.
For example you have array like:
$multi = array(
['1'] => array('id'=>1,'name'=>'hardik'),
['2'] => array('id'=>1,'name'=>'vimal'),
['3'] => array('id'=>1,'name'=>'harshad'),
)
but if you want to this multi-dimensional array just like this way:
$test = array('hardik','vimal','harshad');
so, we can make this type of array from multi-dimensional array using array_column() funtion.
you can use this function easy as under.
$result = array_column($multi, 'name');
Try this..........
Hope this code and post will helped you for implement How can make an array from the values of another array's key?. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
Example:
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;
END
Hope this code and post will helped you for implement Example of trigger on after delete with update query mysql. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs