| Index
» Projects
» phpMyEdit
» Forum
» Error when deleting a record when source table is mysql view |
 |
blueboxbro
Joined: 06 Feb 2008
Posts: 1
Posted: 2008-02-06 15:26
Back to top
Reply with quote
|
Ok I created a query in mysql and am able to execute it . The results show the records I am looking for. I can select a record or records and delete them without problem. I then saved the mysql query as a "view" in mysql.
I ran the phpMyEditSetup.php and use the mysql view I created as the source table. When I run the php script that is created through a browser the correct results are displayed. When I select a record and try and delete it I get an error which states:
"MySQL error 1288. The target table <mysql view name> of the DELETE is not updatable."
Any idea why I cant delete records when the source table is "mysql view" as opposed to a "mysql table"?
Is there a way around this?
P.S. The query(view) is fairly complex but only references one table.
|
exio82
Joined: 20 Sep 2007
Posts: 6
Posted: 2008-02-14 12:54
Back to top
Reply with quote
|
This is a mysql issue not phpmyedit one.
I also tried to use views instead of tables and I can strongly suggest to not use them.
They are supported only by mysql 5 and above (not 4) and have lots of restrictions.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/view-restrictions.html
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
