Discuss / SQL / SELECT id, name, gender, score FROM students ORDER BY name;

SELECT id, name, gender, score FROM students ORDER BY name;

Topic source

长宁特产

#1 Created at ... [Delete] [Delete and Lock User]

按UINICODE排的,亲测

廖雪峰

#2 Created at ... [Delete] [Delete and Lock User]

字符串排序要注意,数据库可以指定排序的编码,所以并不一定总是按unicode排序,要看建表的设定

小盆友-z

#3 Created at ... [Delete] [Delete and Lock User]

安装MYSQL时,写的imi文件里可以指定编码方式


  • 1

Reply