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

MySQLÖ®¶¯Ì¬±íÌØÕ÷

Èç¹ûÒ»¸öMyISAM±í°üº¬Èκοɱ䳤¶ÈÁУ¨VARCHAR, BLOB»òTEXTDynamic£©£¬»òÕßÈç¹ûÒ»¸ö±í±»ÓÃROW_FORMAT=DYNAMICÑ¡ÏîÀ´´´½¨£¬¶¯Ì¬´æ´¢¸ñʽ±»Ê¹Óá£
 
Õâ¸ö¸ñʽ¸üΪ¸´ÔÓÒ»µã£¬ÒòΪÿÐÐÓÐÒ»¸ö±íÃ÷ÐÐÓж೤µÄÍ·¡£µ±Ò»¸ö¼Ç¼ÒòΪ¸üеĽá¹û±»±äµÃ¸ü³¤£¬¸Ã¼Ç¼Ҳ¿ÉÒÔÔÚ³¬¹ýÒ»¸öλÖô¦½áÊø¡£
 
Äã¿ÉÒÔʹÓÃOPTIMIZE TABLE»òmyisamchkÀ´¶ÔÒ»¸ö±íÕûÀíË鯬¡£Èç¹ûÔÚÒ»¸ö±íÖÐÓÐÄãÆµ·±·ÃÎÊ»ò¸Ä±äµÄ¹Ì¶¨³¤¶ÈÁУ¬±íÖÐÒ²ÓÐһЩ¿É±ä³¤¶ÈÁУ¬½öΪ±ÜÃâË鯬¶ø°ÑÕâЩ¿É±ä³¤¶ÈÁÐÒÆµ½ÆäËü±í¿ÉÄÜÊÇÒ»¸öºÃÖ÷Òâ¡£
 
¶¯Ì¬¸ñʽ±íµÄÒ»°ãÌØÕ÷£º
 
·         ³ýÁ˳¤¶ÈÉÙÓÚ4µÄÁÐÍ⣬ËùÓеÄ×Ö·û´®ÁÐÊǶ¯Ì¬µÄ¡£
 
·         ÔÚÿ¸ö¼ÇÂ¼Ç°ÃæÊÇÒ»¸öλͼ£¬¸Ãλͼ±íÃ÷ÄÄÒ»Áаüº¬¿Õ×Ö·û´®£¨¶ÔÓÚ×Ö·û´®ÁУ©»òÕß0£¨¶ÔÓÚÊý×ÖÁУ©¡£×¢Ò⣬Õâ²¢²»°üÀ¨°üº¬NULLÖµµÄÁС£Èç¹ûÒ»¸ö×Ö·ûÁÐÔÚÍÏÒ·¿Õ¼äÒÆ³ýºó³¤¶ÈΪÁ㣬»òÕßÒ»¸öÊý×ÖÁÐΪÁãÖµ£¬Õâ¶¼ÔÚλͼÖбê×¢ÁËÇÒÁв»±»±£´æµ½´ÅÅÌ¡£ ·Ç¿Õ×Ö·û´®±»´æÎªÒ»¸ö³¤¶È×Ö½Ú¼Ó×Ö·û´®µÄÄÚÈÝ¡£
 
·         ͨ³£±È¹Ì¶¨³¤¶È±íÐèÒª¸üÉٵĴÅÅ̿ռ䡣
 
·         ÿ¸ö¼Ç¼½öʹÓñØÐè´óСµÄ¿Õ¼ä¡£¾¡¹ÜÈç´Ë£¬Èç¹ûÒ»¸ö¼Ç¼±ä´ó£¬Ëü¾Í°´ÐèÒª±»·Ö¿ª³É¶àƬ£¬Ôì³É¼Ç¼Ë鯬µÄºó¹û¡£±ÈÈ磬ÄãÓÃÀ©Õ¹Ðг¤¶ÈµÄÐÅÏ¢¸üÐÂÒ»ÐУ¬¸ÃÐоͱäµÃÓÐË鯬¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔʱ²»Ê±ÔËÐÐOPTIMIZE TABLE»òmyisamchk -rÀ´¸ÄÉÆÐÔÄÜ¡£¿ÉʹÓÃmyisamchk -eiÀ´»ñÈ¡±íµÄͳ¼ÆÊý¾Ý¡£
 
·         ¶¯Ì¬¸ñʽ±íÔÚ±ÀÀ£ºóÒª±È¾²Ì¬¸ñʽ±í¸üÄÑÖØ½¨£¬ÒòΪһ¸ö¼Ç¼¿ÉÄܱ»·ÖΪ¶à¸öË鯬ÇÒÁ´½Ó£¨Ë鯬£©¿ÉÄܱ»¶ªÊ§¡£
 
·         ¶¯Ì¬³ß´ç¼Ç¼ÆÚÍûµÄÐ㤶ÈÓÃÏÂÁбí´ïʽÀ´¼ÆË㣺
 
·                3
·                + (number of columns + 7) / 8
·                + (nu


Ïà¹ØÎĵµ£º

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ

À´Ô´£ºhttp://www.blogjava.net/Alpha/archive/2007/07/23/131912.html 
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ......

Mysql ʱ¼äº¯Êý»ã×Ü

 Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQL Öл¹ÓÐÏÂÃæµÄº¯Êý£º
current_tim ......

MySqlÖд´½¨ÊÓͼ

 
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£s ......

MySQL¶Ô±ê×¼SQLµÄÀ©Õ¹

MySQL·þÎñÆ÷°üº¬Ò»Ð©ÆäËûSQL DBMSÖв»¾ß±¸µÄÀ©Õ¹¡£×¢Ò⣬Èç¹ûʹÓÃÁËËüÃÇ£¬½«ÎÞ·¨°Ñ´úÂëÒÆÖ²µ½ÆäËûSQL·þÎñÆ÷¡£ÔÚijЩÇé¿öÏ£¬Äã¿ÉÒÔ±àд°üº¬MySQLÀ©Õ¹µÄ´úÂ룬µ«ÈÔ±£³ÖÆä¿ÉÒÆÖ²ÐÔ£¬·½·¨ÊÇÓÓ/*... */”×¢Ê͵ôÕâЩÀ©Õ¹¡£MySQL·þÎñÆ÷Äܹ»½âÎö²¢Ö´ÐÐ×¢ÊÍÖеĴúÂ룬¾ÍÏñ¶Ô´ýÆäËûMySQLÓï¾äÒ»Ñù£¬µ«ÆäËûSQL·þÎñÆ÷½«ºöÂÔ ......

mysqlÖÐÎÄÅÅÐò¼°javaÖÐÎÄÅÅÐò


Ö®ËùÒÔдÕâÆª²©¿Í£¬ÊÇÒòΪǰ¼¸Ìì²ÅÅöµ½ÁËÕâôһ¸öÎÊÌ⣬ÒÔǰ»¹²»ÖªµÀmysqlÓÐÕâôһ¸öÎÊÌâ¡£
ÎÒÃǵÄϵͳʹÓÃÁËstruts+hibernate£¬Êý¾Ý¿âʹÓõÄÊÇmysql£¬×Ö·û¼¯Í³Ò»Îªutf-8¡£
±¾À´ÒѾ­Íê³ÉÁË£¬µ«ÊÇϵͳʹÓõÄʱºò£¬·¢ÏÖ²é³öÀ´µÄÈËÃûûÓÐ˳Ðò£¬±¾À´ÒÔΪºÜ¼òµ¥£¬ÔÚ²éѯµÄʱºò£¬Ö¸¶¨°´ÕÕnameÅÅÐò¾Í¿ÉÒÔÁË£¬Æñ֪ʵ¼ÊÒ»×ö²Å·¢Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ