I am pretty new to mysql, and have been studying the feesibility of offering a mysql version of my product (currently uses ms sql server). Reading a post to this list yesterday, it came to my attention that there is no FROM clause allowed in either the UPDATE or DELETE statements (actually, the DELETE statement has a FROM clause but you can't, as I understand, JOIN tables there). This will pose significant design challenges for me as my app relies heavily on this functionality. So far, I have conceived 2 ways to work around this limitation. 1. Use CREATE TEMPORARY TABLE (...) SELECT (with my join); Then, REPLACE INTO ... SELECT. (Note, for deletes, it would be necessesary to carry a flag field which would be updated using the above process and then DELETE ... WHERE flag = set) 2. Build an app with the C API which will simulate the functionality in two steps. (Note, this would be a pain!) Getting to my question... Surely this gaping whole in the functionality spectrum has inspired the creativity of many in this group. Would anyone care to share the details of solutions they have invented to work around this limitation? --------------------------------------------------------------------- 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
