Preliminary use of Node to connect to Mysql database_node.js
Using Node for web page development is basically to connect to the non-relational database mongodb. Here I tried to connect to the mysql database first, because mongodb is too unfamiliar compared to mysql, and I wanted to get the page out quickly, so I chose Relatively familiar with some mysql.
1. Install mysql
Download MySQL:MySQL Downloads and install it. After installation, you will be guided to configure the database, set the root password and create a normal user and password.
2. Install Node-mysql
Install the mysql software package through npm, which allows you to quickly call functions to connect to the mysql database. Enter the project folder and execute npm install mysql --save.
After installation, the mysql directory will be generated in the node_modules directory of the project folder.
3. View readme document
Enter the mysql directory and view the README document. This step is very important. Do not search on Baidu and Google for how to use it, because due to different versions, the answer you get may not allow you to successfully connect to the database. After all, Node is developing so fast.
If you read the README document carefully, you don’t need to read the next steps to avoid misleading you due to inconsistent versions.
4. Connect to mysql database
Enter the project document, create a new TestMysql.js example, and write the following code:
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
if (err) throw err;
console.log('The solution is: ', rows[0].solution);
});
connection.end();
Basic connection parameters
- host host name, localhost represents local
- user Mysql user
- password password
- database connected database
client.connect() connects to the database
client.query() executes SQL statement
client.end() closes the connection.
Then execute the program through node TestMysql.js, making sure you have started the Mysql service before executing.
5. Add, delete, modify and check
Using a database is nothing more than adding, deleting, modifying, and checking. The following example may be helpful to you.
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret',
database : 'my_db'
});
connection.connect();
// 增加记录
client.query('insert into test (username ,password) values ("lupeng" , "123456")');
// 删除记录
client.query('delete from test where username = "lupeng"');
// 修改记录
client.query('update test set username = "pengloo53" where username = "lupeng"');
// 查询记录
client.query("select * from test" , function selectTable(err, rows, fields){
if (err){
throw err;
}
if (rows){
for(var i = 0 ; i < rows.length ; i++){
console.log("%d\t%s\t%s", rows[i].id,rows[i].username,rows[i].password);
}
}
});
connection.end();
At this point, the initial connection to the Mysql database has come to an end, and you can then use it in the Node project.
Hope everyone will continue to pay attention.
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
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1378
52
How do I create and publish my own JavaScript libraries?
Mar 18, 2025 pm 03:12 PM
Article discusses creating, publishing, and maintaining JavaScript libraries, focusing on planning, development, testing, documentation, and promotion strategies.
How do I optimize JavaScript code for performance in the browser?
Mar 18, 2025 pm 03:14 PM
The article discusses strategies for optimizing JavaScript performance in browsers, focusing on reducing execution time and minimizing impact on page load speed.
What should I do if I encounter garbled code printing for front-end thermal paper receipts?
Apr 04, 2025 pm 02:42 PM
Frequently Asked Questions and Solutions for Front-end Thermal Paper Ticket Printing In Front-end Development, Ticket Printing is a common requirement. However, many developers are implementing...
How do I debug JavaScript code effectively using browser developer tools?
Mar 18, 2025 pm 03:16 PM
The article discusses effective JavaScript debugging using browser developer tools, focusing on setting breakpoints, using the console, and analyzing performance.
How do I use source maps to debug minified JavaScript code?
Mar 18, 2025 pm 03:17 PM
The article explains how to use source maps to debug minified JavaScript by mapping it back to the original code. It discusses enabling source maps, setting breakpoints, and using tools like Chrome DevTools and Webpack.
Who gets paid more Python or JavaScript?
Apr 04, 2025 am 12:09 AM
There is no absolute salary for Python and JavaScript developers, depending on skills and industry needs. 1. Python may be paid more in data science and machine learning. 2. JavaScript has great demand in front-end and full-stack development, and its salary is also considerable. 3. Influencing factors include experience, geographical location, company size and specific skills.
Getting Started With Chart.js: Pie, Doughnut, and Bubble Charts
Mar 15, 2025 am 09:19 AM
This tutorial will explain how to create pie, ring, and bubble charts using Chart.js. Previously, we have learned four chart types of Chart.js: line chart and bar chart (tutorial 2), as well as radar chart and polar region chart (tutorial 3). Create pie and ring charts Pie charts and ring charts are ideal for showing the proportions of a whole that is divided into different parts. For example, a pie chart can be used to show the percentage of male lions, female lions and young lions in a safari, or the percentage of votes that different candidates receive in the election. Pie charts are only suitable for comparing single parameters or datasets. It should be noted that the pie chart cannot draw entities with zero value because the angle of the fan in the pie chart depends on the numerical size of the data point. This means any entity with zero proportion
The difference in console.log output result: Why are the two calls different?
Apr 04, 2025 pm 05:12 PM
In-depth discussion of the root causes of the difference in console.log output. This article will analyze the differences in the output results of console.log function in a piece of code and explain the reasons behind it. �...
