Home Tutorialhelp Comment General Trigger form?

 
 

Comment

Jim
General Trigger form?,
June 17, 2010 at 10:53 PM

You said,
/begin/
The general syntax of CREATE TRIGGER is :
CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_statement
/end/

But is this really true? Is it really true that a trigger can ONLY be created that will always loop thru ALL the rows in the table?

I find that hard to believe.

I don't know but my own expertise leads me to doubt this is true. I in fact am searching for how to update another table with selected data from the trigger table when an update to the trigger table happens.


View All Comments
Advertisement
Related Tutorial and Articles
MySQL

TRIGGERS
 

SQL Question

Types of Triggers
 

General

Trigger
 

SQL Question

throw exception in mysql trigger
 

JSP Servlet Questions

Triggers - JSP-Servlet
 

Java Beginners

Cron Expression for Cron Triggers
 

Java-Tutorials

More About Triggers
 

MySQL

Mysql Time Trigger
 

SQL Tutorial

Mysql Time Trigger
 

SQL Question

Stored Procedure and Trigger
 

SQL Tutorial

Mysql Trigger After Insert
 

SQL Tutorial

Mysql Trigger After Delete
 

MySQL

MySQL After Trigger
 

SQL Question

using trigger - SQL
 

SQL Tutorial

Mysql Trigger after Update
 

SQL Question

trigger
 

SQL Question

trigger
 

SQL Question

trigger
 

Java-Tutorials

Implementing more than one Job Details and Triggers
 

SQL Question

MYSQL
 

Java-Tutorials

Jobs & Triggers
 

Struts Questions

general
 

Java Beginners

general
 

Design concepts & design patterns Questions

general
 

SQL Question

trigger
 

SQL Question

how to update specific row in on update key in the Navicat for mysql trigger
 

Java-Tutorials

More About Simple Trigger
 

SQL Question

What is Trigger?
 

SQL Question

What are the types of triggers?
 

General

Welcome to the MySQL Tutorials
 

Java Beginners

JMF: How trigger event when player reaches certain time playing a video?
 

SQL Question

What is Trigger?
 

MySQL

MySQL Download
 

Java-Tutorials

JobStores
 

MySQL

MySQL 5.0 Release - Download MySQL 5.0
 

Java Beginners

Programming (general)
 

SQL Question

MySQL - SQL
 

MySQL

MySQL Client
 

MySQL

MySQL Client
 

Security Questions

General - Security
 

Hibernate Questions

General - Hibernate
 

MySQL

MySQL
 

MySQL

MySQL Training ? Online Free MySQL Training
 

HTML Questions

general layout HTML documents
 

SQL Question

trigger after insert for deletion
 

Java-Tutorials

Create Delete Trigger in SQL
 

SQL Question

general syntax for a SELECT statements
 

XML Questions

Quartz Trigger - XML
 

SQL Question

Writing a trigger for an userdefined datatype
 

SQL Tutorial

Create Delete Trigger in SQL
 

Java Beginners

General Question - Java Beginners
 

WebSevices Questions

a trigger to call .bat file oracle
 

Programming Tutorials

TIBCO General Interface
 

Java-Tutorials

Create After Update Trigger in SQL
 

SQL Question

How to trap Trigger Error - SQL
 

IDE Questions

General Interview Question - IDE Questions
 

Java Interview Questions

heap and stack in general programming language
 

Java-Tutorials

Example of Cron Trigger
 

Programming Tutorials

Java as a general purpose language
 

Programming Tutorials

jQuery callback trigger
 

Java Beginners

Quartz trigger dropping automatically - Java Beginners
 

MySQL

What is MySQL
 

General Information

General information on different topics
 

Programming Tutorials

Create After Insert Trigger in SQL
 

Programming Tutorials

Create Before Insert Trigger in SQL
 

MySQL

MySQL Commands
 

PHP Tutorial

PHP Trigger Error
 

SQL Question

Need help on mySQL 5 - SQL
 

SQL Tutorial

Create Before Insert Trigger in SQL
 

Programming Tutorials

Create Before Update Trigger in SQL
 

MySQL

MySQL Front
 

Hibernate Questions

What is the general flow of Hibernate communication with RDBMS?
 

SQL Question

Assigning variable in mysql - SQL
 

Design concepts & design patterns Questions

general - Design concepts & design patterns
 

SQL Tutorial

Create Before Update Trigger in SQL
 

Programming Tutorials

MySQL How to Topic
 

SQL Tutorial

Create After Update Trigger in SQL
 

Java Tips and Examples

Java as a general purpose language
 

SQL Tutorial

Create After Insert Trigger in SQL
 

SQL Question

mysql
 

SQL Question

MySql
 

SQL Question

can i use trigger to insert data within a time period ?
 

SQL Question

mysql
 

General

Java as a general purpose language
 

SQL Question

Create a counter in mySQL 5 database through Java - SQL
 

PHP Questions

mysql
 

MySQL

MySQL Administrator
 

MySQL

MySQL Cursor
 

MySQL

MySQL Creating and Deleting Database
 

SQL Question

MySQL
 

Date Calendar

mysql
 

Java-Tutorials

Establish a Connection with MySQL Database
 

Java Beginners

how to browse the general files which are in system using java? - Java Beginners
 

Java-Tutorials

Quartz Tutorial
 

General

Ask MySQL Questions online
 

Java Beginners

Creating an Encyclopedia using Java & mySQL 5 - Java Beginners
 

MySQL

MySQL Manual
 

General

Show General Path
 

SQL Question

Sql Server - SQL
 

MySQL

MySQL Examples, Learn MySQL with examples.
 

Advertisements Advertisements
 

 

 

DMCA.com