记录一次MySQL查询优化
WITH `tmp` AS (
SELECT
`m`.`FactoryName` AS `FactoryName`,
`m`.`Spec` AS `Spec`,
`m`.`MaterialType` AS `MaterialType`,
`m1`.`ProductionPlanID` AS `ProductionPlanID`,
`m`.`PurchCycle` AS `PurchCycle`,
`m`.`MaterialCheckCycle` AS `MaterialCheck.
原创
2021-09-03 15:54:37 ·
144 阅读 ·
0 评论