xdmy/doc/sql/f.sql

SELECT
    -- `PartLaid`.`bigBuyerId`,
    `PartLaid`.`bigId`,
    `PartLaid`.`brandId`,
    `PartLaid`.`buyAmount`,
    `PartLaid`.`buydetailId`,
    `PartLaid`.`contractId`,
    `PartLaid`.`id`,
    `PartLaid`.`locationId`,
    `PartLaid`.`note`,
    `PartLaid`.`orderNumber`,
    `PartLaid`.`partCode`,
    `PartLaid`.`partId`,
    `PartLaid`.`partName`,
    `PartLaid`.`pastureId`,
    `PartLaid`.`price`,
    `PartLaid`.`providerId`,
    `PartLaid`.`purpose`,
    `PartLaid`.`receivedAmount`,
    `PartLaid`.`reportery`,
    `PartLaid`.`specification`,
    `PartLaid`.`storageAmount`,
    `PartLaid`.`storageType`,
    `PartLaid`.`subscribePasture`,
    `PartLaid`.`subscribeProvider`,
    `PartLaid`.`sumPrice`,
    `PartLaid`.`unit`,
    `PartLaid`.`dflag`,
    `PartLaid`.`rowNumber`,
    `PartLaid`.`IsZeroStock`
FROM
    PartLaid pl
--     join bigpartlaid bpl on pl.bigid = bpl.id
-- WHERE
--     bpl.laidcode = 'RK01220826002'
limit 10