java - 通过从其他表中提取数据向表中插入数据

Question

我试图通过从另一个表中提取值来插入值，但在尝试这种方式时出现了exceptionsqlsyntax 错误

int row=st.executeUpdate("insert into bug_history (bug_h_id,type,summary,desc,ans) 
select bug_id,type,summary,desc,solution 
from bug_details 
where bug_id="+bug_id);

Answer 1

按如下方式更改您的查询。使用 Backtick 符号

INSERT INTO bug_history (`bug_h_id`, `type`, `summary`, `desc`, `ans`) 
SELECT `bug_id`, `type`, `summary`, `desc`, `solution` 
FROM   bug_details 
WHERE  bug_id = bugID