Unable to update views, any advice on how to work around this?

Hi,

We are running MySQL 5.1 and I gather you cannot update views. We are developing some very simple .php pages for users to update information. The information we present to the 'user' is from a view, obviously this view is getting the data from a proper table at the end of the day but any advice on how I can go about this?

Best Regards

Ken
kenuk110Asked:
Who is Participating?
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
It seems view is not updateble if it contains:

Aggregate functions (SUM(), MIN(), MAX(), COUNT(), and so forth)
DISTINCT
GROUP BY
HAVING
UNION or UNION ALL
Subquery in the select list
Join
Non-updatable view in the FROM clause
A subquery in the WHERE clause that refers to a table in the FROM clause
Refers only to literal values (in this case, there is no underlying table to update)
ALGORITHM = TEMPTABLE (use of a temporary table always makes a view non-updatable)
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Can u pls post your view definition here??
0
 
kenuk110Author Commented:
Thanks for the response, it was due to some of the reasons you gave, I have tried it on a view with none of those functions and it works fine.

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.