# mysql
[![NPM Version][npm-version-image]][npm-url]
[![NPM Downloads][npm-downloads-image]][npm-url]
[![Node.js Version][node-image]][node-url]
[![Linux Build][travis-image]][travis-url]
[![Windows Build][appveyor-image]][appveyor-url]
[![Test Coverage][coveralls-image]][coveralls-url]
## Table of Contents
- [Install](#install)
- [Introduction](#introduction)
- [Contributors](#contributors)
- [Sponsors](#sponsors)
- [Community](#community)
- [Establishing connections](#establishing-connections)
- [Connection options](#connection-options)
- [SSL options](#ssl-options)
- [Connection flags](#connection-flags)
- [Terminating connections](#terminating-connections)
- [Pooling connections](#pooling-connections)
- [Pool options](#pool-options)
- [Pool events](#pool-events)
- [acquire](#acquire)
- [connection](#connection)
- [enqueue](#enqueue)
- [release](#release)
- [Closing all the connections in a pool](#closing-all-the-connections-in-a-pool)
- [PoolCluster](#poolcluster)
- [PoolCluster options](#poolcluster-options)
- [Switching users and altering connection state](#switching-users-and-altering-connection-state)
- [Server disconnects](#server-disconnects)
- [Performing queries](#performing-queries)
- [Escaping query values](#escaping-query-values)
- [Escaping query identifiers](#escaping-query-identifiers)
- [Preparing Queries](#preparing-queries)
- [Custom format](#custom-format)
- [Getting the id of an inserted row](#getting-the-id-of-an-inserted-row)
- [Getting the number of affected rows](#getting-the-number-of-affected-rows)
- [Getting the number of changed rows](#getting-the-number-of-changed-rows)
- [Getting the connection ID](#getting-the-connection-id)
- [Executing queries in parallel](#executing-queries-in-parallel)
- [Streaming query rows](#streaming-query-rows)
- [Piping results with Streams](#piping-results-with-streams)
- [Multiple statement queries](#multiple-statement-queries)
- [Stored procedures](#stored-procedures)
- [Joins with overlapping column names](#joins-with-overlapping-column-names)
- [Transactions](#transactions)
- [Ping](#ping)
- [Timeouts](#timeouts)
- [Error handling](#error-handling)
- [Exception Safety](#exception-safety)
- [Type casting](#type-casting)
- [Number](#number)
- [Date](#date)
- [Buffer](#buffer)
- [String](#string)
- [Custom type casting](#custom-type-casting)
- [Debugging and reporting problems](#debugging-and-reporting-problems)
- [Security issues](#security-issues)
- [Contributing](#contributing)
- [Running tests](#running-tests)
- [Running unit tests](#running-unit-tests)
- [Running integration tests](#running-integration-tests)
- [Todo](#todo)
## Install
This is a [Node.js](https://nodejs.org/en/) module available through the
[npm registry](https://www.npmjs.com/).
Before installing, [download and install Node.js](https://nodejs.org/en/download/).
Node.js 0.6 or higher is required.
Installation is done using the
[`npm install` command](https://docs.npmjs.com/getting-started/installing-npm-packages-locally):
```sh
$ npm install mysql
```
For information about the previous 0.9.x releases, visit the [v0.9 branch][].
Sometimes I may also ask you to install the latest version from Github to check
if a bugfix is working. In this case, please do:
```sh
$ npm install mysqljs/mysql
```
[v0.9 branch]: https://github.com/mysqljs/mysql/tree/v0.9
## Introduction
This is a node.js driver for mysql. It is written in JavaScript, does not
require compiling, and is 100% MIT licensed.
Here is an example on how to use it:
```js
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
if (error) throw error;
console.log('The solution is: ', results[0].solution);
});
connection.end();
```
From this example, you can learn the following:
* Every method you invoke on a connection is queued and executed in sequence.
* Closing the connection is done using `end()` which makes sure all remaining
queries are executed before sending a quit packet to the mysql server.
## Contributors
Thanks goes to the people who have contributed code to this module, see the
[GitHub Contributors page][].
[GitHub Contributors page]: https://github.com/mysqljs/mysql/graphs/contributors
Additionally I'd like to thank the following people:
* [Andrey Hristov][] (Oracle) - for helping me with protocol questions.
* [Ulf Wendel][] (Oracle) - for helping me with protocol questions.
[Ulf Wendel]: http://blog.ulf-wendel.de/
[Andrey Hristov]: http://andrey.hristov.com/
## Sponsors
The following companies have supported this project financially, allowing me to
spend more time on it (ordered by time of contribution):
* [Transloadit](http://transloadit.com) (my startup, we do file uploading &
video encoding as a service, check it out)
* [Joyent](http://www.joyent.com/)
* [pinkbike.com](http://pinkbike.com/)
* [Holiday Extras](http://www.holidayextras.co.uk/) (they are [hiring](http://join.holidayextras.co.uk/))
* [Newscope](http://newscope.com/) (they are [hiring](https://newscope.com/unternehmen/jobs/))
## Community
If you'd like to discuss this module, or ask questions about it, please use one
of the following:
* **Mailing list**: https://groups.google.com/forum/#!forum/node-mysql
* **IRC Channel**: #node.js (on freenode.net, I pay attention to any message
including the term `mysql`)
## Establishing connections
The recommended way to establish a connection is this:
```js
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'example.org',
user : 'bob',
password : 'secret'
});
connection.connect(function(err) {
if (err) {
console.error('error connecting: ' + err.stack);
return;
}
console.log('connected as id ' + connection.threadId);
});
```
However, a connection can also be implicitly established by invoking a query:
```js
var mysql = require('mysql');
var connection = mysql.createConnection(...);
connection.query('SELECT 1', function (error, results, fields) {
if (error) throw error;
// connected!
});
```
Depending on how you like to handle your errors, either method may be
appropriate. Any type of connection error (handshake or network) is considered
a fatal error, see the [Error Handling](#error-handling) section for more
information.
## Connection options
When establishing a connection, you can set the following options:
* `host`: The hostname of the database you are connecting to. (Default:
`localhost`)
* `port`: The port number to connect to. (Default: `3306`)
* `localAddress`: The source IP address to use for TCP connection. (Optional)
* `socketPath`: The path to a unix domain socket to connect to. When used `host`
and `port` are ignored.
* `user`: The MySQL user to authenticate as.
* `password`: The password of that MySQL user.
* `database`: Name of the database to use for this connection (Optional).
* `charset`: The charset for the connection. This is called "collation" in the SQL-level
of MySQL (like `utf8_general_ci`). If a SQL-level charset is specified (like `utf8mb4`)
then the default collation for that charset is used. (Default: `'UTF8_GENERAL_CI'`)
* `timezone`: The timezone configured on the MySQL server. This is used to type cast server date/time values to JavaScript `Date` object and vice versa. This can be `'local'`, `'Z'`, or an offset in the form `+HH:MM` or `-HH:MM`. (Default: `'local'`)
* `connectTimeout`: The milliseconds before a timeout occurs during the initial connection
to the MySQL server. (Default: `10000`)
* `stringifyObjects`: Stringify objects instead of converting to values. See
issue [#501](https://github.com/mysqljs/mysql/issues/501). (Default: `false`)
* `insecureAuth`: Allow connecting to MySQL instances that ask for the old
(insecure) authentica
没有合适的资源?快使用搜索试试~ 我知道了~
基于vue+node.js的在线点餐系统源码+数据库.zip
共1541个文件
js:849个
md:138个
json:109个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 6 下载量 36 浏览量
2022-12-11
16:23:13
上传
评论 9
收藏 33.65MB ZIP 举报
温馨提示
基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端、服务器。 基于vue+node.js的在线点餐系统源码+数据库.zip分别有客户端、管理端
资源推荐
资源详情
资源评论
收起资源包目录
基于vue+node.js的在线点餐系统源码+数据库.zip (1541个子文件)
1649918385376 48KB
1649922043325 48KB
1650339515686 65KB
1650339515686 65KB
1650340323782 12KB
1650340430731 53KB
1650340640141 16KB
1650340844582 17KB
1650340927525 301KB
1650341170345 68KB
1650341313846 62KB
1650341565761 72KB
1650341673893 46KB
1650341720048 68KB
1650341874093 38KB
1650341963509 49KB
1650342128451 46KB
1650342373506 52KB
1650342487484 109KB
1650342745089 70KB
1650342828315 82KB
1650343176136 88KB
1650343225095 72KB
1650343431095 72KB
1650343586272 57KB
1650343661124 47KB
1650343782733 66KB
1650344010549 62KB
1650344065057 79KB
1650344121430 79KB
1650344196352 87KB
1650344271487 58KB
1650344355048 48KB
1650344432705 46KB
1650344671300 87KB
1650344798069 42KB
1650344883968 96KB
1650345071523 66KB
1650345148117 71KB
1650345219479 83KB
1650345297670 48KB
1650345370512 76KB
1650345445235 90KB
1650345527219 72KB
1650345612532 70KB
1650345710644 73KB
1650345784110 72KB
1650345954002 44KB
1650346005570 48KB
1650346066442 59KB
1650346130035 62KB
1650346216724 56KB
1650346277939 62KB
1650346370027 58KB
1650346440280 64KB
1650346595663 72KB
1650346657516 58KB
1650346729415 40KB
1650346785778 51KB
1650346870337 48KB
1650346933599 68KB
1650346987294 58KB
1650347067555 86KB
1650347139576 62KB
1650347204042 57KB
1650347333328 64KB
1650347415960 55KB
1650347501674 69KB
1650347566111 71KB
1650347619453 67KB
1650347692978 61KB
1650347754535 61KB
1650347807661 60KB
1650347880294 60KB
1650347976952 45KB
1650348054198 47KB
1650348255457 52KB
1650348312049 71KB
1650348373873 58KB
1650348435172 56KB
1650348483626 56KB
1650348541198 64KB
1650348624251 56KB
1650348694244 35KB
1650348762640 88KB
1650348813688 61KB
1650348902446 49KB
1650348982155 72KB
1650349103137 58KB
1650349160317 85KB
1650349222039 46KB
1650349285420 60KB
1650349376084 64KB
1650349432570 77KB
1650349490324 50KB
1650349565033 53KB
1650602386229 8.61MB
1650602753912 8.61MB
1650604041926 55KB
1650604068069 48KB
共 1541 条
- 1
- 2
- 3
- 4
- 5
- 6
- 16
程序员张小妍
- 粉丝: 1w+
- 资源: 2577
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
- 4
前往页