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

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:  


Ïà¹ØÎĵµ£º

mysql Ð޸ıí½á¹¹

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. ÐÞ¸ÄÁ ......

nginx+php cgi+mysqlÒ»¼ü°²×°°ü¸üаæ

[part1] http://download.csdn.net/source/2076258 
[part2] http://download.csdn.net/source/2076272
[part3] http://download.csdn.net/source/2076276
[part4] http://download.csdn.net/source/2076283
[part02-04] http://www.ytgps.com/Images/nginx.rar
±¾ÎļþÌå»ý¹ý´ó·Ö4¸ö°ü£¬php-cgi+mysql+nginx.7z ......

MysqlÎļ¯

µ¼ÈëÊý¾ÝÖ¸¶¨ÁÐ
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  ......

MysqlÐ޸ıí×Ö¶Î

#ÐÂÔöÒ»¸ö×ֶΣ¬Ä¬ÈÏֵΪ0£¬·Ç¿Õ£¬×Ô¶¯Ôö³¤£¬Ö÷¼ü  
 
   alter table tabelname add new_field_name field_type default 0 not null auto_increment ,add primary key (new_field_name);  
 
#Ôö¼ÓÒ»¸öÐÂ×ֶΠ 
 
   alter table tableName ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ