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
>
>
