mysql.ts
A simple node.js MySQL wrapper made with TypeScript.
Installation
npm
npm i @casper124578/mysql.ts
Yarn
yarn add @casper124578/mysql.ts
Usage
import { createConnection } from "@casper124578/mysql.ts";
async function init() {
const connection = await createConnection({
});
const results = await connection.query().select(["id", "name"]).from("books").exec();
console.log(results);
}
TypeScript support
interface MyData {
id: string;
fist_name: string;
last_name: string;
}
const connection = await createConnection({
});
const books = await connection
.query<MyData>()
.select(["last_name", "fist_name"])
.from("books")
.where("last_name", "hello")
.order("last_name", "ASC")
.exec();
This is not a full list of methods. Check the docs for a full list!
Documentation
Checkout the documentation here
More
Example
You view check an example here