//1. Use the npm command to install the mysql module
npm install mysql
//2.Introduce the mysql module into the .js file
const mysqlModule = require('mysql');
//3. Create a mysql link object
const mysqlConnection = mysqlModule.createConnection({
Host: The database address to connect to. (Default: localhost)
Port: The port corresponding to the connection address. (Default: 3306)
LocalAddress: The source IP address uses TCP. Connection. (Optional)
socketPath: When the host and port parameters are ignored, you can fill in a Unix Socket address
user: mysql connection user name. ## Password: The password of the corresponding user.
Database: The name of the database to be connected. (Optional)
Charset: This is the encoding format in mysql. For example: utf8_general_ci) If specified, it is used as the default sorting rule (Default: utf8_general_ci)
Timezone: Used to save the current local time zone (Default: local)
ConnectTimeout: Set the time after which a failure will be returned if no response occurs during the connection. (Default: 10000)
StringifyObjects: stringify object instead of the conversion value issue# 501 (Default: false)
insecureAuth. : Use the old (unsafe) connection method to connect to MySQL. (Default: false)
typeCast: Determine whether the column value needs to be converted to a native JavaScript type. (Default: true)
queryFormat. : Custom query method. Address: Custom format .
SupportBigNumbers: If you use BIGINT and DECIMAL format table columns, you need to enable this parameter to support (default: false) only if they exceed JavaScript. When the longest byte that can be expressed, if this parameter is not set, the too long number will be passed as a string. Otherwise, the length of the object is returned. If the supportBigNumbers parameter is omitted, this parameter will also be ignored.
DateStrings: Some date types (TIMESTAMP, DATETIME, DATE) will be returned as Strings and then converted into JavaScript date objects. (Default: false)
Debug: Whether to print the connection status to a file. (Default: false)
Trace: Generate a stack trace of the error, including the call location of the library entry ("long stack trace"). There is generally a slight performance penalty. (Default: true)
});
//4. Open the mysql linkmysqlConnection.connect();
The above is the detailed content of NodeJS link to MySql database method. For more information, please follow other related articles on the PHP Chinese website!

去掉重复并排序的方法:1、使用“Array.from(new Set(arr))”或者“[…new Set(arr)]”语句,去掉数组中的重复元素,返回去重后的新数组;2、利用sort()对去重数组进行排序,语法“去重数组.sort()”。

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于Symbol类型、隐藏属性及全局注册表的相关问题,包括了Symbol类型的描述、Symbol不会隐式转字符串等问题,下面一起来看一下,希望对大家有帮助。

怎么制作文字轮播与图片轮播?大家第一想到的是不是利用js,其实利用纯CSS也能实现文字轮播与图片轮播,下面来看看实现方法,希望对大家有所帮助!

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于对象的构造函数和new操作符,构造函数是所有对象的成员方法中,最早被调用的那个,下面一起来看一下吧,希望对大家有帮助。

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于面向对象的相关问题,包括了属性描述符、数据描述符、存取描述符等等内容,下面一起来看一下,希望对大家有帮助。

方法:1、利用“点击元素对象.unbind("click");”方法,该方法可以移除被选元素的事件处理程序;2、利用“点击元素对象.off("click");”方法,该方法可以移除通过on()方法添加的事件处理程序。

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于BOM操作的相关问题,包括了window对象的常见事件、JavaScript执行机制等等相关内容,下面一起来看一下,希望对大家有帮助。

foreach不是es6的方法。foreach是es3中一个遍历数组的方法,可以调用数组的每个元素,并将元素传给回调函数进行处理,语法“array.forEach(function(当前元素,索引,数组){...})”;该方法不处理空数组。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools
