egg-mysql语句

一、select

select(表名, {where条件, 列名})

const user = await this.app.mysql.select('m_user', {
  where: { phone: username, password: 1 },
  columns: [ 'id' ],
});

二、insert

insert(表名, 插入列值)

await this.app.mysql.insert('m_user', {
  username: employeeName,
  phone,
  password: md5('GsNtM6TS' + phone),
  permission: 2,
  store_id: storeId,
  create_at: this.app.mysql.literals.now,
  create_by: username,
});

三、update

update(表名, 变更列值, where条件)

await this.app.mysql.update('m_user', {
  password: md5('GsNtM6TS' + password),
  create_at: this.app.mysql.literals.now,
  create_by: username,
}, { where: { id: 1 } });

四、delete

delete(表名, 条件)

await this.app.mysql.delete('m_user', { id: 1 });

五、直接执行sql语句

await this.app.mysql.query(sql);