knex 找不到mysql_knex-JavaScript中文网-JavaScript教程资源分享门户

A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser

knex.js

A SQL query builder that is flexible, portable, and fun to use!

A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder for

Node.js, featuring:

Node.js versions 8+ are supported.

For support and questions, join the #bookshelf channel on freenode IRC

For an Object Relational Mapper, see:

To see the SQL that Knex will generate for a given query, see: Knex Query Lab

Examples

We have several examples on the website. Here is the first one to get you started:

const knex = require('knex')({

client: 'sqlite3',

connection: {

filename: './data.db',

},

});

// Create a table

knex.schema

.createTable('users', function(table) {

table.increments('id');

table.string('user_name');

})

// ...and another

.createTable('accounts', function(table) {

table.increments('id');

table.string('account_name');

table

.integer('user_id')

.unsigned()

.references('users.id');

})

// Then query the table...

.then(function() {

return knex('users').insert({ user_name: 'Tim' });

})

// ...and using the insert id, insert into the other table.

.then(function(rows) {

return knex('accounts').insert({ account_name: 'knex', user_id: rows[0] });

})

// Query both of the rows.

.then(function() {

return knex('users')

.join('accounts', 'users.id', 'accounts.user_id')

.select('users.user_name as user', 'accounts.account_name as account');

})

// .map over the results

.map(function(row) {

console.log(row);

})

// Finally, add a .catch handler for the promise chain

.catch(function(e) {

console.error(e);

});

HomePage

Repository