Skip navigation links

MySQL Forums :: Views :: Cannot update a View


Advanced Search

Re: Cannot update a View
Posted by: Devart Team ()
Date: August 19, 2011 12:28AM

Your view cannot be updated. Have a look at this article - Updatable and Insertable Views

Also, I'd suggest you to rewrite your query. Something like this -

SELECT t1.* FROM
  jos_community_fields_values_copy t1
JOIN (SELECT
        User_ID
      FROM
        jos_community_fields_values_copy
      WHERE
        field_id = '4'AND Value = 'UK'
        OR
        field_id = '5'AND Value = 'Active') t2
ON t1.User_ID = t2.User_ID;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject Views Written By Posted
Cannot update a View 3312 Ryan Taylor 08/18/2011 02:03PM
Re: Cannot update a View 1257 Devart Team 08/19/2011 12:28AM
Mysqldump and mysql restor with views 1362 katie c 11/06/2011 01:15PM
Re: Mysqldump and mysql restor with views 1026 Devart Team 11/07/2011 12:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.