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

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   table   oldmail(
    id   varchar(200)   not   null,
    username     varchar(255)   not   null   ,
    primary   key(id,username)
)
3 mysqlµÄÖ÷¼üÎÊÌ⣺
MysqlµÄÁ½ÖÖÖ÷¼ü¡£Primary key ºÍnot null auto_incrimentÔÚ½¨Á¢mysql±íʱ£¬¸øÒ»¸ö×Ö¶ÎÌí¼ÓÁËÖ÷¼üprimary key ÔÚinsertÊý¾Ýʱ¿ÉÒÔ²»ÓÃinsertÖ÷¼ü£¬mysql»á×Ô¶¯Ìí¼Ó0£¬µ«ÊÇÔÚµÚ¶þ´ÎinsertʱûÓÐÌîдֵmysqlÊý¾Ý¿â»¹ÊÇĬÈÏÌí¼Ó0£¬»áµ¼ÖÂÓÐÖØ¸´µÄÖ÷¼ü£¬ÕâÊDz»¿ÉÒԵġ£ËùÓÐÔÚ¶¨ÒåÁËprimary keyʱ£¬ÔÚinsertÊý¾ÝʱҪ¸øÖ÷¼üÌîдֵ¡£ÔÚ½¨Á¢mysql±íʱ£¬¸øÒ»¸ö×Ö¶ÎÌí¼ÓÁËÖ÷¼ünot null auto_increment=1;ÕâÒ²ÊÇÒ»¸öÖ÷¼ü¡£Ê±×ÔÔö³¤µÄÒÔ1Ϊ¿ªÊ¼¡£Õâ¸ö×Ö¶ÎÊÇ¿ÉÒÔ²»ÓÃÌîдֵµÄ£¬mysqlÊý¾Ý¿â»á×Ô¶¯¸øÌîдֵ£¬²»»á³öÏÖprimary keyµÄ×´¿ö¡£Alter table tb add primary key(id);Alter table tb change id id int(10) not null auto_increment=1;
4 ɾ³ý×ÔÔö³¤µÄÖ÷¼üidÏÈɾ³ý×ÔÔö³¤ÔÚɾ³ýÖ÷¼ü
Alter table tb change id id int(10);//ɾ³ý×ÔÔö³¤
Alter table tb drop primary key;//ɾ³ýÖ÷½¨
ÖØÃüÃû±í
ALTER   TABLE   ¾É±íÃû   RENAME   TO   бíÃû;


Ïà¹ØÎĵµ£º

mysqlÄÚ´æ±íheapʹÓÃ×ܽá


ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿â£¬µ«ÊÇʹÓÃÉÏÊܵ½Ò»Ð©ÏÞÖÆ£¬ÒÔÏÂÊÇÀ¶²ÝʹÓõÄһЩ¸ÐÊÜ¡£
1¡¢heap¶ÔËùÓÐÓû§µÄÁ¬½ÓÊǿɼûµÄ£¬ÕâʹµÃËü·Ç³£ÊʺÏ×ö»º´æ¡£
2¡¢½öÊʺÏʹÓõij¡ºÏ¡£heap²»ÔÊÐíʹÓÃxxxTEXTºÍxxxBLOBÊý¾ÝÀàÐÍ£»Ö»ÔÊÐíʹÓÃ=ºÍ<=>²Ù×÷·ûÀ´ËÑË÷¼Ç¼£¨²» ......

ÈÃmemcachedºÍmysql¸üºÃµÄ¹¤×÷

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 ѧϰ±Ê¼Ç

 ÏÔʾËùÓÐÊý¾Ý¿â show databases;
 ´´½¨Êý¾Ý¿â create dababase stu;
 É¾³ýÊý¾Ý¿âdrop database stu;
 Çл»µ½Êý¾Ý¿âuse stu;
 È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
   
-> stu_id int(8) ......

¹ØÓÚMySQLÊý¾ÝÁ¿Ôö¼Ó±ä»¯²»´óʱ£¬Ò»ÖÖ·ÖÒ³µÄÓÅ»¯·½°¸

¹ØÓÚ·ÖÒ³µÄÓÅ»¯¡£
ÎÒÃÇÖªµÀ£¬ÔÚMySQLÖзÖÒ³ºÜ¼òµ¥£¬Ö±½ÓLIMIT page_no,page_total ¾Í¿ÉÒÔÁË¡£
¿ÉÊǵ±¼Ç¼ÊýÂýÂýÔö´óʱ£¬Ëý¾Í²»ÄÇôºÃʹÁË¡£
ÕâÀïÎÒÃÇ´´½¨ÕªÒª±íÀ´¼Ç¼ҳÂëºÍÔ­±íÖ®¼äµÄ¹ØÁª¡£
ÏÂÃæÎª²âÊÔÊý¾Ý¡£
Ô­±í£º
CREATE TABLE `t_group` (
  `id` int(11) NOT NULL auto_increment,
  `money` decim ......

Tomcat5+MysqlÎÄÖÐÂÒÂëÎÊÌâµÄ½â¾ö·½·¨ (ת)


Tomcat ÏÂ×îÈÝÒ×µ½µÄÎÊÌâ¾ÍÊÇÖÐÎÄÂÒÂëÎÊÌâÁË , ÏÂÃæ¾ÍÀ´Ì¸Ì¸ÎÒÔÚ Windows +Tomcat5 Ïµ÷ÊÔ JSP ³ÌÐòʱ , ËùÅöµ½µÄÎÊÌâÒÔ¼°½â¾ö°ì·¨¡£
       Õâ´Îµ÷ÊÔËùÓöµ½µÄÂÒÂëÎÊÌâÖ÷ÒªÓÐÈýÀࣺ
Ò»¡¢ Ò³Ãæ×Ö·ûÂÒÂë¡£
¼´Õû¸öÒ³Ãæ³öÏÖºº×ÖÂÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ