当前位置:Gxlcms > 数据库问题 > MYSQL 比较集

MYSQL 比较集

时间:2021-07-01 10:21:17 帮助过:22人阅读

    -> cc char(10));
insert into ss values (null,"a");
insert into ss values (null,"A");
insert into ss values (null,"b");
insert into ss values (null,"B");
-------------------------------------------------------------
mysql> select * from ss order by cc asc;
+----+------+
| id | cc   |
+----+------+
|  1 | a    |
|  2 | A    |
|  3 | b    |
|  4 | B    |
+----+------+
 mysql> select * from ss order by cc desc;
+----+------+
| id | cc   |
+----+------+
|  3 | b    |
|  4 | B    |
|  1 | a    |
|  2 | A    |

MYSQL 比较集

标签:prim   cti   dem   一个   key   字符集   rom   lin   mysq   

人气教程排行