内部联接后为只读(MySQL) [英] Read-only after inner join (MySQL)
问题描述
在MySQL工作台(Mac OS)中,我想连接两个表,以便可以更新第二个表.我输入的代码如下
In MySQL workbench (Mac OS), I wanted to join two tables so that I can update the second one. The code I put in was as follows
select f.company, f.remarks, c.pic
from feedback f, customers c
where f.col = c.col
order by f.company;
输出为只读表,这使我无法基于f.remarks列更新表"customers".
The output is a read only table, which prevented me from updating table "customers" based on the f.remarks column.
对您的建议/建议表示赞赏.谢谢.
Your advice/suggestion is appreciated. Thank you.
推荐答案
通过将鼠标悬停在只读"图标上方,我收到以下消息: 声明必须是来自具有主键的单个表中的SELECT,其结果才能可编辑."
By hovering above the "Read Only" icon, I got the following message: "Statement must be a SELECT from a single table with a primary key for its results to be editable".
根据其他编码人员的建议进行研究后,需要注意以下几点:
After some research based on the advice given by fellow coders, here are some points to note:
- 在MySQL工作台中,无法编辑从任何JOIN获得的结果,因为它不是来自单个表;
- 在单个表中使用SELECT时,必须包含主键才能使结果可编辑.
感谢所有对此问题做出贡献的人.我很感激.
Thank you to everyone who contributed to the question. I appreciate it.
这篇关于内部联接后为只读(MySQL)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!