This time I will bring you how to connect node to mysql. What are the precautions to connect node to mysql? The following is a practical case, let’s take a look.
Mysql basic commandsChange root password 123 to 1234mysqladmin -u root -p 123 password 1234;Display database
show databases;
Create database, for example:
create database database_test create database [database];Use the database, for example:
use database_test use [database];Delete the database, for example:
drop database database_test drop database [database];Create a table, for example:
create table_test(name char(10) not null,age int(4)) create table <table>(<field><type>);
Insert data, For example:
insert into table_test (name,age) values ('vist',24) insert into <table>(<field>) values (<value>);Query data, for example:
select * from table_test select * from <table>;Modify data, for example:
update table_test set age=18 where name='vist' update <table> set <fidld>=<value> where <if>;Delete data, for example:
delete from table_test where name='vist' delete from <table> where <if>; node配置Need to install the mysql package
npm install mysqlnode
var mysql=require('mysql');var database='database_test';var table='table_test';Configure user password
var client=mysql.createConnection({ user: 'root', passowrd: '1234' });Connect to the database
client.connect();console.log('连接数据库');Use the database
client.query('use '+ database);Query operation
client.query('select * from '+ table , function(err, results, fields){ if(err){ throw err; } if(results){ console.log('查询'); results.map(function(item){ console.log('%s\t%d', item.name, item.age); }) } });Insertion operation
client.query('insert into '+ table + '(name, age) values (?, ?)', ['bestvist',20], function(err, results, fields){ if(err){ throw err; } if(results){ console.log('插入'); console.log(results); } });Update operation
client.query('update '+ table + ' set age=? where name=?',[18, 'bestvist'],function(err, results, fields){ if(err){ throw err; } if(results){ console.log('更新'); console.log(results); } });Delete operation
client.query('delete from '+ table +' where name=?', ['bestvist'], function(err, results, fields){ if(err){ throw err; } if(results){ console.log('删除'); console.log(results); } })Close database
client.end();I believe you have read the case in this article You have mastered the method. For more exciting information, please pay attention to other related articles on the php Chinese website! Recommended reading:
Use JS to implement sorting algorithm
JS regular expressionHow to use
The above is the detailed content of How to implement node connection to mysql. For more information, please follow other related articles on the PHP Chinese website!

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.

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.

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

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

JavaScript is the cornerstone of modern web development, and its main functions include event-driven programming, dynamic content generation and asynchronous programming. 1) Event-driven programming allows web pages to change dynamically according to user operations. 2) Dynamic content generation allows page content to be adjusted according to conditions. 3) Asynchronous programming ensures that the user interface is not blocked. JavaScript is widely used in web interaction, single-page application and server-side development, greatly improving the flexibility of user experience and cross-platform development.

Python is more suitable for data science and machine learning, while JavaScript is more suitable for front-end and full-stack development. 1. Python is known for its concise syntax and rich library ecosystem, and is suitable for data analysis and web development. 2. JavaScript is the core of front-end development. Node.js supports server-side programming and is suitable for full-stack development.


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

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

WebStorm Mac version
Useful JavaScript development tools