Cannot add or edit data in view

[Kenny Holmes]

Hi,
Sorry if this is a newbie issue, but I have been googling it all day and can't figure it out.

I am using MySQL Workbench 5.2.47 on windows 8.

I am trying to create a view that is editable. I have some more complex views that I want to make editable, but for the moment I am trying a simple sample. At the moment my view was created with the following.

"SELECT * FROM mytable"

The table currently only has an Auto incrementing ID field as the primary key and a text field.

If I open the table in the Query browser it opens with the following query.

"SELECT * FROM mytable"

When I do this I can edit the data no problem.

If I open the view in the Query Browser it opens with the following query.

"SELECT * FROM myview"

The same data is shown, but the record set is not editable. Any ideas what I am doing wrong?

Cheers

Kenny