用egg MySQL insert 数据时候出现1241错误

Question

错误信息
sql: INSERT INTO materials_info(name, spec, brand, thickness, b, type, createdAt) VALUES('erw', 'fdf', 'fdf', 0.5, 0, ('11', '111', '1111', '11111'), now())
code: "ER_OPERAND_COLUMNS"
errno: 1241
sqlMessage: "Operand should contain 1 column(s)"
sqlState: "21000"
index: 0
sql: "INSERT INTO materials_info(name, spec, brand, thickness, b, type, createdAt) VALUES('erw', 'fdf', 'fdf', 0.5, 0, ('11', '111', '1111', '11111'), now())"
headers: {"Access-Control-Allow-Origin":"*","vary":"Origin"}
name: "ER_OPERAND_COLUMNSError"

---

egg里面的代码如下。

async add(request) {
    delete request.method;
    request.createdAt = this.app.mysql.literals.now;
    const result = await this.app.mysql.insert('materials_info', request);
    return result;
  }

Answer 1

这个('11', '111', '1111', '11111')格式转一下，转成string再试下

Answer 2

红色标注的这是啥？目测是这块的问题，对应的这个字段是什么类型？

Answer 3

INSERT INTO materials_info(name, spec, brand, thickness, b, type, createdAt) VALUES('erw', 'fdf', 'fdf', 0.5, 0, "('11', '111', '1111', '11111')", now())