Sounds like we just need a table to keep track of LAST_INSERT_ID per table.
C:heers -----Original Message----- From: jds [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:05 AM To: [EMAIL PROTECTED] Cc: David T. Anderson Subject: triggers, stored procedures, and views I am building a database system and have been, like many before me, quite surprised that MySQL doesn't support triggers, sp's, and views. I can see how one can get around not having views with advanced permissions, as stated in the manual, although as I understand it this is no substitue for views- it is simply a workaround. I want to be very clear in explicating my understanding that MysQL is an open source technology, and putting it next to MS sQL Server 7 is not a fair comparison, as MS has invested many millions in that product over the years developing features...as has Oracle. It's kind of like putting AbiWord next to MS Word...apples to oranges... But not having triggers DOES make implementation of a transactional layer very difficult. I'm wondering if anyone that has encountered this problem and found a suitable solution would be so kind as to share his/her experience with myself and the rest of the list? Or do the developers have any suggestions? Perhaps a collection of Perl scripts sending records to a transactional table as well as the main data tables??? but then I would have to code this for all the different operations that take place when one of the data editors touches the database. Thanks in advance to anyone willing to approach this subject and share their experiences. Regards, jd -----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 6:26 AM To: [EMAIL PROTECTED] Subject: Is Triggers Possible in MySQL sreedhar, Wednesday, January 30, 2002, 6:02:35 AM, you wrote: s> Hi All s> Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS. MySQL doesn't support triggers, look at: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html s> regards, s> SREEDHAR -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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