Vue mysql 变量赋值, 获取数组

    let sql = `select consignor_Id from Base_Agent_Rate where agent_Id = ? group by consignor_Id
                      UNION ALL
                      SELECT consignor_Id FROM Base_Agent_RateTwo WHERE agent_Id =? group by consignor_Id
            `;
            let agentRate = await this.dbRead.query(sql, [userInfo.consignor_Id, userInfo.consignor_Id]);           --- 多条
            let consignorids = agentRate.map(item => item.consignor_Id);
            where = {
              consignor_Id: In(consignorids)
            }

  

Vue mysql 变量赋值, 获取数组

上一篇:Debian9解压安装MySQL(版本5.7.31)


下一篇:温故知新:常用的SQL标准有哪些,在SQL92中是 如何使用连接的?