I am implementing a inheritence in sql database. I have got a table called Entity with attributes Name,Password and a = Advertiser table.
Basically, in my java program the Entity is the base class of the = Advertiser class. ( I like using inheritence a lot ). Both tables have an autonumber as key. When inserting a new advetiser, I need to insert a row in the entity = table, when the index ( autonumber ) and insert the same key in the = advertiser table. Does anyone know how to get integer ( autonumber ) just inserted, so I = can have the same key in the advertiser table? What do you think about implementing inheritence this way in the = database? Thanks. Gustavo. --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php