SQL语句: select a.*,b.mtlname from fz12.mtlprc a left join mtlname b on a.code=b.code order by a.materialcode 我主要是对a表进行,添加,修改,删除操作,添加/修改功能都可以完成,但删除记录时出现"缺少更新或刷新的键列信息" 请教各位
//查询语句
SELECT Field1,Field2 FROM Table1;
//添加语句
INSERT INTO Table1 (Name,Age) VALUES('zhangsan', 22);
//修改语句
UPDATE Table1 SET Name = 'zhangsan', Age = 22 WHERE ID = '1234567';
//删除语句
DELETE FROM Table1 WHERE ID = '1234567';