¹ØÓÚmysql¶ÁÈ¡¡¢Ð´Èë³öÏÖÂÒÂëµÄ½â¾ö·½·¨£¨¸öÈË×ܽᣩ
ÎÒʹÓõÄÊÇapserv°²×°°ü£¬°²×°Ê±ÓïÑÔÎÒÑ¡ÔñµÄÊÇgb2312£¬ºóÀ´ÔÚ½¨Á¢ÐµÄÊý¾Ý¿âʱ£¬‘ÕûÀí’Ñ¡ÔñµÄÊÇutf8£¬½ÓÏÂÀ´ÔÚ±íÖвÎÊýÀàÐÍ»ù±¾Ñ¡ÔñµÄ¶¼ÊÇutf8£¬½ÓÏÂÀ´ÎÒ¾ÍÖ±½Óµ÷ÓÃÀ²£¬¸Â¸Â£¬ÎÒдµÄÊÇÒ»¸ö¼òµ¥µÄÁôÑÔ±¾¡£×î¼òµ¥µÄ¶ÁÈ¡Êý¾Ý¿âдÈëÊý¾Ý¿âµÄ³ÌÐò£¬¸Â¸Â£¡Ææ¹ÖµÄÊÇÔÚÊý¾Ý¿âÀïÃæÖ±½Ó²Ù×÷ÖÐÎÄÏÔʾ¶¼ºÜÕý³£¡£¿ÉÊÇÒ»µ½ÍøÒ³É϶ÁÈ¡ÁôÑÔÐÅϢʱ£¬ÖÐÎÄÈ«²¿ÊÇÎʺţ¿£¬È»ºóÎÒÓÖÊÔ×Åд³öдÁôÑÔ´úÂëÊÔÊÔ¿´£¬orz£¬¶Á½øÈ¥µÄ¶¼ÊÇÄǸö²»ÖªµÀʲô·ûºÅ¡£¡£¡£
ÓÚÊǺõÎÒ¾ÍÈ¥ÍøÉÏ·Ì츲µØµÄÕÒÁ˺þã¬ÖÕÓÚKOÁËÕâ¸öÎÊÌ⣬¸Â¸Â¡£
Ê×ÏÈÉùÃ÷±¾È˳õѧ£¬Ö»Äܱ£Ö¤ÎÒÕâÖÖ·½·¨ÊÇÄܹ»½â¾ö¶ÁȡдÈëÂÒÂëµÄ¡£µ«ÊDz»´ú±íÖ»ÄÜÕâÑù×ö¡£¡£¡£
ÎҵĽâ¾ö·½·¨ÈçÏ£º
1.my.iniÎļþÖеÄ
[mysql]
default-character-set = utf8 //´Ë´¦ÉèÖÃΪutf8,×¢Òâ²»ÊÇutf-8
2.ÔÚÁ¬½ÓÊý¾Ý¿âÑ¡Ôñ±íÖ®ºó£¬²Ù×÷Êý¾Ýǰ£¬Ìí¼ÓÒ»¾ä mysql_query("SET NAMES 'GB2312'");
¸Â¸Â£¬1²»È·¶¨ÊDz»ÊDZØÒªµÄ£¬µ«ÊÇÎÒÈ·¶¨2ÊDZØÒªµÄ£¬ÆäËûµÄ¾ÍÊÇÔÚ±íÖÐÊý¾Ý¾¡Á¿²ÉÓÃutf8.
ÕâÑùÎÊÌâ¾Í½â¾öÀ²£¡
ºÃ£¬Õ¹Ê¾Ï¸öÈËдµÄµÚÒ»¸ö³¬³¬³¬³¬¼òµ¥µÄÁôÑÔ±¾³ÌÐò£¬¸Õѧphp£¬Ã»×ö¸ñʽ¿ØÖÆ£¬´ó¼Ò±ðЦ»°¡£ÕâÊÇ´¿ÊÖдŶ£¡
/*Ê×Ò³¶ÁÈ¡ÁôÑÔÐÅÏ¢µÄ´úÂëindex.php*/
<?php include("include/config.php");?>
<?PHP include("include/head.php");?>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ÁôÑÔ±¾</title>
</head>
<body>
<p>
<?php include("include/conn.php");
$q = "SELECT * from lyb";
mysql_query("SET NAMES 'GB2312'"); // ·ÀÖ¹³öÏÖÂÒÂë
?>
<?
$rs = mysql_query($q, $dbh);
/*Êä³öÊý¾Ý²¢·ÖÐÐ*/
while($row = mysql_fetch_array($rs)) echo "ÐòºÅ$row[id] ÐÕÃû:$row[name] qq:$row[qq] ÄÚÈÝ:$row[content]<br/>";
?>
<?php include("include/foot.php")?>
</p>
<p><a href="input2.php">дÁôÑÔ</a></p>
/*input2.phpÖÁÓÚΪʲôȡÃûΪ2£¬ÒòΪÉèÖÃÁËÁ½ÖÖдÈëÒ³Ãæ£¬¸Â¸Â*/
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ÁôÑÔ</title>
</head>
<body>
<form method="post" action
Ïà¹ØÎĵµ£º
MySQLÊÇÎÒÃDZȽϳ£ÓõÄÒ»ÖÖÊý¾Ý
¿âÈí¼þ¡£ËüÓÐ×ÅÖî¶àµÄÓŵ㣬È翪ԴµÄ£¬Ãâ·ÑµÄµÈµÈ¡£ÆäʵËü»¹ÓÐÒ»¸öºÜºÃµÄÌØµã£¬ÄǾÍÊÇÓжàÖÖÒýÇæ¿ÉÒÔ¹©ÄãÑ¡Ôñ¡£Èç¹ûÈü
³µÊÖÄܸù¾Ý²»Í¬µÄ·¿ö£¬µØÐÎËæÊÖ¸ü»»ÓëÖ®×îÊÊÒ˵ÄÒýÇæ£¬ÄÇôËûÃǽ«´´ÔìÆæ¼£¡£È»¶øÄ¿Ç°ËûÃÇ»¹×ö²»µ½ÄÇÑù±ã½ÝµÄ¸ü»»ÒýÇæ£¬µ«ÊÇÎÒÃÇÈ´¿ÉÒÔ£¡
Ëù ......
¡¡¡¡ÒÔMySQL-server-4.0.14-0.i386.rpmΪÀý£¬·ÅÔÚ/dataĿ¼ÏÂ
¡¡¡¡cd /data
¡¡¡¡rpm -ivh MySQL-server-4.0.14-0.i386.rpm
¡¡¡¡°²×°Íê³ÉºóÔÚ/usr/share/mysqlĿ¼ÖлáÓÐÒ»¸ömysqlµÄÆô¶¯½Å±¾mysql.server¼°Ê¾ÀýÅäÖÃÎļþµÈ(Èçmy-huge.cnf¡¢my-large.cnf¡¢my-medium.cnf)
¡¡¡¡¿½±´Ò»¸öʾÀýÅäÖÃÎ ......
½ñÌ죬ҪÓÃexplain²é¿´mysqlµÄÖ´Ðй滮£¬µ«ÊǺÍPostgreSQL²»Í¬µÄÊÇ£¬Ö±½ÓÔÚmysqlÀïÃæÖ´ÐеĽá¹û¿É¶ÁÐÔ²»ÊǺܺã¬ÉÏÍøËÑÁËһȦ£¬·¢ÏÖÁËÒ»¸ö¹¤¾ßmaatkit£¬¿ÉÒÔ½²explainµÄ½á¹ûת»¯ÎªÊ÷×´½á¹¹²é¿´£¬ºÇºÇ£¬·½±ãÁ˺ܶà
°²×°°ì·¨£º
1. sudo yum install mysql
2. sudo yum install mysql-server
3. wget http://maatkit.googl ......
ÔÚWindowsXPÖдò¿ªDOS£¬Í¨¹ýÊäÈëÃüÁî“mysql -u root -p”Çл»µ½mysqlÏ£¬Çл»Ê§°Ü£¬ÈçÏÂËùʾ£º
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\>mysql -u root -p
'mysql' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò
»òÅú´¦ÀíÎļþ¡£
......
from:http://www.ccvita.com/100.html
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1 ......