> I believe the answer is that there isn't a way to fix the syntax for 3.23, > because 3.23 simply doesn't support multi-table deletes. An alternative > solution is needed. > > One option would be to do this programmatically. Collect the sectionids > with a SELECT, then delete them with a separate query. > > Another option would be to select the good rows into a new table, then use > this new table to recreate table A. Something like > > CREATE TABLE A2 > SELECT A.* > FROM A JOIN B ON A.sectionid = B.id; > > then > > DELETE FROM A; > INSERT INTO A SELECT * FROM A2; > > or > > RENAME TABLE A TO A_old, A2 TO A; > > Michael > it's work, thanks mike!
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
