MySQL Views in Navicat - How to define 'primary key'?

mysql views primary-key unique-index navicat
Ropstah picture Ropstah · May 19, 2009 · Viewed 11.6k times · Source

Often when I define a View in Navicat I receive the following message:

xxx does not have a primary key. Updates to this table will be done using the following pseudo statement: UPDATE xxx SET ModifiedFieldsAndValues WHERE AllFieldsAndOldValues LIMIT 1

Obviously I only use my Views for viewing data, not updating. But this did make me curious:

Is there a way to define a "primary key" or "unique index" on a View?

Answer

simon622 picture simon622 · May 19, 2009

its implied that the view uses the indices and primary keys of its base table. You can change the semantics of how insert and updates occur when using them via views by playing with the CASCADING CHECK options

See Updatable and Insertable Views

Related questions

View's SELECT contains a subquery in the FROM clause

I have two tables and I need to create a view. The tables are: credit_orders(id, client_id, number_of_credits, payment_status) credit_usage(id, client_id, credits_used, date) I use the following query to do this. …

Read More
MySql views performance

If you are going down the road of using views, how can you ensure good performance? Or is it better not to use views in the first place and just incorporate the equivalent into your select statements?

Read More
Is it possible to have an indexed view in MySQL?

I found a posting on the MySQL forums from 2005, but nothing more recent than that. Based on that, it's not possible. But a lot can change in 3-4 years. What I'm looking for is a way to have an index …

Read More