Hi, Look at Postgresql. http://www.postgresql.org/
It supports sub queries, transactions and lots more. Price is same as MySQL -- free. We've been using it for quite a while and are quite happy with it. Dror On Tue, Jul 02, 2002 at 05:44:06PM -0400, Scott Murray wrote: > I know that's a very open-ended question, but I started this project with > the intent of using MySQL. > > However, I now realize that my servlets will be running twice a many queries > as expected because MySQL doesn't support subqueries or joins on update > queries, such as: > > update tbl_shift inner join tbl_team on > tbl_shift.shift_id = tbl_team.shift_id > set tbl_shift.employees = tbl_team.team_size > > Of course, with enough money I could buy a full ANSI DBMS and solve the > problem, but the price of MySQL is so attractive. > > Has anyone else run into this problem and found a good solution? > > TIA, > > Scott > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.zapatec.com ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
