Problems with defining triggers Post: 302324548

Sponsored Content

Special Forums UNIX and Linux Applications Problems with defining triggers Post 302324548 by figaro on Thursday 11th of June 2009 04:47:35 AM

06-11-2009

Registered User

Problems with defining triggers

I am running the example from the following webpage:
MySQL :: MySQL 5.0 Reference Manual :: 12.1.11 CREATE TRIGGER Syntax
and the problem is that triggers cannot be defined for some reason:

Code:

CREATE DATABASE IF NOT EXISTS triggertest;
USE triggertest;
CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
  a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  b4 INT DEFAULT 0
);

delimiter |

CREATE TRIGGER testref BEFORE INSERT ON test1
  FOR EACH ROW BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END;
|

delimiter ;

and the result is:

Code:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delimiter | CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BE' at line 1

The database is initially empty, no other tables or triggers. What is the exact problem here and how do I fix it? Thanks in advance.

Code:

# mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 164
Server version: 5.1.28-rc FreeBSD port: mysql-server-5.1.28_1

figaro

View Public Profile for figaro

Find all posts by figaro

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Defining Variables

I'm trying to define a variable named sin I already have a variable named cos, which has the value "hello" I want sin to have the value of "hellothere", so sin would be something like sin = $cos & "there" but I'm not sure that I know the syntax. Can anyone help? :confused:

2. AIX

defining a printer in qconfig

I've got a modified samba script (named it winprint) that I can use to print out to a to a shared Win Network printer from an AIX machine. This is a modification of the samba provided smbprint script changed to work under AIX as the backend for a queue. It does not read a config file I can print...

3. Shell Programming and Scripting

defining variables

Hey all, I was wondering if someone would take a look at this script I'm working on. I don't know if i have the syntax correct for my variables and if the for loop is written correctly. any assistance would be greatly appreciated. #!/usr/bin/bash ###########################################...

4. Programming

Defining the inputStream object

Question regarding extend issue What is the reason behind defining the inputStream object in this way... InputStream inputStream = new FileInputStream("c:\\input.txt"); I know that FileInputStream extends InputStream, is there anything else ? I mean we could have define it like ...

5. UNIX for Dummies Questions & Answers

Defining an alias FreeBSD

I have defined this alias as quick way to find out which mount point to use for a USB drive after inserting it: # alias da='dmesg | grep da | grep MB' However, when invoking it, it states the following: # da da: Command not found. Can someone explain what is the issue here and how it can be...

6. UNIX for Dummies Questions & Answers

Help with defining PATH

Hi All, I have a trivial question but I dont know how to solve it. So basically I'm working on a USB key and I have a directory with some scripts which I use to work on files present in other directories within the USB or sometimes on the main harddisk too. The problem is every time I have to...

7. Programming

Problem defining a struct

I have the following code and getting the compilation errors baseLib/DynBaseObj.h:80: error: expected constructor, destructor, or type conversion before �(' token baseLib/DynBaseObj.h:89: error: expected constructor, destructor, or type conversion before �(' token baseLib/DynBaseObj.h:101:...

8. Shell Programming and Scripting

Main script triggers second and it has to run at specific interval

Hi Friends, I am newbie to shell programming and I am stuck trying to accomplish following task.We use Bamboo CI which executes script1 passing parameters. This Main script executes script2 as backend process as part of one of it statements. Task of script2 is to essentially check whether a...

9. UNIX for Dummies Questions & Answers

Defining variable problem

Hi I'd say I'm having this weird problem where my script isn't taking the value off a variable or printing it. My code is like this: set count_C= `grep -c C mols` set count_H= `grep -c H mols` set count_O= `grep -c O mols` sed -i '7,7 s/$/ $count_C $count_O $count_H/g' input It...

LEARN ABOUT SUSE

alter_trigger

ALTER 
TRIGGER(7)						   SQL Commands 						  ALTER TRIGGER(7)

NAME

       ALTER TRIGGER - change the definition of a trigger

SYNOPSIS

       ALTER TRIGGER name ON table RENAME TO newname

DESCRIPTION

       ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
       the trigger definition.

       You must own the table on which the trigger acts to be allowed to change its properties.

PARAMETERS

       name   The name of an existing trigger to alter.

       table  The name of the table on which this trigger acts.

       newname
	      The new name for the trigger.

NOTES

       The ability to temporarily enable or disable a trigger is provided by ALTER TABLE [alter_table(7)], not by  ALTER  TRIGGER,  because  ALTER
       TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.

EXAMPLES

       To rename an existing trigger:

       ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;

COMPATIBILITY

       ALTER TRIGGER is a PostgreSQL extension of the SQL standard.

SEE ALSO

       ALTER TABLE [alter_table(7)]

SQL - Language Statements					    2010-05-14							  ALTER TRIGGER(7)

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Defining Variables

Discussion started by: sailorliones

2. AIX

defining a printer in qconfig

Discussion started by: matheeq

3. Shell Programming and Scripting

defining variables

Discussion started by: em23

4. Programming

Defining the inputStream object

Discussion started by: yahyaaa

5. UNIX for Dummies Questions & Answers

Defining an alias FreeBSD

Discussion started by: figaro

6. UNIX for Dummies Questions & Answers

Help with defining PATH

Discussion started by: pawannoel

7. Programming

Problem defining a struct

Discussion started by: kristinu

8. Shell Programming and Scripting

Main script triggers second and it has to run at specific interval

Discussion started by: aditya206

9. UNIX for Dummies Questions & Answers

Defining variable problem

Discussion started by: saleheen

LEARN ABOUT SUSE

alter_trigger