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

ʹÓÃmysqlµÄreplaceº¯ÊýÌæ»»×Ö·û´®

×î½üÔÚÑо¿CMS£¬ÔÚÊý¾Ýת»»µÄʱºòÐèÒªÓõ½mysqlµÄreplaceº¯Êý£¬ÕâÀï¼òµ¥½éÉÜһϣ¡
±ÈÈçÄãÒª½« ±í tb1ÀïÃæµÄ f1×ֶεÄabcÌæ»»Îªdef
UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def');
REPLACE(str,from_str,to_str)   
ÔÚ×Ö·û´®   str   ÖÐËùÓгöÏÖµÄ×Ö·û´®   from_str   ¾ù±»   to_strÌæ»»£¬È»ºó·µ»ØÕâ¸ö×Ö·û´®£º   
mysql>   SELECT   REPLACE('www.mysql.com',   'w',   'Ww'); 
                  ->   'WwWwWw.mysql.com' 
Õâ¸öº¯ÊýÊǶà×Ö½Ú°²È«µÄ¡£
ʾÀý£º
UPDATE  `dede_addonarticle`  SET body =  REPLACE ( body,
 '</td>',
 '' );
UPDATE  `dede_addonarticle`  SET body =  REPLACE ( body,
 '</tr>',
 '' );
UPDATE  `dede_addonarticle`  SET body =  REPLACE ( body,
 '<tr>',
 '' );      
UPDATE  `dede_archives`  SET title=  REPLACE ( title,
 '´óÑóÐÂÎÅ - ',
 '' ); 
UPDATE  `dede_addonarticle`  SET body =  REPLACE ( body,
 '../../../../../../',
 'http://special.dayoo.com/meal/' );
mysql replace
Ó÷¨1.replace intoreplace into table (id,name) values(‘1‘,‘aa‘),(‘2‘,‘bb‘)
´ËÓï¾äµÄ×÷ÓÃÊÇÏò±ítableÖвåÈëÁ½Ìõ¼Ç¼¡£
2.replace(object, search,replace)
°ÑobjectÖгöÏÖsearchµÄÈ«²¿Ì滻Ϊreplaceselect replace(‘www.163.com‘,‘w‘,‘Ww‘)--->WwW wWw.163.com
Àý£º°Ñ±ítableÖеÄname×Ö¶ÎÖÐµÄ aaÌæ»»Îªbbupdate table set name=replace(name,‘aa‘,‘bb‘)


Ïà¹ØÎĵµ£º

mysqlÐÞ¸ÄÃÜÂë(°üÀ¨ÃÜÂëÍü¼ÇµÄÇé¿ö)

ÐÞ¸ÄrootÃÜÂëµÄʱºò°´ÕÕÍøÉϵÄ˵µÄ¾ÓȻɵɵµÄÖ´ÐÐÁËupdate user set password="asdf" where user="root"£»Ö´ÐÐÖ®ºó·¢ÏÖÃÜÂë´íÁË£¬½øÈ¥²»ÁË£¬ÓÚÊÇÕÛÌÚÁ˰ëÌ죬·¢ÏÖmysqlµÄÃÜÂëÊǼÓÃܵIJ»ÊÇÃ÷ÎÄ´æ´¢µÄ£¬ËùÒԸĵÄʱºòÐèÒªÕâÑùset password=password("asdf")¡£´íÎóÒѾ­·¢ÉúÁË£¬ÓÚÊǾͰ´ÕÕÏÂÃæµÄ· ......

mysql Ëæ»ú»ñÈ¡¼Ç¼ order by rand ÓÅ»¯

Èç¹ûÒªËæ»ú»ñÈ¡¼Ç¼Êý£¬ÔÚmysqlÀï×î¼òµ¥µÄ·½·¨¿Ï¶¨ÊÇorder
by
rand
()ÁË£¬µ«ÊÇÕâÖÖ·½·¨Ö»ÄÜÔÚ±í¼Ç¼¼«ÉÙµÄÇé¿öϲÅÄÜʹÓá£Ö÷ÒªÊÇÒòΪorder
by
rand
()µ¼ÖÂÁËusing filesort.Õâ¸öʱºò²éѯÀàÐÍ»á±ä³Éall£¬Ë÷Òý»áʧЧ¡£Ö»Ðè¼òµ¥µÄ±äͨÏ£¬Íê³É¿ÉÒÔ×öµ½Í¬ÑùµÄЧ¹û¡£
¸ù¾Ý¼Ç¼µÄÀàÐÍ£¬·ÖÀàÁ¬ÐøºÍ·ÇÁ¬ÐøÁ½ÖÖ¡£
Á¬ÐøÖ ......

mysql cache¹¦ÄÜС¼Ç

http://www.cnblogs.com/rethink/archive/2009/10/09/1579634.html
mysql cache¹¦ÄÜ·ÖÎö£º
1
mysqlµÄcache¹¦ÄܵÄkeyµÄÉú³ÉÔ­ÀíÊÇ£º°ÑselectÓï¾ä°´ÕÕÒ»¶¨µÄhash¹æÔòÉú³ÉΨһµÄkey£¬selectµÄ½á¹ûÉú³Évalue£¬¼´key=>value¡£ËùÒÔ¶ÔÓÚcache¶øÑÔ£¬selectÓï¾äÊÇÇø·Ö´óСдµÄ£¬Ò²Çø·Ö¿Õ¸ñµÄ¡£Á½¸öselectÓï¾ä±ØÐëÍêÍêȫȫһÖ ......

ʹÓÃC²Ù×÷MySQLÊý¾Ý¿â£¨vs 2008£©

×î½ü¼¸ÌìÏÐÀ´ÎÞÊ£¬±ã³¢ÊÔÁËÒ»ÏÂÓÃC²Ù×÷Êý¾Ý¿â£¬ÏÂÃæ±ãÊÇÎÒ²âÊԵľßÌå½á¹û£º
¿ª·¢»·¾³ÊÇwindows 7 ultimate(Ó¢Îİæ) IDE ÊÇvs 2008 professional ÖÐÎİæ,Êý¾Ý¿âÊÇmysql 5.1
Ê×ÏÈ£¬ÎÒÔÚMySQL¿âÖд´½¨ÁËÒ»¸ötest±í£º
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ