MySQL ORDER BY排序ASC DESC 用法

在命令提示符中使用 ORDER BY 子句

mysql> use RUNOOB;
Database changed
mysql> SELECT * from runoob_tbl ORDER BY submission_date ASC;

mysql> SELECT * from runoob_tbl ORDER BY submission_date DESC;

在 PHP 脚本中使用 ORDER BY 子句

<?php
$dbhost = 'localhost';  // mysql服务器主机地址
$dbuser = 'root';            // mysql用户名
$dbpass = 'www.dgkunfu.com';          // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
    die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'SELECT runoob_id, runoob_title,
        runoob_author, submission_date
        FROM runoob_tbl
        ORDER BY  submission_date ASC';
 

$sql = 'SELECT runoob_id, runoob_title,
        runoob_author, submission_date
        FROM runoob_tbl
        ORDER BY  submission_date DESC';