CODEWITHSUNDEEP
phpmysql
user3386779
user3386779

Reputation: 7185

updating view table gives an error

I have a view table webform_views_welcome_message_2 with column 'moderation','sid'. I want to update the view table.now I caught error as **

The target table webform_views_welcome_message_2 of the UPDATE is not updatable

update `webform_views_welcome_message_2`set moderation='1' where sid='1'

why I'm getting this error while updating

Upvotes: 1

Views: 52

Answers (1)

abrar
abrar

Reputation: 490

Update the original table, the view table will be updated automatically as the view table is read-only.

Upvotes: 2

Related Questions