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&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»Ò»ÑùµÄ£¬¾ßÌåÒª¸ù¾ÝÄãµÄʵ¼ÊÇé¿öÉèÖá£
Ïà¹ØÎĵµ£º
ÓÃÔÚSELECTºÍWHERE×Ó¾äµÄº¯Êý
--------------------------------------------------------------
1 ·Ö×麯Êý
( ... ) À¨ºÅ¡£Ê¹ÓÃËüÃÇÀ´Ç¿ÖÆÔÚÒ»¸ö±í´ïʽµÄ¼ÆËã˳Ðò¡£
--------------------------------------------------------------
2 ³£ÓõÄËãÊõÔËËã
£¨+ - * /£©
Ò»°ãµÄË ......
1¡¢Ð½¨Êý¾ÝÔ´Îļþmysql-ds.xml,ÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/mydatabase?useUnico ......
À´×Ô£ºhttp://it.china-b.com/zx/linuxsjk/20090525/24129_1.html
ÕªÒª£ºMySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ£¬ÊÊÓÃÆ½Ì¨¶à£¬¿ÉÀ©Õ¹ÐÔÇ¿¡£ÔÚʵ¼ÊÉú²ú»·¾³ÖУ¬²¿ÊðºÍʵÏÖ¾ßÓÐÒ»¶¨¸ºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÓû§Êý¾Ý¿â
Ó¦ÓÃϵͳµÄÐÔÄÜ¡¢ËٶȺÍÎȶ¨ÐÔ¾ßÓÐÃ÷ÏÔµÄ×÷Óᣱ¾ÎļòÒª½éÉÜÁËÔÚ ......
select * for updateËø±íµÄÎÊÌâ
ÓÉÓÚInnoDBÔ¤ÉèÊÇRow-Level Lock£¬ËùÒÔÖ»ÓС¸Ã÷È·¡¹µÄÖ¸¶¨Ö÷¼ü£¬MySQL²Å»áÖ´ÐÐRow lock (Ö»Ëø×¡±»Ñ¡È¡µÄ×ÊÁÏÀý) £¬·ñÔòMySQL½«»áÖ´ÐÐTable Lock (½«Õû¸ö×ÊÁÏ±íµ¥¸øËø×¡)¡£
¾Ù¸öÀý×Ó:
¼ÙÉèÓиö±íµ¥products £¬ÀïÃæÓÐid¸úname¶þ¸öÀ¸Î»£¬idÊÇÖ÷¼ü¡£
Àý1: (Ã÷È·Ö¸¶¨Ö÷¼ü£¬²¢ÇÒÓд˱Ê×ÊÁÏ£¬ ......
MYSQLÓв»Í¬ÀàÐ͵ÄÈÕÖ¾Îļþ(¸÷×Ô´æ´¢Á˲»Í¬ÀàÐ͵ÄÈÕÖ¾)£¬´ÓËüÃǵ±ÖпÉÒÔ²éѯµ½MYSQLÀï¶¼×öÁËЩʲô£¬¶ÔÓÚMYSQLµÄ¹ÜÀí¹¤×÷£¬ÕâЩÈÕÖ¾ÎļþÊDz»¿ÉȱÉٵġ£
1.´íÎóÈÕÖ¾(The error log)£º¼Ç¼ÁËÊý¾Ý¿âÆô¶¯¡¢ÔËÐÐÒÔ¼°Í£Ö¹¹ý³ÌÖдíÎóÐÅÏ¢£»
2.ISAM²Ù×÷ÈÕÖ¾(The isam log)£º¼Ç¼ÁËËùÓжÔISAM±íµÄÐ޸쬏ÃÈÕÖ¾½ö½öÓÃÓÚµ÷ÊÔISAMģʽ ......