Nodejs simple method to access and operate mysql database-JS Tutorial-php.cn

Home

Web Front-end

JS Tutorial

Nodejs simple method to access and operate mysql database

不言

Jul 02, 2018 pm 04:24 PM

mysql databasenodejsoperateaccess

This article mainly introduces the simple method of nodejs to access and operate mysql database. It analyzes the related operation skills of nodejs to create mysql connection, execute sql statement and close the connection in the form of examples. Friends who need it can refer to it

The example in this article describes how nodejs can simply access and operate the mysql database. Share it with everyone for your reference, the details are as follows:

var mysql = require(&#39;mysql&#39;); //调用MySQL模块 mysql模块要安装 $ npm install mysql
//创建一个connection
var connection = mysql.createConnection({
  host   : &#39;127.0.0.1&#39;,    //主机
  user   : &#39;root&#39;,        //MySQL认证用户名
  password : &#39;&#39;,    //MySQL认证用户密码
  port: &#39;3306&#39;,          //端口号
  database:&#39;&#39;   //数据库名
});
//创建一个connection
connection.connect(function(err){
  if(err){
    console.log(&#39;[query] - :&#39;+err);
    return;
  }
  console.log(&#39;[connection connect] succeed!&#39;);
});
//执行SQL语句
connection.query(&#39;SELECT 1 + 1 AS solution&#39;, function(err, rows, fields) {
  if (err) {
    console.log(&#39;[query] - :&#39;+err);
    return;
  }
  console.log(&#39;The solution is: &#39;, rows[0].solution);
});
//关闭connection
connection.end(function(err){
  if(err){
    return;
  }
  console.log(&#39;[connection end] succeed!&#39;);
});

Note: nodejs does not need to set the encoding format of the database when operating the database set names utf8

The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

Analysis of Http module of Nodejs

How to merge two complex objects in Node.js Introduction

nodejs method to implement bigpipe asynchronous loading of pages

The above is the detailed content of Nodejs simple method to access and operate mysql database. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Python vs. JavaScript: Community, Libraries, and ResourcesApr 15, 2025 am 12:16 AM

Python and JavaScript have their own advantages and disadvantages in terms of community, libraries and resources. 1) The Python community is friendly and suitable for beginners, but the front-end development resources are not as rich as JavaScript. 2) Python is powerful in data science and machine learning libraries, while JavaScript is better in front-end development libraries and frameworks. 3) Both have rich learning resources, but Python is suitable for starting with official documents, while JavaScript is better with MDNWebDocs. The choice should be based on project needs and personal interests.

From C/C to JavaScript: How It All WorksApr 14, 2025 am 12:05 AM

The shift from C/C to JavaScript requires adapting to dynamic typing, garbage collection and asynchronous programming. 1) C/C is a statically typed language that requires manual memory management, while JavaScript is dynamically typed and garbage collection is automatically processed. 2) C/C needs to be compiled into machine code, while JavaScript is an interpreted language. 3) JavaScript introduces concepts such as closures, prototype chains and Promise, which enhances flexibility and asynchronous programming capabilities.

JavaScript Engines: Comparing ImplementationsApr 13, 2025 am 12:05 AM

Different JavaScript engines have different effects when parsing and executing JavaScript code, because the implementation principles and optimization strategies of each engine differ. 1. Lexical analysis: convert source code into lexical unit. 2. Grammar analysis: Generate an abstract syntax tree. 3. Optimization and compilation: Generate machine code through the JIT compiler. 4. Execute: Run the machine code. V8 engine optimizes through instant compilation and hidden class, SpiderMonkey uses a type inference system, resulting in different performance performance on the same code.

Beyond the Browser: JavaScript in the Real WorldApr 12, 2025 am 12:06 AM

JavaScript's applications in the real world include server-side programming, mobile application development and Internet of Things control: 1. Server-side programming is realized through Node.js, suitable for high concurrent request processing. 2. Mobile application development is carried out through ReactNative and supports cross-platform deployment. 3. Used for IoT device control through Johnny-Five library, suitable for hardware interaction.

Building a Multi-Tenant SaaS Application with Next.js (Backend Integration)Apr 11, 2025 am 08:23 AM

I built a functional multi-tenant SaaS application (an EdTech app) with your everyday tech tool and you can do the same. First, what’s a multi-tenant SaaS application? Multi-tenant SaaS applications let you serve multiple customers from a sing

How to Build a Multi-Tenant SaaS Application with Next.js (Frontend Integration)Apr 11, 2025 am 08:22 AM

This article demonstrates frontend integration with a backend secured by Permit, building a functional EdTech SaaS application using Next.js. The frontend fetches user permissions to control UI visibility and ensures API requests adhere to role-base

JavaScript: Exploring the Versatility of a Web LanguageApr 11, 2025 am 12:01 AM

JavaScript is the core language of modern web development and is widely used for its diversity and flexibility. 1) Front-end development: build dynamic web pages and single-page applications through DOM operations and modern frameworks (such as React, Vue.js, Angular). 2) Server-side development: Node.js uses a non-blocking I/O model to handle high concurrency and real-time applications. 3) Mobile and desktop application development: cross-platform development is realized through ReactNative and Electron to improve development efficiency.

The Evolution of JavaScript: Current Trends and Future ProspectsApr 10, 2025 am 09:33 AM

The latest trends in JavaScript include the rise of TypeScript, the popularity of modern frameworks and libraries, and the application of WebAssembly. Future prospects cover more powerful type systems, the development of server-side JavaScript, the expansion of artificial intelligence and machine learning, and the potential of IoT and edge computing.

See all articles