NodeJS link to MySql database method

//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 link

mysqlConnection.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!