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

MySQLÊý¾Ý¿â²Ù×÷ÖÐÎÄÂÒÂë

½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
    µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë
   Ò³ÃæÖ®¼ä´«µÝ²ÎÊý³öÏÖµÄÂÒÂ룬¾ÍÒª½â¾öÒ³Ãæ±àÂëºÍrequsetµÄ×Ö·û¼¯ÎÊÌ⣬ÔÚ²ÎÊý´«½ø´«³öʱÖØÐÂÉèÖÃÏàÓ¦µÄ×Ö·û¼¯¡£±ÈÈ磺request.setCharacterEncoding("UTF-8");
3¡¢Êý¾Ý¿âÂÒÂ루ÏÂÃæÏêϸ½éÉÜ£©
¶þ¡¢Êý¾Ý¿âÂÒÂë½â¾ö·½·¨£¨Mysql£©
   Ò³ÃæºÍÒ³Ãæ´«Öµ¶¼Ã»ÓÐÎÊÌ⣬½á¹û·¢ÏÖ´æ´¢ÔÚÊý¾Ý¿âÖеÄÊý¾Ý³öÏÖÁËÂÒÂ룬ÔòÎÊÌâÊdzöÏÖÔÚÊý¾Ý¿âµÄ±àÂëÎÊÌâ¡£
   ÏÂÃæÎÒÒÑMySqlÊý¾Ý¿âΪÀý˵Ã÷½â¾ö·½·¨£º
    Èç¹ûÄã°²×°Êý¾Ý¿âµÄʱºò×Ö·û¼¯Ê¹ÓõÄĬÈÏÑ¡Ïlatin1
    DOSÃüÁîϽøÈëÊý¾Ý¿âshow Ò»ÏÂ×Ö·û¼¯£¨ÃüÁshow variables like"%char%"; £©ÏÔʾÈçÏ£º
Java´úÂë
+--------------------------+---------------+   
| Variable_name            | Value         |   
+--------------------------+---------------+   
| character_set_client     | latin1        |   
| character_set_connection | latin1        |   
| character_set_database   | latin1        |   
| character_set_filesystem | binary        |   
| character_set_results    | latin1        |   
| character_set_server     | latin1        |   
| character_set_system     | utf8&nb


Ïà¹ØÎĵµ£º

MySQL×Ö·û´®´¦Àíϵͳ

ÒÔÏÂÊÇÍêÕûµÄÀý×Ó¡£
1¡¢Ð½¨±í
#title: ×Ô¶¨Òå×Ö·û
#auther: Ð¡Ç¿(Õ¼²·Ê¦) 
#date: 
2008
-
01
-08
drop
 
table
 
if
 
exists
 Category;
create
 
table
 Category
(
   cateId       &nbs ......

mysql´æ´¢¹ý³ÌµÄ¼òµ¥Ó¦ÓÃ

¶Ômysql´æ´¢¹ý³ÌµÄ¼òµ¥Ó¦ÓÃ
Ïò±íÖвåÈëÄ£ÄâÊý¾Ý£¬¼ì²é·ÖҳЧ¹ûÊÇ·ñ³ö´í¡£
create procedure dowhile()
begin
   declare cnt INT default 0;
   while cnt<100 do
 INSERT INTO `test`.`news` (`F_ID` ,`F_TITLE` ,`F_CLASSID` ,`F_ISUP` ,`F_CONTENT` ,`F_SOURCE` ,`F_DATETIME` ,`F_RE ......

mysql ³£ÓÃÃüÁî

MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ