MySQL Forums
Forum List  »  Triggers

How we can add triggers with master/detailed tables with reference number
Posted by: BAIJU M.B
Date: April 29, 2006 04:17AM

Hi,

I am fist time trying with mysql triggers and stored procedures.


I have two tables just like inv1 and inv2.

Both fields I have doc_no field.

Auto-increment will not apply, because I need to feed my number manually. My requirments is, if input values exsist, it should increment +1 to check again and insert new values in inv1 and inv2 tables.

eg: My value is 100, But 100 & 101 alredy exists in the network, next value starts from 102 (that new value).

If possible, what is inserted new values (102) to get back to me for my
next tables ? ( it is not in this trigger)

If Trigger is not supporting, anybody can explin how do we sort the problem ?

Thanks in advance.


BAIJU.M.B

Options: ReplyQuote




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.