Procedural code automatically executed in response to a database event.
0
votes
2answers
29 views
Create a trigger to update table data on another Server's database
I am creating a trigger in MySQL and I need a little help.
I have 2 websites, 2 databases (same name) on 2 different web servers, S1 & S2.
These databases have the same tables names.
I want ...
3
votes
1answer
45 views
Subquery returned more than 1 value
In my database I have two tables: projects and comp_types. When a new project is created a trigger is hit which inserts a concatenated value in a column in the projects table.
A fully working SQL ...
1
vote
1answer
44 views
BEFORE INSERT trigger in MySQL
I am new to MySQL and I'm having problems creating a BEFORE INSERT trigger.
I get an unexpected END error.
I have a table named verlof_aanvragen with a column datum (and 6 more columns).
What I ...
2
votes
1answer
28 views
Are there tips for writing Oracle DDL Triggers for auditing? Or should I just use AUDIT?
I've been tinkering with writing a trigger to log my table creation and manipulation for later tracking and review.
The challenge is that my trigger logic is stored in the same schema on which I've ...
0
votes
1answer
41 views
Stored procedure not working
I am creating a procedure in a new database. There is no trigger on any table and no procedures exist. I am getting this error:
ERROR 1303 (2F003): Can't create a PROCEDURE from within another ...
0
votes
1answer
26 views
updation of a column after expire of specific time in mysql
i have a table where i have a column named 'state'(int(2)) and 'modify_time' (time_stamp on update current timestamp).
i have an update trigger which changes the value of state column to 0 based on ...
1
vote
1answer
26 views
Trigger not Working
I created trigger on table PENDING.
Pending table has 3 columns
uniqueId
duration
maxDuration
I have another table COUNT with 2 columns
req_id
total
Here is my trigger--
CREATE TRIGGER ...
1
vote
1answer
36 views
Postgresql - how to drop a trigger [closed]
A while ago I've created a trigger in Postgresql, update_user, which sets the update_date to now() for table users. Now I want to drop this trigger.
The following queries don't work:
drop trigger ...
1
vote
2answers
53 views
Federated tables and triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fectch" rows from another table (T1) on ...
-1
votes
1answer
31 views
checking a folder whether required file is present at a regular interval [closed]
i have 4 folder hierarchy in a following format :
Hourly Daily Weekly Monthly.
In every folder i have files which is coming in a frequency based on their folder's name.
Now , i have ...
0
votes
1answer
112 views
Synchronise data from one table to another & vice-versa using triggers
We are migrating from one database structure to another - very slowly. The system is MySQL. There are two databases. For example's sake, we will call the databases old_db and new_db. Both databases ...
0
votes
2answers
66 views
MySQL Replication and Triggers
I have stumbled upon an interesting MySQL Error message that I do not really know how to interpret.
The setup:
There are two tables A and B.
When data is written or updated in the table A, then a ...
2
votes
1answer
44 views
Testing AFTER INSERT Trigger
I have the following table:
CREATE TABLE Train(
Train_No integer PRIMARY KEY,
Loco_No integer REFERENCES Locomotive(Loco_No),
Back_Loco_No float REFERENCES Locomotive(Loco_No),
...
0
votes
1answer
48 views
Postgres - Schema information within Trigger?
Background : (Multi-tenant design;separate schema per customer, all table structures identical;Data-warehouse / non-OLTP system here; Postgres 9.2.x).
Reviewing patterns for the following problem: I ...
1
vote
1answer
53 views
Trigger not firing when deleting a record from stored procedure MySql
Bare with me, as I'm fairly new to stored procedures / triggers.
I have the following Stored Procedure:
DELIMITER $$
CREATE DEFINER=`username`@`serveraddress` PROCEDURE `TASK_APPROVE`(IN idtask ...
0
votes
1answer
53 views
Disabled trigger still fired
I've just run the following t-sql to disable a trigger (with a deploy script wrapper around osql):
disable trigger dbo.trExampleTableInsert ON dbo.ExampleTable
In SSMS I could see the trigger was ...
2
votes
1answer
59 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses, and after posting on superuser, was directed over here.
On SQL Server 2005, we currently log certain table changes via triggers using ...
1
vote
1answer
66 views
How can we get table name from inside trigger?
I need to pass the table name from trigger to procedure.
ALTER TRIGGER [dbo].[Trg_ProjectCreation]
ON [dbo].[Projects]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
-- procedure call
...
1
vote
0answers
39 views
Why Oracle Database trigger can became DISABLED
We have an application, using ddl database trigger on oracle database.
Trigger depends on package and several tables, package depends on user defined function.
It works on different customer sites ...
0
votes
0answers
33 views
Fast afterUpdate cross-database trigger blocks insert
I'm trying to fix a timeout issue in an existing application.
There is a trigger on after_update that cascades a value from the update from master.Client to internal.Client and external.Client
The ...
1
vote
1answer
84 views
Is it possible for a trigger to update a row in a table using a value that was deleted?
I have a trigger which is updating a column in a different table after the row is inserted:
mysql>delimiter $$
mysql> create trigger status
after insert on table2
FOR EACH ROW
BEGIN ...
0
votes
0answers
95 views
Resolving a “Multiple triggers with the same action” error [closed]
What's wrong with my trigger? I'm getting this error:
1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
whats causing this ...
0
votes
1answer
53 views
How can I modify this trigger with loops and concat?
I have this trigger below which inserts new values in the an emplog table. I want to have my trigger insert in the description column the event that took place. For example, if I changed the last_name ...
0
votes
1answer
42 views
Is there a workaround for lack of support of cascade triggers with MySQL?
As things stand, cascaded foreign key actions do not activate triggers with MySQL. I don't want to get into the debate as to whether or not this is good, I just would like to know whether there is a ...
1
vote
1answer
71 views
What would cause extra records to be inserted during a INSERT trigger
The following trigger that joins Inserted table on itself creates multiple unwanted records:
CREATE TRIGGER [dbo].[trFooInsert] on [dbo].[Foo]
AFTER INSERT
AS
BEGIN
IF EXISTS(SELECT 1 FROM ...
0
votes
1answer
237 views
Execution of a java program by a trigger
Can an update trigger execute a java program?
I have a table T1 with a column named Flag. Whenever Flag changes, I want to run a trigger that results in an execution of a java program.
0
votes
2answers
115 views
Should I disable triggers, timestamps in a slave in mysql?
We're using MySQL. We have a master that eventually will have 2 slaves. There are triggers in the db that execute when data changes in certain tables. I am wondering whether to disable the triggers in ...
1
vote
1answer
28 views
Determine if existing Trigger acts on field DB2
I am eventually going to be writing a trigger on a field named "user2". Currently most of the values in this field are blank, but there are some seemingly random rows with values of '00' for the ...
0
votes
1answer
80 views
What happens to a Trigger if a table is dropped and rename and recreated with same name
What happens to a Trigger if a table is dropped and rename and recreated with same name?
For e.g:
We have a Trigger X which is define for Table A.
We have a Trigger Y which is define for Table B.
...
0
votes
2answers
189 views
mysql trigger on update with insert statement
I am trying to create a simple trigger which is handled on update operations. The trigger is checking before update if a record of an update exists, then if not it is created.
DELIMITER ;;
CREATE ...
0
votes
2answers
80 views
PLSQL: BEFORE INSERT Trigger
I am attempting to write my first trigger statement. I am trying to create a trigger that performs a SELECT to get my MAX_TOW_WEIGHT for a LOCO_CLASS, then compare that weight to the TRAIN_WEIGHT. If ...
1
vote
2answers
220 views
SQL Server 2012, restore database
I am using MS SQL Management Studio 2012 to restore the database from a .bak file. (That file is from the backup of the database on server)
In my new database, the triggers are missing. Why did I ...
0
votes
1answer
133 views
Two insert statements inside trigger - Duplicate entry '521-2' for key 'PRIMARY'
I'm trying to create an insert trigger so that when a new user is inserted into users table (via site, httpd and php), part of this information is inserted in another table that manages access to a ...
2
votes
1answer
196 views
MariaDB, Triggers and last_insert_id
I have a situation where I have three tables: sample, sample_name and run (extra columns removed to be only relevant information).
CREATE TABLE `sample` (
`sample_id` int unsigned NOT NULL ...
2
votes
2answers
101 views
Is there a way that I can export a list of all table triggers on a server?
I have two SQL Server instances that I manage. One is a SQL Server 2000 instance, and the other is 2005.
Some where, on these servers, I recall setting up a couple table triggers that were executed ...
0
votes
0answers
117 views
error in creating trigger in phpmyadmin
I have 4 tables:
event:
event_id(p.k) | uid | circle_id(f.k)
activity:
uid | performed_activity_id(f.k->event_id) | activity_type_id
follow:
follower_id | circle_id(f.k)
noiticication:
...
2
votes
4answers
333 views
A database trigger is an alternative for?
I had the following quiz question and could not answer it myself because of a little confusion.
Please answer this and tell me why?
A database trigger is an alternative for?
A. Stored ...
0
votes
0answers
88 views
mysql alternative to prepared statements in triggers
I'm trying to get some stored procedures to fire from a MySQL 5.1 trigger. When these were called without triggers, I used prepare and execute statements to build queries and other SQL calls. I have a ...
0
votes
0answers
36 views
Duplicate entry '0' for key 'UQ_CallsIDCC'
I have my own Server with Voice Switch and not really familiar with SQL.
Having problem with following:
02-25 12:05:32 MySQL error description : Duplicate entry '0' for key 'UQ_CallsIDCC'
02-25 ...
3
votes
1answer
250 views
Trigger in combination with transaction
Suppose we have the following situation:
We have a table (let's say Table_A), wich has a trigger on INSERT. The trigger job is to update some rows in table_B based on the inserted values in table_A.
...
0
votes
0answers
108 views
FOR UPDATEor INSTEAD OF UPDATE Trigger?
I am working on my project at university - database in MS SQL Server for some sort of travel agency.
I would like to create a trigger to check if I can add another reservation for specific Holiday ...
1
vote
1answer
71 views
DB2 9.7 - Find rows inserted by a specific trigger
We are auditing a table TRANSACTIONS that inserts a row in HISTORY_TRANSACTIONS when specific columns are changed. These inserts happen through a number of triggers defined on TRANSACTIONS table. Is ...
0
votes
0answers
252 views
MS Access trigger
I got a trigger to update a table in SQL.
My actual need is in MS Access but I could not make it. So please help me to write the same trigger in MS Access.
Query is as follows:
Create trigger ...
2
votes
1answer
109 views
Which is more efficient, trigger or PHP code?
My requirement is to move EMR data for a patient to a set of history tables when the patient has been discharged. I proposed to use an after trigger on the table housing the discharge flag, checking ...
0
votes
1answer
219 views
one trigger for multiple tables
i have a trigger in PostgreSql 9.1 that i want to fire on inserts of several tables. is it possible to have it affect all these tables instead of creating the trigger for all these tables?
i have 58 ...
-1
votes
1answer
101 views
Is it possible to create a trigger on a table synonym in SQL Server? [closed]
The title says (asks) it all. Is it possible to create a trigger on a table synonym in SQL Server (2005 or higher)?
2
votes
2answers
991 views
how to add trigger in mysql workbench, without UDF, using EER design
I have designed a simple database using EER in workbench. However, i want to have a minimum value for the attribute salary (compared with min_value attribute from artist table). Here is the schema:
...
1
vote
2answers
345 views
Multiple triggers vs a single trigger [closed]
Scenario:
Each time data is inserted/updated/deleted into/in/from a table, multiple unrelated items of business logic need to be executed.
Question
Given that the solution is to use database ...
2
votes
2answers
323 views
Securely Send Database Mail via an Insert Trigger
I have spent about 30 hours so far trying to get sp_send_dbmail to work. I finally got SOMETHING to work, but I have serious doubts as to its security. I would like know a method which is better yet ...
1
vote
1answer
258 views
How can I ensure that in a insert trigger a column gets filled before other column?
The bigger picture:
tableX represents pipelines and tableY streets. A pipeline crosses/goes along many streets, and I want to know which street is crossed the most. First, I am segmentizing each ...
