ÕýÔڲ鿴: ¹Ø¼ü×Ö mysql µÄËÑË÷½á¹û ( ¹² 72 Ìõ¼Ç¼ µÚ6Ò³/¹²8Ò³ )
ÅäÖÃmysql´Ô¿âСÐÄʹÓÃreplicate_do_dbºÍreplicate_ignore_db
²é¿´ÎÄÕÂСÐÄʹÓÃreplicate_do_dbºÍreplicate_ignore_db2009-01-0715:54ʹÓÃreplicate_do_dbºÍreplicate_ignore_dbʱÓÐÒ»¸öÒþ»¼£¬¿ç¿â¸üÐÂʱ»á³ö´íÈçÉèÖÃreplicate_do_db=testusemysql;updatetest.table1set......µÚ¶þ¾ä½«²»»á±»Ö´ÐÐÈçÉèÖÃreplicate_ignore_db=mysqlusemysql;updat...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º774 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-08-19 10:51:54 http://122.114.238.25/article-5315.html
MySQLË«Ïòͬ²½
1.·þÎñÆ÷״̬·þÎñÆ÷A£º192.168.1.1·þÎñÆ÷B£º192.168.1.22.´´½¨Í¬²½Óû§Ö÷»úÓòA£º192.168.1.2Óû§ÃûA£ºsync_aÃÜÂëA£ºaaaÖ÷»úÓòB£º192.168.1.1Óû§ÃûB£ºsync_bÃÜÂëB£ºbbbÖÁÉÙ·ÖÅäÒÔÏÂȨÏÞgrantreplicationslave3.Ö´ÐÐflushprivileges4.Í£Ö¹MySQL5.ÅäÖÃmy.cnf(my.ini)·þÎñÆ÷A·þÎñÆ÷Buser=my...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º263 ÆÀÂÛ£º1 ÈÕÆÚ£º2011-07-04 07:11:14 http://122.114.238.25/article-4425.html
MySQLÊý¾Ý¿âÖÐCHARÓëVARCHARÖ®Õù
ÔÚÊý¾Ý¿âÖУ¬×Ö·ûÐ͵ÄÊý¾ÝÊÇ×î¶àµÄ£¬¿ÉÒÔÕ¼µ½Õû¸öÊý¾Ý¿âµÄ80%ÒÔÉÏ¡£Îª´ËÕýÈ·´¦Àí×Ö·ûÐ͵ÄÊý¾Ý£¬¶ÔÓÚÌá¸ßÊý¾Ý¿âµÄÐÔÄÜÓкܴóµÄ×÷Óá£ÔÚ×Ö·ûÐÍÊý¾ÝÖУ¬ÓõÄ×î¶àµÄ¾ÍÊÇCharÓëVarcharÁ½ÖÖÀàÐÍ¡£Ç°ÃæµÄÊǹ̶¨³¤¶È£¬¶øºóÃæµÄÊǿɱ䳤¶È¡£ÏÖÔÚÎÒÃÇÐèÒª¿¼ÂǵÄÊÇ£¬ÔÚʲôÇé¿öÏÂʹÓÃChar×Ö·ûÐÍÊý¾Ý£¬Ê²Ã´Çé¿öϲÉÓÃVarchar×Ö·ûÐÍÊý¾Ý¡£ÔÚÕⲿ·ÖÄÚÈÝÖУ¬ÎҾ͸ú´ó¼ÒÀ´Ì½ÌÖÒ»ÏÂÕâ¸ö»°Ìâ¡£Ò»¡¢VARCHARÓëCHAR×Ö·ûÐÍÊý¾ÝµÄ²îÒìÔÚMySQLÊý...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º166 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-05-05 11:40:56 http://122.114.238.25/article-3414.html
Mysql limit ÓÅ»¯£¬°ÙÍòÖÁǧÍò¼¶¿ìËÙ·ÖÒ³£¬--¸´ºÏË÷ÒýµÄÒýÓò¢Ó¦ÓÃÓÚÇáÁ¿¼¶¿ò¼Ü
MySqlÐÔÄܵ½µ×ÄÜÓжà¸ß£¿ÓÃÁËphp°ëÄê¶à£¬ÕæÕýÈç´ËÉîÈëµÄȥ˼¿¼Õâ¸öÎÊÌ⻹ÊÇ´ÓÇ°Ì쿪ʼ¡£ÓйýÍ´¿àÓйý¾øÍû£¬µ½ÏÖÔÚ³äÂúÐÅÐÄ£¡MySqlÕâ¸öÊý¾Ý¿â¾ø¶ÔÊÇÊʺÏdba¼¶µÄ¸ßÊÖÈ¥ÍæµÄ£¬Ò»°ã×öÒ»µã1ÍòƪÐÂÎŵÄСÐÍϵͳÔõôд¶¼¿ÉÒÔ£¬ÓÃxx¿ò¼Ü¿ÉÒÔʵÏÖ¿ìËÙ¿ª·¢¡£¿ÉÊÇÊý¾ÝÁ¿µ½ÁË10Íò£¬°ÙÍòÖÁǧÍò£¬ËûµÄÐÔÄÜ»¹ÄÜÄÇô¸ßÂð£¿Ò»µãССµÄʧÎ󣬿ÉÄÜÔì³ÉÕû¸öϵͳµÄ¸Äд£¬ÉõÖÁ¸ü±¾ÏµÍ³ÎÞ·¨Õý³£ÔËÐУ¡ºÃÁË£¬²»ÄÇô¶à·Ï»°ÁË¡£ÓÃ...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º657 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-04-19 10:33:11 http://122.114.238.25/article-2834.html
MySQL×Ö¶ÎÀàÐÍ˵Ã÷
MySQLÖ§³Ö´óÁ¿µÄÁÐÀàÐÍ£¬Ëü¿ÉÒÔ±»·ÖΪ3ÀࣺÊý×ÖÀàÐÍ¡¢ÈÕÆÚºÍʱ¼äÀàÐÍÒÔ¼°×Ö·û´®(×Ö·û)ÀàÐÍ¡£±¾½ÚÊ×Ïȸø³ö¿ÉÓÃÀàÐ͵ÄÒ»¸ö¸ÅÊö£¬²¢ÇÒ×ܽáÿ¸öÁÐÀàÐ͵Ĵ洢ÐèÇó£¬È»ºóÌṩÿ¸öÀàÖеÄÀàÐÍÐÔÖʵĸüÏêϸµÄÃèÊö¡£¸ÅÊöÓÐÒâ¼ò»¯£¬¸üÏêϸµÄ˵Ã÷Ó¦¸Ã¿¼Âǵ½ÓйØÌض¨ÁÐÀàÐ͵ĸ½¼ÓÐÅÏ¢£¬ÀýÈçÄãÄÜΪÆäÖ¸¶¨ÖµµÄÔÊÐí¸ñʽ¡£ÓÉMySQLÖ§³ÖµÄÁÐÀàÐÍÁÐÔÚÏÂÃæ¡£ÏÂÁдúÂë×ÖĸÓÃÓÚÃèÊöÖУºMÖ¸³ö×î´óµÄÏÔʾ³ß´ç¡£×î´óµÄºÏ·¨µÄÏÔʾ³ß´çÊÇ255¡£DÊÊÓÃÓÚ¸¡µãÀàÐÍ...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º118 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-04-19 09:39:55 http://122.114.238.25/article-2833.html
MySQL.com±»SQL×¢Èë¹¥»÷ Óû§ÃÜÂëÊý¾Ý±»¹«²¼
¾ÝÀ´×ÔSucuri²©¿ÍµÄÏûÏ¢£¬MySQL¹Ù·½ÍøÕ¾MySQL.com±»SQL×¢Èë¹¥»÷(blindSQLinjection)¡£Ò»Æª²©¿ÍÎÄÕÂ(MySQL.comVulnerableToBlindSQLInjectionVulnerability)Åû¶ÁËMySQL.comÊý¾Ý¿âµÄ©¶´¼°Êý¾Ý¿â½á¹¹µÄdump²¿·Ö¡£VulnerableTarget£ºhttp://mysql.com/customers/view/index.htm...
À¸Ä¿£ºÐÂÎÅ×ÊѶ ÔĶÁ£º151 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-03-29 07:01:27 http://122.114.238.25/article-2069.html
PHPÓëMYSQLÊÂÎñ´¦Àí
MYSQLµÄÊÂÎñ´¦ÀíÖ÷ÒªÓÐÁ½ÖÖ·½·¨¡£1¡¢ÓÃbegin,rollback,commitÀ´ÊµÏÖbegin¿ªÊ¼Ò»¸öÊÂÎñrollbackÊÂÎñ»Ø¹öcommitÊÂÎñÈ·ÈÏ2¡¢Ö±½ÓÓÃsetÀ´¸Ä±ämysqlµÄ×Ô¶¯ÌύģʽMYSQLĬÈÏÊÇ×Ô¶¯Ìá½»µÄ£¬Ò²¾ÍÊÇÄãÌá½»Ò»¸öQUERY£¬Ëü¾ÍÖ±½ÓÖ´ÐУ¡ÎÒÃÇ¿ÉÒÔͨ¹ýsetautocommit=0½ûÖ¹×Ô¶¯Ìá½»setautocommit=1¿ªÆô×Ô¶¯Ìá½»À´ÊµÏÖÊÂÎñµÄ´¦Àí¡£µ±ÄãÓÃsetautocommit...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º194 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-03-25 16:18:39 http://122.114.238.25/article-1974.html
nginx+apache+mysql+php+memcached+squid´î½¨¼¯Èºweb»·¾³
·þÎñÆ÷µÄ´óÓû§Á¿µÄ³ÐÔØ·½°¸Ò»¡¢Ç°ÑÔ¶þ¡¢±àÒë°²×°Èý¡¢°²×°MySQL¡¢memcacheËÄ¡¢°²×°Apache¡¢PHP¡¢eAccelerator¡¢php-memcacheÎå¡¢°²×°SquidÁù¡¢ºó¼ÇÒ»¡¢Ç°ÑÔ£¬×¼±¸¹¤×÷µ±Ç°£¬LAMP¿ª·¢Ä£Ê½ÊÇWEB¿ª·¢µÄÊ×Ñ¡£¬ÈçºÎ´î½¨Ò»¸ö¸ßЧ¡¢¿É¿¿¡¢Îȶ¨µÄWEB·þÎñÆ÷Ò»Ö±ÊǸöÈÈÃÅÖ÷Ì⣬±¾ÎľÍÊÇÕâ¸öÖ÷ÌâµÄÒ»´Î³¢ÊÔ¡£ÎÒÃDzÉÓõļܹ¹Í¼ÈçÏ£ºÒý...
À¸Ä¿£ºLinux ÔĶÁ£º408 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-03-23 09:58:01 http://122.114.238.25/article-1919.html
MySQLÊý¾Ý¿âÓëMS SQL Server²»Í¬Ö®´¦µÄ±íÏÖ
ÒÔϵÄÎÄÕÂÖ÷ÒªÏò´ó¼Ò½éÉܵÄÊÇMSSQLServerÔÚʵ¼Ê²Ù×÷ÖкÍMySQLÊý¾Ý¿âµÄ²»Í¬£¬ÎÒÃÇ´ó¼Ò¶¼ÖªµÀMySQLÊý¾Ý¿âÔÚʵ¼ÊÓ¦ÓÃÖл¹ÊÇÕ¼ÓÐÒ»¶¨µÄ±ÈÀýµÄ£¬ÄÇôMSSQLServerÓÖÈçºÎ£¿ÒÔϵÄÎÄÕÂÖ÷Òª¾ÍÊǶÔMySQLÊý¾Ý¿âÓëMSSQLServerµÄÇø±ðµÄÃèÊö¡£MSSQLServerºÍMySQLÊý¾Ý¿âµÄÇø±ð£º1.MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQLServer²»Ö§³Ö2.MySQLÊý¾Ý¿â²»Ö§³Önchar,nvarchar,nte...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º142 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-03-20 10:42:37 http://122.114.238.25/article-1837.html
mysql֮ɾ³ýÖظ´Êý¾Ý
//ɾ³ýidÖظ´µÄÊý¾Ý£¬ÊʺÏidÊÇÊÖ¹¤Ö÷¼üdeletepersonasafrompersonasa,(select*,min(id)frompersongroupbyidhavingcount(1)>1)asbwherea.id=b.id//²éÕÒÖظ´µÄ£¬²¢ÇÒ³ýµô×îСµÄÄǸödeletetb_personasafromtb_personasa,(select*,min(id)fromtb_persongroupbynamehavingcount(1)>1...
À¸Ä¿£ºPHP´úÂë ÔĶÁ£º173 ÆÀÂÛ£º0 ÈÕÆÚ£º2011-03-20 10:41:33 http://122.114.238.25/article-1836.html
ÍƼöÐÅÏ¢
- linuxÃüÁîѧϰ±Ê¼Ç£¨11£©£ºnlÃüÁî
- MySQLË÷Òý±³ºóµÄÊý¾Ý½á¹¹¼°Ëã·¨ÔÀí
- mysql¿ª·¢ºÍÓÅ»¯µÄ36Ìõ¾ü¹æ
- mysql´¢´æʱ¼äÑ¡ÔñÔõÑùµÄ×Ö¶ÎÀàÐÍ
- ʹÓÃMySQL Proxy½â¾öMySQLÖ÷´Óͬ²½ÑÓ³Ù
- ¹ØÓÚmysql Ë÷ÒýµÄ×ܽá
- linuxÃüÁîѧϰ±Ê¼Ç£¨5£©£ºrmÃüÁî
- ¡¾ÊÓƵ²¥·Å¡¿JplayerÊÓƵ²¥·ÅÆ÷µÄʹÓÃ
- linuxÃüÁîѧϰ±Ê¼Ç£¨4£©£ºmkdirÃüÁî
- linuxÃüÁîѧϰ±Ê¼Ç£¨1£©£ºlsÃüÁî
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔؽø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
×î½ü¸üÐÂ
- PHP»ñÈ¡Óû§µÄÕæʵIP£¬²¢ÅжÏÊÇ·ñÄÚÍøIP
- ²éÕÒ²¢É¾³ý.svnĿ¼Îļþ
- redis ÆßÖÖÊý¾ÝÀàÐ͵ÄʹÓó¡¾°
- linux ÏÂÎļþ¸´ÖƵ½windowsÏÂÂÒÂëµÄ½â¾ö°ì·¨
- PHP ´íÎóÈÕÖ¾ error_log
- mysqlµÄsql_modeºÏÀíÉèÖÃ
- nginx³öÏÖ502 upstream sent too big he....
- linuxÏÂsudoÅäÖÃÏê½â
- linuxÃüÁîѧϰ±Ê¼Ç£¨15£©£ºtailÃüÁî
- linuxÃüÁîѧϰ±Ê¼Ç£¨14£©£ºheadÃüÁî