这个是有数据的A表,需要写以下代码:
INSERT INTO ab(username, orgcode, C_BizRangeId, C_BizRangeName, workflowend, Createdatetime, Creator, xm, xb)
SELECT username, orgcode, C_BizRangeId, C_BizRangeName, workflowend, Createdatetime, Creator, xm, xb
FROM aa
WHERE (username = '黄小山')
方法:
INSERT INTO B表(列表1,列表2...)
SELECT 列表1,列表2...
FROM A表
WHERE (列表1 = '值')
结果: