query_builder_for_mysql_in_node

Mysql query builder for node

Installation

npm i query_builder_for_mysql_in_node

Examples

Select statement

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

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();