MySQL Forums
Forum List  »  Triggers

Re: Trigger Creation
Posted by: Peter Brawley
Date: May 30, 2006 08:17AM

Not clear ...

- midcity has only one attribute but "all elements of city table but population < 5000000 and population > 500000" ???

- a "trigger which makes certain think" ???

- does your midcity table copy some data from the city table? Very bad idea.

Try posting the CREATE TABLE statements for the two tables, a bit of sample data, and the complete logic of the desired trigger in ordinary English.

PB

Options: ReplyQuote


Subject
Views
Written By
Posted
a
2355
May 30, 2006 07:57AM
Re: Trigger Creation
1742
May 30, 2006 08:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.