查询中文按照拼音排序
select id,name from product_ringtone_album order by CONVERT( name USING gbk ) COLLATE gbk_chinese_ci ASC
python连接MySql ,先安装python2Mysql库
import MySQLdb
conn = MySQLdb.connect (host = "localhost",
user = "testuser",
passwd = "testpass",
db = "test")
cursor = conn.cursor ()
cursor.execute ("SELECT VERSION()")
row = cursor.fetchone ()
print "server version:", row[0]
cursor.close ()
conn.close ()