egg-mysql

Install

$ npm i egg-mysql --save

Configuration

Change ${app_root}/config/plugin.js to enable MySQL plugin:

exports.mysql = {
 enable: true,
 package: 'egg-mysql',
};

Configure database information in ${app_root}/config/config.default.js:

exports.mysql = {
  // database configuration
  client: {
    // host
    host: 'mysql.com',
    // port
    port: '3306',
    // username
    user: 'test_user',
    // password
    password: 'test_password',
    // database
    database: 'test',    
  },
  // load into app, default is open
  app: true,
  // load into agent, default is close
  agent: false,
};

select

//查询所有,默认只返回前1000条
select * from 表
//条件查询
select * from 表 where 字段1=值1 and 字段2=值2
//根据查询条件返回特定的数据条数
select * from 表 limit <起始下标>,<查询个数>
//模糊搜索
select * from 表 where 字段 like "%搜索的值%"

insert

 insert into 表 (字段1,字段2) values (?,?)

update

update 表 set 字段=值 where id=?

delete

delete from 表 where id=?