Bug #43165 Mutliple row updates
Submitted: 25 Feb 2009 4:36 Modified: 25 Feb 2009 6:04
Reporter: Shekhar Naidu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: deletes, Mutliple row updates

[25 Feb 2009 4:36] Shekhar Naidu 
Description:
Do we have Multiple row updates and deletes using JOINS which is available in MSSQL Server.??

How to repeat:
	DELETE FROM FolderPermission
		FROM FolderPermission FP
			INNER JOIN Folders AS F ON FP.FolderID  = F.FolderID 
		WHERE F.PortalID = $PortalID
		AND FP.UserID = $UserID
[25 Feb 2009 6:04] Sveta Smirnova 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Please read about multi-table syntax for DELETE at http://dev.mysql.com/doc/refman/5.0/en/delete.html