Node.js MySQL 排序

排序结果

使用 ORDER BY 语句按升序或降序对结果排序。

ORDER BY 关键字默认情况下按升序（ASC）对结果进行排序。要按降序对结果排序，请使用 DESC 关键字。

实例

按名称的字母顺序对结果排序:

var mysql = require('mysql');
var con = mysql.createConnection({
 host: "localhost",
 user: "yourusername",
 password: "yourpassword",
 database: "mydb"
});
con.connect(function(err) {
 if (err) throw err;
  con.query("SELECT * FROM customers <strong>ORDER BY name</strong>", function (err, result) {
   if (err) throw err;
  console.log(result);
 });
});

将上述代码保存在名为 "demo_db_orderby.js" 的文件中，然后运行该文件:

运行 "demo_db_orderby.js"

结果如下:

[
 { 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'}
]

降序排列

使用 DESC 关键字按降序对结果进行排序。

实例

按名称的逆字母顺序对结果排序:

var mysql = require('mysql');
var con = mysql.createConnection({
 host: "localhost",
 user: "yourusername",
 password: "yourpassword",
 database: "mydb"
});
con.connect(function(err) {
 if (err) throw err;
  con.query("SELECT * FROM customers <strong>ORDER BY name DESC</strong>", function (err, result) {
   if (err) throw err;
  console.log(result);
 });
 });

将上述代码保存在名为 "demo_db_orderby_desc.js" 的文件中，然后运行该文件:

运行 "demo_db_orderby_desc.js"

结果如下:

[
 { 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'}
]