<html><head></head><body><div class="ydp49c4d3e7yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">Hi Danny,</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I think this is best approached from within your MySQL database. It sounds like you are looking to make an Updatable View. This article should be helpful to you:</div><div dir="ltr" data-setdir="false"><a href="https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html" rel="nofollow" target="_blank">https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html</a></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Failing that you may also want to look at using INSTEAD OF triggers.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">There are many relevant questions and answers, for example on Stack Overflow, for MySQL and updatable views.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">-Thayer</div><div dir="ltr" data-setdir="false"><br></div><div><br></div></div><div id="ydp73604188yahoo_quoted_2343273000" class="ydp73604188yahoo_quoted"><div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;"><div><div dir="ltr">> Date: Tue, 18 May 2021 07:47:43 +0200<br></div><div dir="ltr" data-setdir="false"><span><span style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">> </span></span>From: Danny <<a href="mailto:dpr07u@gmail.com" rel="nofollow" target="_blank">dpr07u@gmail.com</a>><br></div><div dir="ltr" data-setdir="false"><span><span style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">> </span></span>To: <a href="mailto:qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">qgis-user@lists.osgeo.org</a><br></div><div dir="ltr" data-setdir="false"><span><span style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">> </span></span>Subject: [Qgis-user] how to synchronize the qgis point layer with the source tables</div><div dir="ltr" data-setdir="false"><span><span style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">> </span></span>Message-ID: <CALiTc6Au2jgPhSuXTw4WGeMEbnuBM348A9hGA=<a href="mailto:vjco9smetETg@mail.gmail.com" rel="nofollow" target="_blank">vjco9smetETg@mail.gmail.com</a>> Content-Type: text/plain; charset="utf-8"</div><div dir="ltr"><br></div><div dir="ltr"><<a href="https://stackoverflow.com/posts/67565307/timeline" rel="nofollow" target="_blank">https://stackoverflow.com/posts/67565307/timeline</a>><br></div><div dir="ltr"><br></div><div dir="ltr">I have the nexts questions:<br></div><div dir="ltr"><br></div><div dir="ltr">I have 5 tables from phpmyadmin webpage synchronize with qgis. If i update<br></div><div dir="ltr">the attributes table in webpage or qgis it syncs. I used the 5 tables for<br></div><div dir="ltr">create the point layer.<br></div><div dir="ltr"><br></div><div dir="ltr">My problem is that one time created the point layer based in this 5 tables,<br></div><div dir="ltr">When I update the dates directly in the layer point is not synchronize with<br></div><div dir="ltr">the 5 tables.<br></div><div dir="ltr"><br></div><div dir="ltr">Either If one time created the point layer, if I modify the 5 source<br></div><div dir="ltr">tables, the data of the point layer is not modified and another time i need<br></div><div dir="ltr">to create the point layer for update it.<br></div><div dir="ltr"><br></div><div dir="ltr">So , exist any option for activate the synchronize?<br></div><div dir="ltr">-------------- next part --------------<br></div><div dir="ltr">An HTML attachment was scrubbed...<br></div><div dir="ltr">URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20210518/bab07e15/attachment-0001.html" rel="nofollow" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20210518/bab07e15/attachment-0001.html</a>><br></div><div dir="ltr"><br></div></div>
</div>
</div></body></html>