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.

SELECT
*
FROM
t1
JOIN
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


Subject
Views
Written By
Posted
editable join / queries
201
June 15, 2020 07:11AM
101
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.