List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:January 10 2002 3:29pm
Subject:Re: triggers and references.
View as plain text  
The many simple questions you ask imply that you have not read the manual.

Triggers are not supported.

Matthew Darcy wrote:

>
>Hi,
>
>in Oracle I have a test database. there are 2 tables table1 and table2.
>
>there is a field on both tables called account_number. on table 1 it is set
>to auto increment.
>
>I have set up a trigger so that when a number is generated in table1 it
>copies the number to account_number on table 2.
>
>Can this be done in mysql and how ?
>
>Thanks,
>
>Matt.
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread95970@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
triggers and references.Matthew Darcy10 Jan
  • Re: triggers and references.Jeremy Zawodny10 Jan
    • RE: triggers and references.Matthew Darcy10 Jan
  • Re: triggers and references.Gerald Clark10 Jan
    • RE: triggers and references.Matthew Darcy10 Jan