SSH+MySQL¿ª·¢ÖеÄÖÐÎÄÂÒÂëÎÊÌâ
Ò»¡¢±íµ¥Ìá½»ÂÒÂë½â¾ö·½·¨
±íµ¥Öк¬ÓÐÖÐÎÄÌá½»ÂÒÂ룬¶ÔÓÚ×ÖĸºÍÊý×ÖÔò²»»áÂÒÂ룬ÎÒÑ¡ÓõÄ×Ö·û¼¯utf-8(ÒÔÏÂͬ)¡£
1¡¢ÔÚapache-tomcat-6.0.18\webapps\examples\WEB-INF\classes\filtersĿ¼ÏÂÕÒµ½ÎļþSetCharacterEncodingFilter.java ºÍRequestDumperFilter.javaÎļþ£¬²¢½«Æä¸´ÖƵ½ÏîÄ¿srcϵÄfilters°üÖС£
2¡¢ÔÚWeb.xmlÖмÓÈëfilter¡£
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>filters.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf8</param-value>
</init-param>
</filter
<filter-mapping>
<filter-name>Set Character Encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
3¡¢ÔÚjspÒ³ÃæÖмÓÈëÁ½ÐдúÂ룺
<%@ page contentType="text/html;charset=UTF-8"%>
<meta http-equiv="contentType" content="text/html;charset=utf-8">
¶þ¡¢MySQLÊý¾Ý¿â×Ö·û¼¯½â¾ö·½·¨
1¡¢ÐÞ¸ÄMySql°²×°Ä¿Â¼ÏµÄmy.iniÎļþ
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
ÐÞ¸ÄÖ®ºó±£´æ¡£
2¡¢ÔÚMySQl¿Í»§¶ËÊäÈëÃüÁî
mysql> status ²é¿´Êý¾Ý¿â×Ö·û¼¯ÉèÖÃ
Èç¹ûÏÔʾÈçÏ£º
Server characterset: utf8
Db characterset: utf8
Client characterset:
Ïà¹ØÎĵµ£º
http://www.itlearner.com/article/2009/4325.shtml
Õâ´ÎÊÇFotolog
µÄ¾Ñ飬´«ËµÖбÈFlickr¸ü´óµÄÍøÕ¾
£¬FotologÔÚ21̨·þÎñ
Æ÷Éϲ¿ÊðÁË51¸ömemcachedʵÀý£¬×ܼÆÓÐ254G»º´æ¿Õ¼ä¿ÉÓ㬻º´æÁ˶à´ï175GµÄÄÚÈÝ£¬Õâ¸öÊýÁ¿±ÈºÜ¶àÍøÕ¾µÄÊý¾Ý¿â¶¼Òª´óµÄ¶à£¬ÔÎÄÊÇA Bunch of Great Strategies for Using Memcached and MySQL Bet ......
¹ØÓÚ·ÖÒ³µÄÓÅ»¯¡£
ÎÒÃÇÖªµÀ£¬ÔÚMySQLÖзÖÒ³ºÜ¼òµ¥£¬Ö±½ÓLIMIT page_no,page_total ¾Í¿ÉÒÔÁË¡£
¿ÉÊǵ±¼Ç¼ÊýÂýÂýÔö´óʱ£¬Ëý¾Í²»ÄÇôºÃʹÁË¡£
ÕâÀïÎÒÃÇ´´½¨ÕªÒª±íÀ´¼Ç¼ҳÂëºÍÔ±íÖ®¼äµÄ¹ØÁª¡£
ÏÂÃæÎª²âÊÔÊý¾Ý¡£
Ô±í£º
CREATE TABLE `t_group` (
`id` int(11) NOT NULL auto_increment,
`money` decim ......
µ¼ÈëÊý¾ÝÖ¸¶¨ÁÐ
load data local infile 'D:\\service_func_utf8.txt' into table service_func fields terminated by '\t' (service_id, func_id1, func_id2, func_id3, func_id4, func_id5, func_id6);
MYSQL½«²éѯ½á¹ûµ¼³öµ½Îļþ
select * from tablename into outfile '/tmp/test.txt';
MYSQLÁªºÏÖ÷¼ü
create  ......
PHP ´æÈ¡ MySQL ÂÒÂëÎÊÌâ
ÉÏһƪ / ÏÂһƪ 2007-06-04 03:33:50 / ¸öÈË·ÖÀࣺPHPѧϰ
²é¿´( 239 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
MySQL µÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺×Ö·û¼¯(Character set)ºÍÅÅÐò·½Ê½(Collation)¡£¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î: ·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í ......
Ò»¡¢MYSQLµÄµ¼³ö
½øÈëmysql°²×°Ä¿Â¼£¬½øÈëbin
ÔÚÃüÁîÐÐģʽÏ´òÈ룺
³ÌÐò´úÂë
mysqldump -u root -p hibernate > c:/hibernate.sql
ÆäÖÐ-u ±íʾÓû§
-p±íʾÓû§ÐèÒªÈÏÖ¤
hibernate±íʾҪµ¼³öµÄÊý¾Ý¿â
> c:/hibernate ±íʾ½«Ê ......