Ok, so what I found is that you can make UDF functions in mysql that can do anything but need to be written in C/C++. They can be then called from triggers on updates in database and notify your application when update happened. I saw that there are some security concerns. I did not use … Read more
CREATE TRIGGER sampleTrigger ON database1.dbo.table1 FOR DELETE AS DELETE FROM database2.dbo.table2 WHERE bar = 4 AND ID IN(SELECT deleted.id FROM deleted) GO
The [name] field in sys.objects will contain only the actual name (i.e. trg), not including the schema (i.e. dbo in this case) or any text qualifiers (i.e. [ and ] in this case). AND, you don’t specify the table name for DROP TRIGGER since the trigger is an object by itself (unlike indexes). So you … Read more
OLD and NEW are null or not defined in a statement-level trigger. Per documentation: NEW Data type RECORD; variable holding the new database row for INSERT/UPDATE operations in row-level triggers. This variable is null in statement-level triggers and for DELETE operations. OLD Data type RECORD; variable holding the old database row for UPDATE/DELETE operations in … Read more
This will return all the details you want to know select * from information_schema.triggers; or if you want to sort the results of a specific table then you can try SELECT event_object_table ,trigger_name ,event_manipulation ,action_statement ,action_timing FROM information_schema.triggers WHERE event_object_table=”tableName” — Your table name comes here ORDER BY event_object_table ,event_manipulation; the following will return table … Read more
mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control this behavior: –routines – FALSE by default –triggers – TRUE by default so in mysqldump command , add –routines like : mysqldump <other mysqldump options> –routines > outputfile.sql See the MySQL documentation about mysqldump arguments.
The command for listing all triggers is: show triggers; or you can access the INFORMATION_SCHEMA table directly by: select trigger_schema, trigger_name, action_statement from information_schema.triggers You can do this from version 5.0.10 onwards. More information about the TRIGGERS table is here.
\df+ in psql gives you the sourcecode.
You can use a data trigger and set the binding RelativeSource to Self. Data Triggers allow binding and bindings lets you have converters. Example: <Button Content=”I change colour depending on my width for some reason”> <Button.Triggers> <DataTrigger Binding=”{Binding Path=Width, RelativeSource={RelativeSource Self}, Converter={StaticResource isLessThanConverter}, ConverterParameter=50}” Value=”True”> <Setter Property=”Button.Background” Value=”Red” /> <DataTrigger> <Button.Triggers> <Button> Reference
From http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html Cascaded foreign key actions do not activate triggers In other words, you cannot use the trigger with cascaded deleting. Also see related bugs: MySQL: https://bugs.mysql.com/bug.php?id=11472 MariaDB: https://jira.mariadb.org/browse/MDEV-19402