Update multiple Tables using one Mysql View

#1

This week I‘ll do some tests with Mysql Updateform over multiple tables. Does it make sense to use a Mysql View or should I go with Server steps and pass the ForeignKey to the depending connected mysql table? What makes more sense and where u see Mysql views in wappler?

#2

I would do the latter because my database usage has been of the simplest types.

Having said that, MySQL View has some advantages, security in particular. I would be very interested in your tests.

#3

Why would you want to use mysql updatable views instead of simply doing the update statements you need?

In Wappler the delete action is really powerful and you can have as many as you want…