1、Php 乱码解决问题 制作者 ： 李亮 (飞警) E-mail : 快速查找 client （修改下面的 utf8 为 gbk）clientport=3306mysqldefault-character-set = gbk# SERVER SECTION# -# The following options will be read by the MySQL Server. Make sure that# you have installed the server correctly (see above) so it reads this # file.#mysqld# The TCP/IP
2、Port the MySQL Server will listen onport=3306#Path to installation directory. All paths are usually resolved relative to this.basedir=“C:AppServ/MySQL“#Path to the database rootdatadir=“C:AppServ/MySQL/data/“# The default character set that will be used when a new schema or table is# created and no
3、character set is defineddefault-character-set = gbkcharacter-set-server = utf8collation-server = utf8_general_ciinit_connect = SET collation_connection = utf8_general_ciinit_connect = SET NAMES utf8重新启动 mysqlstart修改系统时间快速查找 zone 修改为=prc 子查询：一条查询中包含另外一条查询语句称为子查询Select * from students where class=一班 and math=(select min(math) from students where class=一班)
