EN
Node.js - MySQL ORDER BY
0 points
In this article, we would like to show you how to use SQL ORDER BY in Node.js.
Note: at the end of this article you can find database preparation SQL queries.
xxxxxxxxxx1
const mysql = require('mysql');2
3
const connection = mysql.createConnection({ // gets connection with database4
host: 'localhost', // '127.0.0.1'5
user: 'root',6
password: 'password',7
database: 'my_database',8
});9
10
connection.connect(error => {11
if (error) throw error;12
const query = 'SELECT * ' + 13
'FROM `users` ' +14
'ORDER BY ??';15
const value = ['name']; // SELECT * FROM `users` ORDER BY `name`16
17
connection.query(query, value, (error, result) => { // sends queries and receives results18
connection.end(); // closes connection19
if (error) throw error;20
console.log(result);21
});22
});Result:
xxxxxxxxxx1
[2
{ id: 2, name: 'Chris', role: 'moderator' },3
{ id: 4, name: 'Denis', role: 'moderator' },4
{ id: 1, name: 'John', role: 'admin' },5
{ id: 3, name: 'Kate', role: 'user' }6
]xxxxxxxxxx1
const mysql = require('mysql');2
3
const connection = mysql.createConnection({ // gets connection with database4
host: 'localhost', // '127.0.0.1'5
user: 'root',6
password: 'password',7
database: 'my_database',8
});9
10
connection.connect(error => {11
if (error) throw error;12
const query = 'SELECT * ' + 13
'FROM `users` ' +14
'ORDER BY ?? DESC';15
const value = ['id']; // SELECT * FROM `users` ORDER BY `id` DESC16
17
connection.query(query, value, (error, result) => { // sends queries and receives results18
connection.end(); // closes connection19
if (error) throw error;20
console.log(result);21
});22
});Result:
xxxxxxxxxx1
[2
{ id: 4, name: 'Denis', role: 'moderator' },3
{ id: 3, name: 'Kate', role: 'user' },4
{ id: 2, name: 'Chris', role: 'moderator' },5
{ id: 1, name: 'John', role: 'admin' }6
]create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE `users` (2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`name` VARCHAR(100) NOT NULL,4
`role` VARCHAR(15) NOT NULL,5
PRIMARY KEY (`id`)6
)7
ENGINE=InnoDB;insert_data.sql file:
xxxxxxxxxx1
INSERT INTO `users`2
(`name`, `role`)3
VALUES4
('John', 'admin'),5
('Chris', 'moderator'),6
('Kate', 'user'),7
('Denis', 'moderator');