MySQL Forums
Forum List  »  Views

editable join / queries
Posted by: Kenny Holmes
Date: June 15, 2020 07:11AM

sorry for the newbie question. It has been a few years since I have done anything with mysql and I had limited experience then.

I am converting a MS Access database to mysql. In the query below the result would be editable and allow modifications to the underlying tables directly within the query result. This does not work in mysql.

t2 ON t1.idt1 = t2.idt1

The same result is ready only for mysql. I know the reason has something to do with making sure each record is explicitly addressed. But why does this work in access and not mysql? Is there a way to mimic the way Access allows the query to be edited?

Options: ReplyQuote

Written By
editable join / queries
June 15, 2020 07:11AM
June 15, 2020 12:59PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.