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

MySQL¿ª·¢Ð¡½á

       ×î½üÕýÔÚ½øÐÐÒ»¸ö¶þ´Î¿ª·¢½Ó¿ÚµÄÏîÄ¿£¬ÔÚ¿ª·¢¹ý³ÌÖз¢ÏÖ£ºÎÒÃÇ֮ǰʹÓõĴ¦Àí¿Í»§¶ËºÍWEBÖ®¼ä±àÂë¼æÈÝÎÊÌâµÄ·½·¨ÊÇ´æÔÚÎÊÌâµÄ¡£ÓÉÓÚΪÁËÖ§³Ö¶àÓïÑÔ£¬Êý¾Ý¿â±íÖÐÀàÐÍΪvarcharµÄ×ֶΣ¬ËûÃǵÄ×Ö·û¼¯¶¼ÉèÖóÉÁËutf8¡£Ö®Ç°µÄ×ö·¨Êǿͻ§¶Ë½«×Ö·û´®µÄ±àÂë¸Ä³Éutf8±àÂ룬Ȼºó½«¸Ãutf8±àÂëµÄ×Ö·û´®Ö±½ÓдÈëÊý¾Ý¿â£¬ÕâÑùWEB(ʹÓÃPHPÓïÑÔ¿ª·¢µÄ)¾ÍÖ»ÐèÒª¼òµ¥µÄÐ޸ľÍÄÜÖ§³Ö¶à¹úÓïÑÔ£¬²¢ÇÒ»¹ÄܺͿͻ§¶ËµÄ¶àÓïÑÔ¼æÈÝ¡£ÓÉÓÚÎÒÃǵijÌÐòÔÚÁ¬½ÓÊý¾Ý¿âʱ£¬Ê¹ÓõÄÊÇĬÈϵÄ×Ö·û¼¯(latin1)£¬ËùÒÔµ±ÎÒÃÇÖ±½Ó²é¿´Êý¾Ý¿â±íÖеÄÊý¾Ýʱ£¬¿´µ½µÄ¾ÍÊÇÃ²ËÆÂÒÂëµÄÊý¾Ý(Õâ¾ÍÊÇ´æÈë×Ö·û´®µÄutf8±àÂë)¡£µ«µ±Ê¹ÓÃASP.NET¿ª·¢WEBʱ£¬Í¬ÑùµÄ×ö·¨¾ÍÎÞЧÁË¡£²éÔÄMySQLÊÖ²áºó£¬²ÂÏëÉèÖÃÁ¬½ÓµÄ×Ö·û¼¯¿ÉÄÜ¿ÉÒÔ½â¾öÕâ¸öÎÊÌâ¡£¾­²âÊÔ£¬È·Êµ¿ÉÐС£ÕâÀï×ܽáһϽâ¾ö·½·¨£º
1.¸ü¸ÄÁ¬½ÓµÄ×Ö·û¼¯µÄ·½·¨
MySQLÌṩÁËÁ½ÖÖ·½·¨À´¸ü¸ÄÁ¬½ÓµÄ×Ö·û¼¯£¬ÕâÁ½ÖÖ·½·¨·Ö±ðÊÇ£º
(1)SET NAMESÓï¾ä;
(2)APIº¯Êýmysql_set_character_set()
MySQLÊÖ²áÖн¨Òé×îºÃʹÓÃ(2)À´ÐÞ¸ÄÁ¬½ÓµÄ×Ö·û¼¯£¬ÒòΪ“Èç¹ûÐèÒª¸ü¸ÄÁ¬½ÓµÄ×Ö·û¼¯£¬Ó¦¸ÃʹÓÃmysql_set_character_setº¯Êý£¬¶ø²»ÊÇÖ´ÐÐSET NAMESÓï¾ä¡£mysql_set_character_setµÄ¹¤×÷·½Ê½ÀàËÆÓÚSET NAMES£¬µ«Ëü»¹ÄÜÓ°Ïìmysql_real_escape_stringËùʹÓõÄ×Ö·û¼¯£¬¶øSET NAMES²»ÄÜ¡£”
2.Ö´ÐÐmysql²åÈëÓï¾äʱ£¬·µ»Ø1366µÄ´íÎóµÄ½â¾ö°ì·¨
µ¼ÖÂÕâ¸öÎÊÌâµÄÔ­ÒòÊÇ£ºµ±½«mysqlµÄÁ¬½ÓµÄ×Ö·û¼¯¸ÄΪutf8ºó£¬Èç¹û²åÈëÊý¾Ý¿â±íÖеÄ×Ö·û´®²»ÊÇutf8±àÂëµÄ´®£¬Ôò»á³öÏÖÕâ¸ö´íÎó¡£ÔÚ½«Á¬½Ó¸ü¸ÄΪutf8ºó£¬¶Á³öÀ´µÄ×Ö·û´®Êý¾ÝÒ²ÊÇutf8±àÂëµÄ¡£ËùÒÔÎÒÐèÒª½«×Ö·û´®ÔÚutf8ºÍansiÖ®¼äÏ໥ת»»£¬×ª»»µÄÖ÷Òª´úÂëÈçÏ£º
void AnsiToUtf8(const char* szAnsi, char* szUtf8, int nSize)
{
int nChar = MultiByteToWideChar(CP_ACP, 0, szAnsi, -1, NULL, 0);
if (nChar > 0)
{
wchar_t* pBufw = new wchar_t[nChar];
MultiByteToWideChar(CP_ACP, 0, szAnsi, -1, pBufw, nChar);
WideCharToMultiByte(CP_UTF8, 0, pBufw, -1, szUtf8, nSize, NULL, NULL);
delete[] pBufw;
}
}
void Utf8ToAnsi(const char* szUtf8, char* szAnsi, int nSize)
{
int nChar = MultiByteToWideChar(CP_UTF8, 0, szUtf8, -1, NULL, 0);
if (nChar > 0)
{
wchar_t* pBufw = new wchar_t[nChar];
MultiByteToWideChar(CP_UTF8,


Ïà¹ØÎĵµ£º

Apache::DBIÓëMYsqlµÄ³ÖÐøÁ¬½ÓÌ«¶àµÄÎÊÌâ

ÎÒ¾­¹ýÕ⼸ÌìÑо¿·¢ÏÖmod_perlÌṩµÄ³ÖÐøÁ¬½Ó²¢²»ÖÇÄÜ£¨Ò²ÐíÊÇÎÒ»¹Ã»ÓÐÕÒµ½¸ü
ºÃµÄ½â¾ö·½°¸£©£¬Èç¹û½Å±¾ÖеIJÎÊýºÍ³õʼ»¯µÄ²ÎÊý²»Ò»Ñù£¬ÔÚÄÚ´æÖлá³öÏÖÁ½¸ö
¾ä±ú¡£
Apache::DBI->connect_on_init("DBI:mysql:mysql:localhost","root","root",
{
PrintError => 1,
RaiseError => 0,
AutoCommit => ......

Navicat For MySQL¼òÌåÖÐÎİæ×¢²áÂë

ÏÂÔØµØÖ·£ºhttp://download.csdn.net/down/434743/yuzhongqing2005
Navicat 8 for MySQLµÄ×¢²áÂ룺
PremiumSoft Navicat for MySQL Enterprise Edition v8.XX
ÐÕÃû(Name)£º3ddown.com
×éÖ¯(Organization)£º3ddown.com
×¢²áÂë(Serial)£ºNAVJ-W56S-3YUU-MVHV ......

MYSQLÒѾ­ÉúЧµÄÉèÖúÍ״̬²éѯÃüÁî

ÒÔÏÂÃüÁî¿ÉÒÔÔÚÈκÎÒѾ­Á¬½ÓÉÏMYSQL·þÎñÆ÷µÄ¿Í»§¶ËÉÏÖ´ÐС£
show full processlist ;
kill 57725;#ɱµôÉÏÃæ²éµ½µÄij¸öµ¼ÖÂ×èÈûµÄÁ¬½Ó
SELECT @@profiling;
SET profiling = 1;
SHOW PROFILES;
SHOW PROFILE for QUERY 1;
#ϵͳÉèÖÃ
show variables like '%key%';
show variables like '%key%';
show variables l ......

mysql ÃüÁî

²é¿´linuxÉÏÊÇ·ñ°²×°mysql
rpm -qa|grep mysql  ;Èç¹ûÓÐmysql°ü£¬±¾»úÓÐmysql£»
service mysqld status;²é¿´mysqlµÄ״̬£¬Èç¹ûΪstop״̬£¬¿ÉÒÔÓÃservice mysqld startÀ´Æô¶¯£»
怬
   mysql  -h Ö÷»úµØÖ·  -uÓû§Ãû -pÃÜÂ룻µÇ¼³É¹¦ºó½øÈëmysql״̬£»
Êý¾Ý¿â²Ù×÷
show databases£»ÏÔʾµ± ......

MySQLÓëÊÂÎñ


×÷ÕߣºÀÏÍõ
MySQL5.X¶¼ÒѾ­·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ