MySQL can a View update a table
Posted on 2012-08-16
In a previous thread I learned a little about creating Views.
I created a view which allowed me to bring together two fields
Image1 and imagedirectory and store these in FullPath
select `boats`.`RecNo` AS `RecNo`,`boats`.`Manufacturer` AS `Manufacturer`,`boats`.`imagedirectory` AS `imagedirectory`,`boats`.`image1` AS `image1`,concat(`boats`.`imagedirectory`,`boats`.`image1`) AS `FullPath`,`boats`.`RegDate` AS `RegDate` from `boats`
I am using Dreamweaver to create an insert page but when I try to insert from the view I get an error
The target table fullpath_working2 of the INSERT is not insertable-into
I thought the view would update the main table but seems my thinking is wrong.
Any help welcomed!