• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

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
0
kenuk110
Asked:
kenuk110
  • 2
1 Solution
 
UmeshCommented:
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
 
UmeshCommented:
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

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now