Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL ÃüÁîÐÐ ÖÐÎÄÂÒÂë

Óöµ½Ò»¸öÎÊÌâÊÇÔÚMySQLÃüÁîÐвåÈëÖÐÎÄÊý¾Ý»òÕß²éѯÖÐÎÄÊý¾Ýʱ³öÏÖÂÒÂ룬»òÕßÏÔʾ²»¶Ô¡£
 
ÔÚÃüÁîÐÐÊäÈë:show variables like ‘character_set_%’;
 
²é¿´µ±Ç°ÅäÖõıàÂ룻
 
 
ÔÚÃüÁîÐÐÊäÈë :set names utf8;
ÔòµÈͬÓÚ
set character_set_client=utf8;
set character_set_results=utf8;
set character_set_connection=utf8;
ÕâÈýÌõÃüÁî
 
 ÔÚÃüÁîÐвåÈëÊý¾Ý֮ǰ
Ö´ÐÐÃüÁîset names gbk;»òÕßset names gb2312;
ÔÙ²åÈë
 
²éѯÊý¾Ý֮ǰ
Ö´ÐÐÃüÁîset names gbk;»òÕßset names gb2312;
 
 
ÍêÁËÖ®ºóÔÙset names utf8;
ÕâÑù¾ÍÄÜÕý³£²åÈëºÍ²éѯÖÐÎIJ¢ÇÒ±£³ÖÊý¾Ý¿â±àÂëΪutf8
 
 
 
 
 


Ïà¹ØÎĵµ£º

Á¬½ÓMysqlÊý¾Ý¿âС³£Ê¶

1.¼ÓÔØmysqlÇý¶¯°üProperties->java Build Path->Libraries->Add External JARs...
2.Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Êý¾Ý¿âÃû?user=root&password=ÃÜÂë"); ......

FreeBSDÀûÓÃports°²×°MySQL+Apache+PHP

ʹÓÃPorts·½Ê½ÔÚFreeBSDÏÂÅäÖÃMySQL,Apache,PHP
ÓôÃÆÁ˺ü¸Ìì,ÖÕÓÚÔÚFreeBSDϽ«MySQL,Apache,PHPµÄ»·¾³ÅàÖ²ºÃÁË.ϱ߰ÑÅäÖò½ÖèºÍ×¢ÒâµãÂÞÁÐÔÚϱß,ºÍ´ó¼Ò·ÖÏí.
 
 FreeBSD°æ±¾ÊÇ7.3,MySQL°æ±¾ÊÇ5.0.90,Apache°æ±¾ÊÇ2.2.14£¨1.3.42£©,PHP°æ±¾ÊÇ5.2.12.Îҵݲװ˳ÐòÊÇÏÈMySQL,È»ºó°²×°ApacheºÍPHP,Ò»°ãÊǰ²×°Í ......

Windows Ï Apache Mysql PHP °²×°ºóµÄÅäÖÃ

1 Apache
Ð޸Ġ  documentroot   ¸ùĿ¼
         directory           ·ÃÎʸùĿ¼ȨÏÞ
         directoryindex   Ä¬ÈÏÊ×Ò³ ......

MySQL²éѯ±íÄÚÖØ¸´¼Ç¼

MySQL²éѯ±íÄÚÖØ¸´¼Ç¼
 
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×Ö¶Î ......

VC++ÔÚWindowsƽ̨Á¬½ÓMySqlÊý¾Ý¿â

       ÒÔǰÓùßÁËMSSQL£¬VC++ÓÐÇ¿´óµÄADOÖ§³Ömssql£¬·½±ã°¡£¬²»¹ÜÊÇÁ¬½Ó£¬²Ù×÷µÈ¶¼ÊÇÀÊÀÊÉÏÊÖ°¡¡£µ«ÊÇÏÖÔÚͻȻҪÓÃMySqlÁË£¬¿ªÊ¼Ã»ÓÐmssqlÄÇÑùµÄ²Ù×÷½çÃæ£¬ÎÒÕæÓеãÅų⡣°¥£¬Ã»°ì·¨£¬¹«Ë¾ÒªÇó£¬Ö»ÄÜÑо¿MySqlÔõôÓÃÁË¡£
       ¸Õ¿ªÊ¼¾ÍÓöµ½ÁËÒ»¸ö»ù±¾µÄÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ