MySQL中是否有默认的ORDER BY值

MySQL中没有默认的ORDERBY值。您需要明确指定ORDERBY子句。以下是语法-

ORDER BY ASC; OR ORDER BY DESC;

让我们首先创建一个表-

create table DemoTable -> ( -> StudentName varchar(100) -> );

使用插入命令在表中插入一些记录-

insert into DemoTable values(Sam); insert into DemoTable values(Chris); insert into DemoTable values(David); insert into DemoTable values(Bob); insert into DemoTable values(Robert);

使用select语句显示表中的所有记录-

select *from DemoTable;

输出结果

这将产生以下输出-

+-------------+ | StudentName | +-------------+ | Sam | | Chris | | David | | Bob | | Robert | +-------------+ 5 rows in set (0.00 sec)

情况1-如果您希望结果按升序排列-

select *from DemoTable order by StudentName asc;

输出结果

这将产生以下输出-

+-------------+ | StudentName | +-------------+ | Bob | | Chris | | David | | Robert | | Sam | +-------------+ 5 rows in set (0.00 sec)

情况2-如果您希望结果按降序排列-

select *from DemoTable order by StudentName desc;

输出结果

这将产生以下输出-

+-------------+ | StudentName | +-------------+ | Sam | | Robert | | David | | Chris | | Bob | +-------------+ 5 rows in set (0.00 sec)