# query_builder_for_mysql_in_node

> ## Installation

Latest version **1.0.2** (published 2020-01-16) · ISC license · 0 weekly downloads

## Install

```sh
npm install query_builder_for_mysql_in_node
pnpm add query_builder_for_mysql_in_node
yarn add query_builder_for_mysql_in_node
bun add query_builder_for_mysql_in_node
```

## Health

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

Positive: has types; no vulnerabilities; high quality score.

Warnings: low downloads; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.2 |
| Published | 2020-01-16 |
| First published | 2020-01-15 |
| Weekly downloads | 0 |
| License | ISC |
| TypeScript types | bundled |
| Module format | CommonJS |
| Dependencies | 1 |
| Unpacked size | 64.2 KB |
| Known vulnerabilities | 0 (+7 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 0 |
| Maintainers | jasper.lichte |

## Links

- npm: https://www.npmjs.com/package/query_builder_for_mysql_in_node
- Repository: https://github.com/JasperLichte/node_mysql_query_builder
- Homepage: https://github.com/JasperLichte/node_mysql_query_builder#readme
- Issues: https://github.com/JasperLichte/node_mysql_query_builder/issues
- npm.io page: https://npm.io/package/query_builder_for_mysql_in_node

## Dependencies (1)

- [mysql2](https://npm.io/package/mysql2.md) ^2.1.0

## Recent versions

- 1.0.2 (latest) — 2020-01-16
- 1.0.1 — 2020-01-15
- 1.0.0 — 2020-01-15

## README

# Mysql query builder for node

## Installation

```
npm i query_builder_for_mysql_in_node
```

## Examples

### Select statement
```ts
import { select } from 'query_builder_for_mysql_in_node';
import { field } from "query_builder_for_mysql_in_node/queries/restrictions";

const [rows] = await select('id')
                    .from('users')
                    .where(
                        field('id').equals(42)
                    )
                    .orderBy('id')
                    .only(34)
                    execute();
```

### Insert statement
```ts
import { insert } from 'query_builder_for_mysql_in_node';

const query = insert({'id': 42, 'name': '"Bob"'}).into('users');
// yields: INSERT INTO users (id, name) VALUES (42, "Bob")

await query.execute();
```

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