TomVista
V2EX  ›  问与答

数据库,求教怎么合并或拆散关联数据

  •  
  •   TomVista · Dec 25, 2018 · 998 views
    This topic created in 2703 days ago, the information mentioned may be changed or developed.

    表 Dosage

    [
      {
        "ID": "EE043027B5AB4CFAA34F829F4450D49D",
        "Piece": "D1EBDB242DCA40BA80856BC32E984C1C",
        "StorID": "2",
        "Storage": "",
        "MaterID": "",
        "Material": "",
        "Rate": "0",
        "RecAmnt": "1217",
        "PlanAmnt": "1217",
        "MeasAmnt": "",
        "FactAmnt": "1193",
        "Fall": "18",
        "FinTim": "43161.6767211806",
        "Data": "0",
        "Flag": "1",
        "Stamp": "43161.6808589236",
        "CRC": "957066660",
        "Mask": "FA39416CCB0B705BD408735DCD17705DC30A6F5B66",
        "ManuAmnt": "0",
        "Temper": "0"
      }
    ]
    

    表 Piece

    
    [
      {
        "ID": "D1EBDB242DCA40BA80856BC32E984C1C",
        ...
      }
    ]
    

    Piece 一对多 Dosage,

    如何把多条 Dosage 合并到对应的 Piece. 或者把一条数据拆分成一对多关系分表存储.

    可不可以批合并 或拆分?

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2439 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 30ms · UTC 16:04 · PVG 00:04 · LAX 09:04 · JFK 12:04
    ♥ Do have faith in what you're doing.