Source Server : local Source Server Version : 50022 Source Host : localhost:3306 Source Database : test
Target Server Type : MYSQL Target Server Version : 50022 File Encoding : 65001
Date: 2012-11-19 15:46:13 */
復(fù)制代碼 代碼如下:
SET FOREIGN_KEY_CHECKS=0;
-- ---------------------------- -- Table structure for `person` -- ---------------------------- DROP TABLE IF EXISTS `person`; CREATE TABLE `person` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ---------------------------- -- Records of person -- ---------------------------- INSERT INTO `person` VALUES ('1', '張三'); INSERT INTO `person` VALUES ('2', '李四'); INSERT INTO `person` VALUES ('3', '王五'); INSERT INTO `person` VALUES ('4', '馬六'); INSERT INTO `person` VALUES ('5', '錢七');
正序：
復(fù)制代碼 代碼如下:
select * from person ORDER BY CONVERT(name USING gbk);
結(jié)果： 2 李四 4 馬六 5 錢七 3 王五 1 張三
倒序：
復(fù)制代碼 代碼如下:
select * from person ORDER BY CONVERT(name USING gbk) desc
