Flash cards
Review the key moves
What is the main idea behind Node.js MySQL Order By?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
Which statement best captures the main point of this lesson?
Complete the missing token from the example code.
___ mysql = require('mysql');Put the learning moves in the order that makes the concept easiest to apply.
Sort the Result
Use the ORDER BY statement to sort the result in ascending or descending order.
The ORDER BY keyword sorts the result ascending by default. To sort the result in descending order, use the DESC keyword.
Sort the result alphabetically by name
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost", user: "yourusername",
password: "yourpassword", database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
con.query("SELECT * FROM customers ORDER BY name ", function (err, result) {
if (err) throw err;
console.log(result);
});
});Save the code above in a file called "demo_db_orderby.js" and run the file:
Run "demo_db_orderby.js"
C:\Users\
Your Name
>node demo_db_orderby.jsWhich will give you this result
[ { id: 3, name: 'Amy', address: 'Apple st 652'},
{ id: 11, name: 'Ben', address: 'Park Lane 38'}, { id: 7, name: 'Betty', address: 'Green Grass 1'}, { id: 13, name: 'Chuck', address: 'Main Road 989'}, { id: 4, name: 'Hannah', address: 'Mountain 21'}, { id: 1, name: 'John', address: 'Higheay 71'}, { id: 5, name: 'Michael', address: 'Valley 345'}, { id: 2, name: 'Peter', address: 'Lowstreet 4'}, { id: 8, name: 'Richard', address: 'Sky st 331'},
{ id: 6, name: 'Sandy', address: 'Ocean blvd 2'}, { id: 9, name: 'Susan', address: 'One way 98'}, { id: 10, name: 'Vicky', address: 'Yellow Garden 2'}, { id: 14, name: 'Viola', address: 'Sideway 1633'}, { id: 12, name: 'William', address: 'Central st 954'}
]Order By Desc
Use the DESC keyword to sort the result in a descending order.
Example
Sort the result reverse alphabetically by name:
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost", user: "yourusername",
password: "yourpassword", database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
con.query("SELECT * FROM customers ORDER BY name DESC ", function (err, result) {
if (err) throw err;
console.log(result);
});
});Save the code above in a file called "demo_db_orderby_desc.js" and run the file:
Run "demo_db_orderby_desc.js"
C:\Users\
Your Name
>node demo_db_orderby_desc.jsWhich will give you this result
[ { id: 12, name: 'William', address: 'Central st 954'}, { id: 14, name: 'Viola', address: 'Sideway 1633'}, { id: 10, name: 'Vicky', address: 'Yellow Garden 2'}, { id: 9, name: 'Susan', address: 'One way 98'},
{ id: 6, name: 'Sandy', address: 'Ocean blvd 2'}, { id: 8, name: 'Richard', address: 'Sky st 331'}, { id: 2, name: 'Peter', address: 'Lowstreet 4'}, { id: 5, name: 'Michael', address: 'Valley 345'}, { id: 1, name: 'John', address: 'Higheay 71'}, { id: 4, name: 'Hannah', address: 'Mountain 21'}, { id: 13, name: 'Chuck', address: 'Main Road 989'}, { id: 7, name: 'Betty', address: 'Green Grass 1'},
{ id: 11, name: 'Ben', address: 'Park Lane 38'}, { id: 3, name: 'Amy', address: 'Apple st 652'}
]