# vn-mysql

> A node.js driver for mysql. It is written in JavaScript, does not require compiling, and is 100% MIT licensed.

Latest version **1.0.3** (published 2016-07-22) · MIT license · 0 weekly downloads

## Install

```sh
npm install vn-mysql
pnpm add vn-mysql
yarn add vn-mysql
bun add vn-mysql
```

## Health

**Score 20/100 (F)** — status: abandoned.

Positive: no vulnerabilities; popular repo.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.3 |
| Published | 2016-07-22 |
| First published | 2016-07-11 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Node | >= 0.6 |
| Dependencies | 3 |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 18615 |
| Author | Felix Geisendörfer |
| Maintainers | nguyenthuan |

## Links

- npm: https://www.npmjs.com/package/vn-mysql
- Repository: https://github.com/felixge/node-mysql
- Issues: https://github.com/felixge/node-mysql/issues
- npm.io page: https://npm.io/package/vn-mysql

## Dependencies (3)

- [sqlstring](https://npm.io/package/sqlstring.md) 2.0.1
- [bignumber.js](https://npm.io/package/bignumber.js.md) 2.3.0
- [readable-stream](https://npm.io/package/readable-stream.md) 1.1.14

## Recent versions

- 1.0.3 (latest) — 2016-07-22
- 1.0.2 — 2016-07-22
- 1.0.1 — 2016-07-14
- 1.0.0 — 2016-07-11

## README

This module custom from module "mysql".

Install
=======
    npm i vn-define vn-mysql --save

Examples
========

```javascript
var mysql = require("vn-mysql");
var db = new mysql("database");
var callback = function(e){ console.log(e) };

// fetch or fetchAll
db.table("user")
  .column("id,fname,lname");
  .where({id: 1})
  .fetch(callback)
  .catch(callback);

// join
db.table("post as p")
  .column([
    "p.id as post_id, p.user as post_user, p.title, p.content, p.created",
    "a.id as album_id, a.name as album_name",
    "u.fname as user_fname, u.lname as user_lname"
  ])
  .leftJoin({
    "album as a": "a.aid = p.aid",
    "user as u": "u.id = p.user"
  })
  .where("id", ">", 10)
  .limit(20)
  .fetchAll(callback);

// select in
db.table("post").column("id, title").in("name", ["Thuan", "Chi"]).fetchAll(callback);

db.table("post").column("id, title").in("name", function(){
  return this.table("user").column("lname").where({fname: "Nguyen"});
})
.fetchAll(callback)
.catch(callback);

// insert
db.table("user").insert({fname: "Nguyen", lname: "Thuan"}, callback);

db.table("post").column("name").insert(function(){
  return this.table("user").where({id: 1}).column("concat(fname, ' ', lname)");
});

db.table("user").insertArray([
  {fname: "Fname1", lname: "Lname1"},
  {fname: "Fname2", lname: "Lname2"}
]);

// update
db.table("user").where({id: 1}).update({fname: "New Fname"});

// delete
db.table("user").where({id: 1}).remove();

db.table("post").remove(function(){
  this.table("user").where({username: 'nguyenthuan'});
  return this;
});
```

---
_Source: https://npm.io/package/vn-mysql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._