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

MySQL ÖÐÎÄÏÔʾÂÒÂë

MySQL ÖÐÎÄÏÔʾÂÒÂë
Èç¹ûÄãÓöµ½ÂÒÂëÎÊÌ⣬¿ÉÒÔ´ÓÏÂÃæ¼¸¸öÎÊÌâÖð²½¼ì²é£º
£¨1£©¼ì²éÄãµÄÎļþ´æ´¢±àÂëÊÇ·ñºÍ meta ÉùÃ÷µÄÒ»Ö£¬¼ÙÈçÄãµÄÎļþÊǰ´ÕÕ utf-8 ±àÂë´æ´¢£¬µ«ÊÇ meta È´ÉùÃ÷Ϊ gb2312 £¬½«µ¼ÖÂÂÒÂë¡£
½â¾ö°ì·¨£º½«Ò³Ãæ´æ´¢±àÂëºÍ meta ÉùÃ÷±£³ÖÒ»Ö¡£ÓüÇʱ¾´ò¿ªÎļþ£¬“Áí´æÎª”£¬ÏÂÃæÓиöÑ¡ÏîÊÇ“±àÂ딣¬Ñ¡ÔñºÍ meta ÉùÃ÷Ò»ÖµıàÂ뷽ʽ¡£(Ìáʾ£ºmeta µÄ±àÂëÉùÃ÷Òª·ÅÔÚ title ±êÇ©Ç°Ãæ£¬·ñÔòÈÝÒ×µ¼ÖÂÒ³Ãæ¿Õ°×¡£)
£¨2£©¼ì²éÄãµÄÊý¾Ý¿âÁ¬½ÓÓÐûÓÐÉèÖÃÁ¬½Ó·½Ê½£¨SET NAMES£©£¬MySQL 4.1 °æ±¾ÒÔºó£¬Èç¹ûÄãûÓÐÉèÖÃÊý¾Ý¿âÁ¬½Ó·½Ê½£¬ÄÇô²åÈë»òÕß²éѯ½«³öÏÖÂÒÂëÇé¿ö¡£
½â¾ö°ì·¨£ºÔÚÄãµÄÊý¾Ý¿âÁ¬½ÓÉèÖÃΪ£º
ÔÚhibernate.cfg.xmlÖÐÓ¦¸ÃÕâÑùд
<property name="connection.url">jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8</property>
Èç¹ûÓÃhibernate.properties
#hibernate.connection.url jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
ÆäÖРutf8 ÐèÒª¸ù¾ÝÄãÐèÒªÉèÖá£
£¨3£©¼ì²éÄãµÄÒ³Ãæ±àÂë¡¢meta ÉùÃ÷¡¢Êý¾Ý¿âÁ¬½Ó·½Ê½£¨SET NAMES£©ÊÇ·ñÒ»Ö£¬Èç¹ûÄãµÄÒ³ÃæºÍmetaÉèÖÃΪgb2312£¬µ«ÊÇÈ´ÔÚ³ÌÐòÖÐÉèÖàSET NAMES utf8£¬Í¬Ñù»áµ¼ÖÂÂÒÂë¡£Ô­ÒòÊÇÈç¹ûÒ³ÃæÉèÖÃΪ gb2312 £¬ÄÇô±íµ¥ÖеÄÊý¾ÝÒ²Êǰ´ÕÕ gb2312 Ìá½»£¬µ«ÊdzÌÐòÈ´ÒªÇó°´ÕÕ utf8 È¥´¦Àí£¬½á¹û×ÔÈ»ÊÇÂÒÂë¡£
½â¾ö°ì·¨£º½«Ò³Ãæ±àÂë¡¢meta ÉùÃ÷¡¢Êý¾Ý¿âÁ¬½Ó·½Ê½£¨SET NAMES£©±£³ÖÒ»Ö£¬µ±È»ÕâÀï˵µÄÒ»Ö²»ÊǾø¶ÔµÄ£¬Èç MySQL µÄ utf8 ºÍÒ³ÃæÖеĠutf-8 ÊDz»Ò»ÑùµÄ£¬¾ßÌåÒª¸ù¾ÝÄãµÄʵ¼ÊÇé¿öÉèÖá£


Ïà¹ØÎĵµ£º

windowsµÄ64λƽ̨railsÁ¬½ÓmysqlµÄ·½·¨


°²×°mysql
gem install mysql
ʹÓÃmysql£¬È磬rake db:migrate
»á±¨´í£º
E:\study\ruby\rails_space>rake db:migrate
(in E:/study/ruby/rails_space)
!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!
193: ......

MYSQL×Ô´ø¹¤¾ßQuery ProfilerʹÓÃ

Query ProfilerÊÇMYSQL×Ô´øµÄÒ»ÖÖqueryÕï¶Ï·ÖÎö¹¤¾ß£¬Í¨¹ýËü¿ÉÒÔ·ÖÎö³öÒ»ÌõSQLÓï¾äµÄÐÔÄÜÆ¿¾±ÔÚʲôµØ·½¡£Í¨³£ÎÒÃÇÊÇʹÓõÄexplain,ÒÔ¼°slow query log¶¼ÎÞ·¨×öµ½¾«È··ÖÎö£¬µ«ÊÇQuery ProfilerÈ´¿ÉÒÔ¶¨Î»³öÒ»ÌõSQLÓï¾äÖ´Ðеĸ÷ÖÖ×ÊÔ´ÏûºÄÇé¿ö£¬±ÈÈçCPU£¬IOµÈ£¬ÒÔ¼°¸ÃSQLÖ´ÐÐËùºÄ·ÑµÄʱ¼äµÈ¡£²»¹ý¸Ã¹¤¾ßÖ»ÓÐÔÚMYSQL 5.0.37ÒÔ ......

MySQL connection strings

MySQL ODBC connection strings
Open connection to local MySQL database using MySQL ODBC 3.51 Driver
"Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3"
MySQL OLE DB & OleDbConnection (.NET fr ......

MySQLÓëÊÂÎñ (ת)

MySQL5.X¶¼ÒѾ­·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎ޹أ ......

mysql ÈÕÖ¾ÎļþµÄʹÓÃ

MYSQLÓв»Í¬ÀàÐ͵ÄÈÕÖ¾Îļþ(¸÷×Ô´æ´¢Á˲»Í¬ÀàÐ͵ÄÈÕÖ¾)£¬´ÓËüÃǵ±ÖпÉÒÔ²éѯµ½MYSQLÀï¶¼×öÁËЩʲô£¬¶ÔÓÚMYSQLµÄ¹ÜÀí¹¤×÷£¬ÕâЩÈÕÖ¾ÎļþÊDz»¿ÉȱÉٵġ£
1.´íÎóÈÕÖ¾(The error log)£º¼Ç¼ÁËÊý¾Ý¿âÆô¶¯¡¢ÔËÐÐÒÔ¼°Í£Ö¹¹ý³ÌÖдíÎóÐÅÏ¢£»
2.ISAM²Ù×÷ÈÕÖ¾(The isam log)£º¼Ç¼ÁËËùÓжÔISAM±íµÄÐ޸쬏ÃÈÕÖ¾½ö½öÓÃÓÚµ÷ÊÔISAMģʽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ