Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ

¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ
ת×Ô http://blog.chinaunix.net/u/29134/showart_1316574.html
1¡¢É÷ÖØÑ¡Ôñ±íÃû¡£
ÓÐÁ½ÖÖÑ¡Ôñ£º
°´ÕÕ¶àÊý¿ª·¢ÓïÑÔµÄÃüÃû¹æÔò¡£±ÈÈ磨myCustomer£©¡£
°´ÕÕ¶àÊý¿ªÔ´Ë¼ÏëÃüÃû¹æÔò¡£±ÈÈ磨my_customer£©¡£
°´ÕÕÔÛÃÇÖйúÈ˵Ä˼Ïë¡£±ÈÈ磨ÎҵĿͻ§£©¡£
µÚÒ»ÖÖÓиöȱµã£¬ºÜÈÝÒ×Íüµô´óдµÄ×Ö ......

MYSQL ÄÚ´æ»úÖÆ


¶ÔÓÚÈκÎÒ»¸öÊý¾Ý¿â¹ÜÀíϵͳÀ´Ëµ£¬ÄÚ´æµÄ·ÖÅäʹÓþø¶Ô¿ÉÒÔËãµÄÉÏÊÇÆäºËÐÄÖ®Ò»ÁË£¬ËùÒԺܶàÏ£Íû¸üΪÉîÈëÁ˽âijÊý¾Ý¿â¹ÜÀíϵͳµÄÈË£¬¶¼»áÏ£ÍûÒ»¿ú¾¿¾¹£¬ÎÒÒ²²»ÀýÍâ¡£   
  
´ÓÄÚ´æµÄʹÓ÷½Ê½MySQL Êý¾Ý¿âµÄÄÚ´æÊ¹ÓÃÖ÷Òª·ÖΪÒÔÏÂÁ½Àà   
  
  
Ï̶߳ÀÏíÄÚ´æ&nb ......

Windows Ï Apache Mysql PHP µÄ°²×°

Ò»  Apache µÄ°²×°
 1  Apache µÄ°²×°
2 ͬÒâЭÒé
3 ½Ó×Å "Next "
4  Ìîд ÓòÃû(network domain) ·þÎñÆ÷µÄÃû³Æ (Server Name) ¹ÜÀíÕßÓÊÏä(Administrator's Email)
5 °²×°ÀàÐÍ
6 Ñ¡Ôñ°²×°Â·¾¶
7 µã»÷“install ” ¼ÌÐø
8 ¿ªÊ¼°²×°
9  °²×°½áÊø
¶þ   MySqlµÄ°²×° ......

MySQLÒýÇæ

¡¡MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ÒâµÄ»°£¬ÄãÉõÖÁ¿ÉÒÔʹÓÃMySQL++ APIÀ´´´½¨×Ô¼ºµÄÊý¾Ý¿âÒýÇæ£¬¾ÍÏñ´ò´©Æø¸××°ÉÏ×Ô¼ºµÄ»¯ÓÍÆ÷¡£ÏÖÔÚÈÃÎÒÃÇÀ´¿´¿´Äã¸ÃÈçºÎÑ¡ÔñÒýÇæ£¬ÒÔ¼°ÈçºÎÔÚ¿ÉÓÃÒýÇæÖ®¼äÇл»¡£
¡¡¡¡
¡¡¡¡Ñ¡ÔñÄãµÄÒýÇæ
¡¡¡¡
¡¡¡¡ÄãÄÜÓõÄÊý¾Ý¿ ......

MySql時間º¯數


Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQL Öл¹ÓÐÏÂÃæµÄº¯Êý£º
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ