1

npm install mysql2

1
2
3
4
5
6
7
8
9

const mysql2 = require("mysql2");

const connection = mysql2.createConnection({
  host: "127.0.0.1",
  port: 3306,
  user: "root",
  password: "",
  database: ""
});

1

connection.query("INSERT INTO <table_name> SET <field_name>=<value>");

1

connection.query("INSERT INTO <table_name> SET ?", {});