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

mysqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö£¨×Ü½áÆª£©

 mysqlÊý¾ÝÂÒÂëÎÊÌâÔ­Òò¼°½â¾ö£¨×Ü½áÆª£©
 
µÚÒ»½â¾ö·½·¨£º
 
      ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУº£¨ÒÔutf-8ΪÀý£©
1£ºÒ³ÃæÌá½»Êý¾Ý±àÂëutf-8£¨ÕâÒ²¿ÉÒÔËãÊÇÏÔÊ¾Ò³Ãæ±àÂ룩£¬
2£ºÊý¾Ý¿âдÈëʱ±àÂ룺alter database db default character set ‘utf8’collate ‘utf8-general-ci’£¬
3£ºÊý¾Ý¿â¶ÁȡʱËùÓñàÂ룺mysql_query£¨“set names ‘utf8’”£©£»
4£ºÏÔÊ¾Ò³Ãæ±àÂ룺<meta http-equiv="Content-type"content=“text/html, charset=utf-8”>
 
 
µÚ¶þ½â¾ö·½·¨£º
½øÈëMYSQLÃüÁîÐÐ:
mysql> alter database you_dbname default character set 'utf8';
mysql> SET character_set_client='utf8';
mysql> SET character_set_connection='utf8'
mysql> SET character_set_results='utf8'
 
 
µÚÈý½â¾ö·½·¨£º
£¨ÔÝʱֻÕë¶ÔMySQL 5.0.16 ÂÒÂëÎÊÌâ´¦Àí°ì·¨£¬ÆäËû°æ±¾Î´²âÊÔ¡££©
1 ÉèÖÃphpMyAdmin
¡¡¡¡Language£ºChinese simplified (zh-utf-8)
¡¡¡¡MySQL ×Ö·û¼¯£ºUTF-8 Unicode (utf8)
¡¡¡¡MySQL Á¬½ÓУ¶Ô£ºgbk_chinese_ci
2 ´´½¨Êý¾Ý¿âʱ
¡¡¡¡ÕûÀíÉèÖÃ³É gbk_chinese_ci
3 ÓÃSQL½¨Á¢±íÖÐ
¡¡¡¡ENGINE=MyISAM DEFAULT CHARSET=gbk;
¡¡¡¡ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=40 ;
4 ¼ì²é±í½á¹¹ÖÐ
¡¡¡¡varchar(100) µÄÕûÀíÊôÐÔΪgbk_chinese_ci
¡¡¡¡ÆäËüÀàÐ͵ÄÕûÀíÊôÐÔΪ¿Õ
5 ´úÂëÖмÓÉÏ
¡¡¡¡$db->query("SET CHARACTER SET GBK"); ¡¡LinuxÏÂÐèÒª£¬Windowsϲ»ÐèÒª
¡¡¡¡Õâ¸öÏ൱ÓÚConnection Character Sets and Collations
ÒÔÉÏÊǸöÈË´ÓÍøÉÏËÑË÷µÄһЩ×ܽáºÍ¹éÄÉ£¬ÏàÐÅÕâ¸öÓ¦¸ÃÄܽâ¾öËùÓÐÂÒÂëµÄÎÊÌâÁË¡£
±¾ÎIJ¿·ÖÄÚÈÝ×ªÔØ×Ôphp100.com£¬ÈçÓÐÎÊÌ⣬ÇëÓë±¾ÈËÁªÏµ¡£


Ïà¹ØÎĵµ£º

MySQLѧϰ

»ù±¾µÄMySQLÓï¾äºÜ¼òµ¥£¬ÕâÀïÖ÷Ҫ̸̸һЩÈÝÒ×ÒÅÍüµÄ¡£
1.ÈçºÎÉèÖÃ×ֶεÝÔö
create table tb_User(Id int auto_increment
not null primary key,UserName varchar(50),Password varchar(20));
2.²é¿´±í½á¹¹
desc tb_User;
3.ÈçºÎÐ޸ıí½á
ÖØÃüÃû±í£ºalter table tb_User rename
tb_UserInfo;
Ìí¼ÓÒ»ÁУºalter ta ......

mysql Ïà¹ØÍøÖ·...

£©MySql ÖÐÎÄÍø£ºhttp://imysql.cn/onlinedoc
£©MySQL ÖÐÎÄÉçÇø £ºhttp://www.mysql.net.cn/
£©MySql °Ù¶È°Ù¿Æ£ºhttp://baike.baidu.com/view/24816.htm
²Î¿¼×ÊÁÏ£º
MySql°æ±¾¹¹¼Ü¼°Ë÷ÒýÎļþ½éÉÜ 
Linux·þÎñÆ÷ÅäÖ÷½°¸MySQL 
WinodwsÏÂIIS/Apache PHP MySQLµÄ°²×°ÅäÖà
³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ& ......

½â¶ÁOracle¼Æ»®£ºSolaris½«±»Õü¾È MySQL¼ÌÐøÇ°Í¾Î´²·


¡¾51CTO.com¶À¼ÒÌØ¸å¡¿Ãæ¶Ô¾ª»ÅµÄ¿Í»§ºÍ¹ã·ºÖÊÒɵÄýÌ壬Oracle¹Ù·½×î½üÖÕÓÚ³ö°ñ°²Ãñ£¬ÄDZãÊÇÒ»¸öÒÔ“SUN CUSTOMERS ,Oracle Plans To£º”Ϊ´ó±êÌâµÄ¹ã¸æ¡£Ö±Òë¹ýÀ´±ã¹ýÀ´¿ÉÖªµÀ£¬Oracle½«Òª¼Ó´óSPARCºÍSolarisµÄͶÈëÁË£¬¶ø´óÀϰ尣ÀïÉ­Ò²ÏòIBMÓ²¼þÏÂÁËÕ½Ê飬Éù³ÆOracle½«×îÖÕÓ®µÃÕⳡ¾ºÕù……
&n ......

MYSQLÍü¼ÇROOTÃÜÂëºó£¿

 
 MYSQLÍü¼ÇROOTÃÜÂëºó£¿
 
ÐÞ¸ÄMySQLµÄµÇ¼ÉèÖãº
1.È¡ÏûȨÏÞ¹ÜÀí
±à¼­ /mysql5.1/my.ini
ÔÚ[mysqld]µÄ¶ÎÖмÓÉÏÒ»¾ä£ºskip-grant-tables
ÀýÈ磺
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
skip-grant-tables
Ä¿µÄÊÇΪÁË£º
Ìø¹ýMySQLµÄ·ÃÎ ......

MySQLÐÔÄÜÓÅ»¯

ÔÚApache, PHP, MySQLµÄÌåϵ¼Ü¹¹ÖУ¬MySQL¶ÔÓÚÐÔÄܵÄÓ°Ïì×î´ó£¬Ò²ÊǹؼüµÄºËÐIJ¿·Ö¡£¶ÔÓÚDiscuz!ÂÛ̳³ÌÐòÒ²ÊÇÈç´Ë£¬MySQLµÄÉèÖÃÊÇ·ñºÏÀíÓÅ»¯£¬Ö±½ÓÓ°Ïìµ½ÂÛ̳µÄËٶȺͳÐÔØÁ¿£¡Í¬Ê±£¬MySQLÒ²ÊÇÓÅ»¯ÄѶÈ×î´óµÄÒ»¸ö²¿·Ö£¬²»µ«ÐèÒªÀí½âһЩMySQLרҵ֪ʶ£¬Í¬Ê±»¹ÐèÒª³¤Ê±¼äµÄ¹Û²ìͳ¼Æ²¢ÇÒ¸ù¾Ý¾­Ñé½øÐÐÅжϣ¬È»ºóÉèÖúÏÀíµÄ²ÎÊý¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ