./node_modules/.bin/knex init

knex migrate:make migration_nameknex migrate:make migration_name --env production

knex migrate:latestknex migrate:latest --env production

knex migrate:rollbackknex migrate:rollback --env production

knex('users').where({id:2}).del()

knex('users').where({id:2}).update({name:'Homer'})

knex('users')

.insert({name:'John'})

.insert([{name:'Starsky'},{name:'Hutch'}])

knex.schema.renameTable('persons','people').dropTable('persons')

.hasTable('users').then(exists=>···).hasColumn('users','id').then(exists=>···)

knex.schema.table('accounts',table=>{

table.string('first_name')

table.string('first_name').alter()table.renameColumn('admin','is_admin')

table.dropColumn('admin')table.dropTimestamps('created_at')

})

knex.schema.createTable('accounts',table=>{

table.increments('id')table.string('account_name')table.integer('age')table.float('age')table.decimal('balance',8,2)table.boolean('is_admin')table.date('birthday')table.time('created_at')table.timestamp('created_at').defaultTo(knex.fn.now())table.json('profile')table.jsonb('profile')table.uuid('id').primary()

table.unique('email')table.unique(['email','company_id'])table.dropUnique(···)

table.foreign('company_id').references('companies.id')table.dropForeign(···)

table.integer('user_id').unsigned().references('users.id')

}).then(()=>···)

knex('users').pluck('id').then(ids=>{···})

knex('users').first().then(user=>{···})

.count('active').count('active as is_active')

.min('age').max('age').sum('age').sumDistinct('age').avg('age')

knex('users').distinct()

.groupBy('count').groupByRaw('year WITH ROLLUP')

.orderBy('name','desc').orderByRaw('name DESC')

.offset(10).limit(20)

.having('count','>',100).havingIn('count',[1,100])

.union(function(){this.select(···)}).unionAll(···)