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»Ò»ÑùµÄ£¬¾ßÌåÒª¸ù¾ÝÄãµÄʵ¼ÊÇé¿öÉèÖá£
Ïà¹ØÎĵµ£º
MySQL
ÊÇÒ»¸ö·Ç³£Á÷ÐеÄСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬2008Äê1ÔÂ16ºÅ±»Sun¹«Ë¾ÊÕ¹º¡£Ä¿Ç°MySQL±»¹ã·ºµØÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾ÖС£ÓÉ
ÓÚÆäÌå»ýС¡¢Ëٶȿ졢×ÜÌåÓµÓгɱ¾µÍ£¬ÓÈÆäÊÇ¿ª·ÅÔ´ÂëÕâÒ»ÌØµã£¬Ðí¶àÖÐСÐÍÍøÕ¾ÎªÁ˽µµÍÍøÕ¾×ÜÌåÓµÓгɱ¾¶øÑ¡ÔñÁËMySQL×÷ÎªÍøÕ¾Êý¾Ý¿â¡£
1¡¢phpMyAdmin£¨http://www.phpmyadmin.ne ......
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 ......
1.MySQL´´½¨ÊÓͼµÄ¼òµ¥Óï¾äΪ£ºCREATE VIEW view_name AS SELECT * from TABLE_NAME;
²»ÄܶԴ¥·¢Æ÷´´½¨ÊÓͼ(VIEW)¡£µ«ÊÇÔÚ5.1.4ÖÐÊÇÕâÑùÃèÊöµÄ£¬A view can be created from many kinds of SELECT statements. It can refer to base tables or other views. It can use joins, UNION, and subqueries¡£´óÖÂÒâ˼ÊÇÊÓÍ ......
À´×Ô£ºhttp://it.china-b.com/zx/linuxsjk/20090525/24129_1.html
ÕªÒª£ºMySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ£¬ÊÊÓÃÆ½Ì¨¶à£¬¿ÉÀ©Õ¹ÐÔÇ¿¡£ÔÚʵ¼ÊÉú²ú»·¾³ÖУ¬²¿ÊðºÍʵÏÖ¾ßÓÐÒ»¶¨¸ºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÓû§Êý¾Ý¿â
Ó¦ÓÃϵͳµÄÐÔÄÜ¡¢ËٶȺÍÎȶ¨ÐÔ¾ßÓÐÃ÷ÏÔµÄ×÷Óᣱ¾ÎļòÒª½éÉÜÁËÔÚ ......