# 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
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
1.项目代码功能经验证ok,确保稳定可靠运行。欢迎下载使用! 2.主要针对各个计算机相关专业,包括计科、信息安全、数据科学与大数据技术、人工智能、通信、物联网等领域的在校学生、专业教师或企业员工使用。 3.项目具有丰富的拓展空间,不仅可作为入门进阶,也可直接作为毕设、课程设计、大作业、初期项目立项演示等用途。 4.当然也鼓励大家基于此进行二次开发。在使用过程中,如有问题或建议,请及时私信沟通。 5.期待你能在项目中找到乐趣和灵感,也欢迎你的分享和反馈! 【资源说明】 基于uniapp开发的瑞幸咖啡小程序源码+页面截图+sql数据库+使用说明(课程设计).zip 项目源码解压重命名为luckin-coffee 在 HBuilder X 中打开 luckin-coffee 文件夹,使用工具 Navicat for MySQL 导入 luckin.sql,在 sever 文件夹下的 dome 选择打开终端,输入 npm start 运行后台数据库,该项目不需要下载所需依赖,均已打包上传。 基于 uniapp 和 vue2 实现的瑞幸咖啡小程序,使用 HBuilder X 编辑器进行开发,用 MySQL 写接口,在设备 iPhone 6/7/8 中进行展示,实现了登录,购物车,商品分类等功能 订单 点击不同商品进入该商品详情页,并可以·实现商品分类效果 详情页 点击加入购物车,未登录则不可以加入 登录界面 没有账号可以注册,账号密码必须正确且必须同意协议,否则无法登录,不同账号显示不同用户名以及头像 注册 如果账号已经存在 login 表中则显示已经注册,需要重新注册 购物车 商品为空显示去购买 自动计算总价,全选以及反选功能
资源推荐
资源详情
资源评论
收起资源包目录
基于uniapp开发的瑞幸咖啡小程序源码+页面截图+sql数据库+使用说明(课程设计).zip (2000个子文件)
uniicons.css 8KB
uniicons.css 8KB
index.css 1KB
index.css 1KB
index.css 1KB
hairline.css 827B
hairline.css 827B
hairline.css 827B
ellipsis.css 297B
ellipsis.css 297B
ellipsis.css 297B
style.css 111B
clearfix.css 56B
clearfix.css 56B
clearfix.css 56B
theme.css 0B
ellipsis.css 0B
hairline.css 0B
clearfix.css 0B
var.css 0B
ellipsis.css 0B
hairline.css 0B
clearfix.css 0B
var.css 0B
theme.css 0B
ellipsis.css 0B
hairline.css 0B
clearfix.css 0B
var.css 0B
API.html 82KB
props.html 2KB
index.html 672B
block-code.html 0B
jade.js 261KB
source-map.debug.js 254KB
compress.js 175KB
errors.js 172KB
acorn_csp.js 132KB
acorn_csp.js 132KB
acorn.js 130KB
acorn.js 130KB
acorn.js 119KB
source-map.js 100KB
bignumber.js 84KB
ssl_profiles.js 81KB
compress.js 80KB
parse.js 56KB
parse.js 49KB
output.js 47KB
acorn_loose.js 44KB
acorn_loose.js 41KB
acorn_loose.js 41KB
output.js 39KB
source-map-consumer.js 39KB
source-map-consumer.js 37KB
ast.js 34KB
sbcs-data-generated.js 31KB
ast.js 31KB
_stream_readable.js 31KB
_stream_readable.js 31KB
response.js 26KB
response.js 26KB
icons.js 26KB
icons.js 26KB
source-map.min.js 26KB
expression.js 25KB
expression.js 24KB
expression.js 24KB
index.js 24KB
scope.js 23KB
index.js 23KB
tokenize.js 22KB
tokenize.js 22KB
tokenize.js 22KB
lexer.js 22KB
mozilla-ast.js 22KB
parse.js 22KB
index.js 22KB
index.js 22KB
test-source-map-consumer.js 21KB
source-map-consumer.js 21KB
statement.js 21KB
dbcs-codec.js 21KB
scope.js 21KB
stringify.js 20KB
_stream_writable.js 20KB
_stream_writable.js 20KB
test-source-node.js 20KB
statement.js 20KB
statement.js 20KB
test-source-map-generator.js 19KB
compiler.js 19KB
parser.js 19KB
qs.js 19KB
ipaddr.js 19KB
bignumber.min.js 18KB
transformers.js 16KB
expression.js 16KB
expression.js 15KB
expression.js 15KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
北航程序员小C
- 粉丝: 2244
- 资源: 1824
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功