---

About

simplifield-sql is a powerful Node.js module that allows you to easily interact with the MySQL Database.

---

Installation

Node.js 16.9.0 or newer is required.

npm install simplifield-sql
yarn add simplifield-sql

---

Example usage

Install simplifield-sql:

npm install simplifield-sql
yarn add simplifield-sql

Create new database connection:

const Database = require("simplifield-sql");

const db = new Database({
  user: "root",
  host: "localhost",
  database: "myowndatabase",
  password: "mysecretshellpassword",
});

db.on("connect", (connection) => {
  console.log(`Connected to ${connection.config.database} database 👌`);
});

And now you're able to insert, update and delete the database rows

---

Methods

Connections

• Destroy Connection
• Ping

Tables

• Tables

Rows

• Select
• Select All
• Insert
• Update
• Delete

---

Documents

Connections

.destroy()

Logs out, terminates the connection to Mysql, and destroys the client.

Returns: void

.ping()

The speed of the database connection with the server

Returns: number

Tables

.tables()

Array that contains all of the database tables

Returns: Table[]

Rows

.select(table, condetions)

To select a specific from the table

PARAMETER	TYPE	DESCRIPTION
table	string	The mysql table
condetions	object	The condetions of data updation

Returns: Data?

.selectAll(table, condetions)

To select all rows from the table using the data conditions

PARAMETER	TYPE	DESCRIPTION
table	string	The mysql table
condetions	object	The condetions of data updation

Returns: Data[]

.insert(table, values)

To insert new values on the table

PARAMETER	TYPE	DESCRIPTION
table	string	The mysql table
condetions	object	The condetions of data updation

Returns: Data

.update(table, condetions, values)

To update a specific row in the table

PARAMETER	TYPE	DESCRIPTION
table	string	The mysql table
condetions	object	The condetions of data updation
values	object	The new values

Returns: Data

.delete(table, condetions)

To delete a specific row from the table

PARAMETER	TYPE	DESCRIPTION
table	string	The mysql table
condetions	object	The condetions of data deletion

Returns: boolean