美化SQL 复制为SQL

美化SQL

点击 美化SQL 如果是入库 加库存 参见 2023-11-04 09:55:46 40.41

复制为SQL

表记录右击复制为SQL语句

INSERT INTO project-yousheng.hd_sales_returnorder_detail(id, formId, materialId, batchNo, grade, quantity, weight, rate, price, amount, taxAmount, remark, type, finish, sampleFee, workshop, salesman, orderNo, stockId) VALUES (6, 49, 1, '2', NULL, NULL, 3.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

删除数据库，自增字段，

INSERT INTO `hd_sales_returnorder_detail` ( `formId`, `batchNo`) VALUES (49, '2');