sql的delete from语句细节

delete from 加别名要慎重

错误示范

		DELETE
        FROM sys_role_menu a
        WHERE a.menu_id =${menuId}

正确示范

		DELETE
        FROM sys_role_menu
        WHERE menu_id =${menuId}

加别名示范

		DELETE a
        FROM sys_role_menu a
        WHERE a.menu_id =${menuId}