I\'m trying to write a trigger in MySQL and I need to set the values of several variables.The values I need to put into these variables are from a row in an existing table (not worried about multiple
I have a temp table (question_desc, ans1, ans2, ans3, ans4, correct_ans, marks) with say 10 entries. From this table I have to insert values in two other tables:
is it possible t开发者_如何学JAVAo get table name in a MySQL trigger ? i use trigger to log insert actions on some tables in MySQl and i need the name of the table where the trigger is placed at.
I have 2 tables: survey (id(PK), name) and survey_to_topic (survey_id(PK,FK,not null), topic_id(PK,FK,not null)). When I try to delete from survey table, I get exception:
In SQL Server 2008, I ha开发者_开发问答ve my parent table in one database, and the child table in another database, with FK relationship maintained by triggers. I cannot change it, cannot move both ta
I have a \'People\' table with several attributes including \'age\'. Each time I insert a new tuple into this table, I would like to find out the average age of all the people listed in the table. If
I have a table on a SQL Server 2000 database, which I want copied verbatim to a 2008 server. I tried to do it manually with 开发者_Go百科INSERT/UPDATE triggers, but this technique runs in a distribut
I want to create trigger which will be fired after insert into some table, let`s say user. In this trigger I want to select some records from t开发者_运维知识库able user, besides this one I insert to
I have a problem with compiling an Oracle trigger via SQL*PLUS - I don\'t think I\'m being dumb but I can\'t see what the problem is.
I am working with SQL Server 2005 and I have trigger on a table that will copy an deletions into another table. I cannot remove this trigger completely. My problem is that we have now developed an arc
加载中,请稍侯......