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:
Ïà¹ØÎĵµ£º
Òª²»³öÏÖÂÒÂ룬¾ÍÒª±£³ÖÊý¾Ý¿âºÍÒ³ÃæµÄ±àÂë¸ñʽһÖÂ.ÎÒÈ«²¿Ê¹ÓÃutf-8µÄ±àÂë.
Ê×ÏÈÒ³Ãæ:
1. ½«ÎļþÓÃUE´ò¿ª,½«ÎļþÁí´æÎªUTF-8ÎÞBOM¸ñʽ.ºÜ¶à±à¼Æ÷¶¼¿ÉÓÃ.
2.ʹÓà header("content-type:text/html;¡¡charset=utf-8"); Ç¿ÖÆ×ª»»³Éutf-8µÄ±àÂë.
Ò²¿ÉÒÔн¨Ò»¸öhead.php,ÈçÏÂ,ÔÚÒ³ÃæÖÐÓÃinclude( ......
1. mysql Ð޸ıíÃû×Ö
ALTER TABLE t1 RENAME t2;
2. ÐÞ¸ÄÁеÄÃû×Ö
>ALTER TABLE stock CHANGE COLUMN stock_id id INT(6);
3. Ôö¼ÓÁÐ
>ALTER TABLE ab ADD COLUMN id INT(3);
4. ¼õÉÙÁÐ
>ALTER TABLE ab DROP COLUMN id;
5. ÐÞ¸ÄÁ ......
¹ØÓÚ·ÖÒ³µÄÓÅ»¯¡£
ÎÒÃÇÖªµÀ£¬ÔÚMySQLÖзÖÒ³ºÜ¼òµ¥£¬Ö±½ÓLIMIT page_no,page_total ¾Í¿ÉÒÔÁË¡£
¿ÉÊǵ±¼Ç¼ÊýÂýÂýÔö´óʱ£¬Ëý¾Í²»ÄÇôºÃʹÁË¡£
ÕâÀïÎÒÃÇ´´½¨ÕªÒª±íÀ´¼Ç¼ҳÂëºÍÔ±íÖ®¼äµÄ¹ØÁª¡£
ÏÂÃæÎª²âÊÔÊý¾Ý¡£
Ô±í£º
CREATE TABLE `t_group` (
`id` int(11) NOT NULL auto_increment,
`money` decim ......
ÅäÖÃMySQLÖ÷´Ó¸´ÖÆ(Replication)
±êÇ©£ºÖªÊ¶/̽Ë÷ mysql¸´ÖÆ replication mysql±¸·Ý
·ÖÀࣺÊý¾Ý¿â
MySQLÖ§³Öµ¥Ïò¡¢Òì²½¸´ÖÆ£¬¸´Öƹý³ÌÖÐÒ»¸ö·þÎñÆ÷³äµ±Ö÷·þÎñÆ÷£¬¶øÒ»¸ö»ò¶à¸öÆäËü·þÎñÆ÷³äµ±´Ó·þÎñÆ÷¡£Ö÷·þÎñÆ÷½«¸üÐÂдÈë¶þ½øÖÆÈÕÖ¾Îļþ£¬²¢Î¬»¤ÈÕÖ¾ÎļþµÄÒ»¸öË÷ÒýÒÔ¸ú×ÙÈÕ־ѻ·¡£µ±Ò»¸ö´Ó·þÎñ ......
Õâʱ¼äÔÚ°²×°PHPBBµÄÂÛ̳£¬·¢ÏÖÒ»¸öÎÊÌ⣬ÄǾÍÊÇÊäÈëÓû§Ãû¸úÃÜÂëºó£¬µã»÷°²×°£¬×ÜÊDZ¨ÁËÒÔϵĴíÎó£º
³ÌÐò´úÂë
ORA-28008: invalid old password
Cause: old password supplied is wrong; Hence user cannot be authenticated using old password
Action: Supply the correct old password for authenticatio ......