ÕýÔڲ鿴: ¹Ø¼ü×Ö mysql µÄËÑË÷½á¹û ( ¹² 72 Ìõ¼Ç¼ µÚ2Ò³/¹²8Ò³ )
ÉîÈëmysql "ON DUPLICATE KEY UPDATE" Óï·¨µÄ·ÖÎö
±¾ÆªÎÄÕÂÊǶÔmysql"ONDUPLICATEKEYUPDATE"Óï·¨½øÐÐÁËÏêϸµÄ·ÖÎö½éÉÜ£¬ÐèÒªµÄÅóÓѲο¼Ï£ºmysql"ONDUPLICATEKEYUPDATE"Óï·¨Èç¹ûÔÚINSERTÓï¾äĩβָ¶¨ÁËONDUPLICATEKEYUPDATE£¬²¢ÇÒ²åÈëÐкó»áµ¼ÖÂÔÚÒ»¸öUNIQUEË÷Òý»òPRIMARYKEYÖгöÏÖÖظ´Öµ£¬ÔòÔÚ³öÏÖÖظ´ÖµµÄÐÐÖ´ÐÐUPDATE£»Èç¹û²»»áµ¼ÖÂΨһֵÁÐÖظ´µÄÎÊÌ⣬Ôò²åÈëÐÂÐС£ÀýÈ磬Èç¹ûÁÐaΪÖ÷¼ü»òÓµÓÐUNIQU...
À¸Ä¿£ºMysql ÔĶÁ£º402 ÆÀÂÛ£º0 ÈÕÆÚ£º2015-04-07 17:07:35 http://122.114.238.25/article-15427.html
mysql½¨Á¢×éºÏË÷ÒýÔÔò
ÏÖʵÖУ¬mysql¿ÉÒÔ¸ù¾ÝÒµÎñÐèÒª½¨Á¢×éºÏË÷Òý£¬ÓÉÓÚmysqlʹÓÃB£Tree¸ñʽË÷Òý£¬¿ÉÒÔÖ±½Ó¶¨Î»¼Ç¼£¬ÎÞÐèɨÃè¡£mysql½¨Á¢¶àÁÐË÷ÒýÓÐ×î×óǰ׺µÄÔÔò£¬¼´×î×óÓÅÏÈ£¬È磺Èç¹ûÓÐÒ»¸ö2ÁеÄË÷Òý(col1,col2),ÔòÒѾ¶Ô(col1)¡¢(col1,col2)ÉϽ¨Á¢ÁËË÷Òý£»Èç¹ûÓÐÒ»¸ö3ÁÐË÷Òý(col1,col2,col3)£¬ÔòÒѾ¶Ô(col1)¡¢(col1,col2)ºÍ(col1,col2,col3)ÉϽ¨Á¢...
À¸Ä¿£ºMysql ÔĶÁ£º418 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-12-22 15:14:53 http://122.114.238.25/article-15419.html
ubuntuϵÄnginx+php+mysqlÅäÖÃ
ÕâЩÌìÓÖ¿´ÁËһЩubuntuÏÂphp+nginxµÄÅäÖ÷½ÃæµÄ×ÊÁÏ£¬½ñÌì¼Ç¼ÓÚ´Ë£¬´ó¼ÒÓÐʱ¼ä¶à²Ù×÷Ï¡£PS£º¶ÔÓÚ±àÒë°æµÄµÈÎÒʵ¼Ê²Ù×÷ºó»áÔÙÌùһƪÎÄÕ£¡1¡¢¸üÐÂsudoapt-getupdate2¡¢°²×°nginxsudoapt-getintsallnginxUbuntu°²×°Ö®ºóµÄÎļþ½á¹¹´óÖÂΪ:*ËùÓеÄÅäÖÃÎļþ¶¼ÔÚ/etc/nginxÏÂ,²¢ÇÒÿ¸öÐéÄâÖ÷»úÒѾ°²ÅÅÔÚÁË/etc/nginx/sites-availableÏÂ*
À¸Ä¿£ºMysql ÔĶÁ£º2946 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-05-28 17:15:28 http://122.114.238.25/article-15407.html
[MySqL] ¹ØÓÚMySqlÖеÄvarcharÀàÐÍ
½ñÌìпªÊ¼µÄÏîÄ¿ÔÚ×öÊý¾Ý¿âÉè¼Æʱ£¬·¢ÏÖ×Ô¼º¶ÔMySqlµÄvarcharÀàÐÍ»¹²»ÊìϤ£¬¹ÊÓÖÉÏÍøÊÕ¼¯×ÊÁÏÕûÀíÈçÏ¡£1¡¢varcharÀàÐ͵ı仯MySQLÊý¾Ý¿âµÄvarcharÀàÐÍÔÚ4.1ÒÔϵİ汾ÖеÄ×î´ó³¤¶ÈÏÞÖÆΪ255£¬ÆäÊý¾Ý·¶Î§¿ÉÒÔÊÇ0~255»ò1~255£¨¸ù¾Ý²»Í¬°æ±¾Êý¾Ý¿âÀ´¶¨£©¡£ÔÚMySQL5.0ÒÔÉϵİ汾ÖУ¬varcharÊý¾ÝÀàÐ͵ij¤¶ÈÖ§³Öµ½ÁË65535£¬Ò²¾ÍÊÇ˵¿ÉÒÔ´æ·Å65532¸ö×Ö½ÚµÄÊý¾Ý£¬Æðʼ
À¸Ä¿£ºMysql ÔĶÁ£º2797 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-05-25 10:59:35 http://122.114.238.25/article-15406.html
MySQLÖÐÌá¸ßOrder By Rand()Ö´ÐÐЧÂʵÄÓÅ»¯·½·¨
×î½üÓÉÓÚÐèÒª´ó¸ÅÑо¿ÁËÒ»ÏÂMYSQLµÄËæ»ú³éȡʵÏÖ·½·¨¡£¾Ù¸öÀý×Ó£¬Òª´Ótablename±íÖÐËæ»úÌáÈ¡Ò»Ìõ¼Ç¼£¬´ó¼ÒÒ»°ãµÄд·¨¾ÍÊÇ£ºSELECT*FROMtablenameORDERBYRAND()LIMIT1¡£µ«ÊÇ£¬ºóÀ´ÎÒ²éÁËÒ»ÏÂMYSQLµÄ¹Ù·½ÊֲᣬÀïÃæÕë¶ÔRAND()µÄÌáʾ´ó¸ÅÒâ˼¾ÍÊÇ£¬ÔÚORDERBY´Ó¾äÀïÃæ²»ÄÜʹÓÃRAND()º¯Êý£¬ÒòΪÕâÑù»áµ¼ÖÂÊý¾ÝÁỶà´ÎɨÃè¡£µ«ÊÇÔÚMYSQL3.23°æ±¾ÖУ¬ÈÔÈ»
À¸Ä¿£ºMysql ÔĶÁ£º3214 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-04-04 06:33:35 http://122.114.238.25/article-15389.html
MySQL InnoDB Ëø»úÖÆÏê½â
ΪʲôÎÒÃÇÐèÒªËø£¿Ïȱð¼±×Żش𡢻ØÏëÒ»ÏÂÎÒÃÇÔÚ¹äÌÔ±¦Ï¶©µ¥Ê±µÄÒ»¸ö³¡¾°£ºInnoDBÊÇÐÐËø¡¢²»´æÔÚËøÉý¼¶ÎÊÌâ¡¢Ò²¾ÍÊÇ¡¢Ëøס1ÐкÍËøס1ǧÍòÐеĿªÏúÊÇÒ»Ñù,µ«ÊÇ¡¢InnoDBÐÐËøÈÔÈ»´æÔÚÒ»°ãµÄËøÔڸ߲¢·¢ÏÂËùÌØÓеÄ"ÁÓ¸ùÐÔ":¡ñ¶ªÊ§¸üУºAµÄÐ޸ı»B¸²¸Ç¡¢Î½Ö®"Ç°ÀË×ܱ»ºóÀ˸Ç"¡ñÔà¶Á£º²»Í¬ÊÂÎñ¼ä¡¢¶Áµ½Î´Ìá½»µÄÊý¾Ý¡ñ²»¿ÉÖظ´¶Á£ºÍ¬Ò»ÊÂÎñ¡¢Á½´Î¶Á²»Í¬Íâ¼üÎÞË÷ÒýÊÇOracleËÀËø·¢ÉúµÄ³£¼ûÔÒò¡¢¶øÔÚInnoDB¡¢ÎÒ¸Ï
À¸Ä¿£ºMysql ÔĶÁ£º3446 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-04-04 06:29:24 http://122.114.238.25/article-15388.html
MySQL 5.7.4 ·¢²¼£¬²éѯÐÔÄÜÌáÉý 1 ±¶
MySQL5.7.4¿ª·¢°æ·¢²¼ÁË£¬ÏÂÔصØÖ·£ºhttp://dev.mysql.com/downloads/mysql/#downloads¸Ã°æ±¾µÄ²éѯÐÔÄܵÃÒÔ´ó·ùÌáÉý£¬±ÈMySQL5.6ÌáÉý1±¶£¬ÏêϸÃèÊöÇë¿´ChangeHistoryа汾µÄMySQLÔÚ²âÊÔƽ̨ÉϿɴﵽÿÃë512000Ö»¶ÁQPS£¬¶øMySQL5.6×î¸ßÖ»Äܵ½250000QPS¡£¸ÃÐÔÄܵÄÌáÉýÊÇͨ¹ýÆäMemcached²å¼þʵÏֵġ£Í¬Ê±¸Ã°æ±¾ÔÚÊý¾Ý¿âÆäËû·½Ãæ...
À¸Ä¿£ºÐÂÎÅ×ÊѶ ÔĶÁ£º2779 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-04-01 11:19:24 http://122.114.238.25/article-15373.html
linux¸ß¸ºÔØϳ¹µ×ÓÅ»¯mysqlÊý¾Ý¿â
ÓÑÇéÌáʾ£ºÍ¬Ê±ÔÚÏß·ÃÎÊÁ¿¼ÌÐøÔö´ó¶ÔÓÚ1GÄÚ´æµÄ·þÎñÆ÷Ã÷ÏԸоõµ½³ÔÁ¦ÑÏÖØʱÉõÖÁÿÌ춼»áËÀ»ú»òÕßʱ²»Ê±µÄ·þÎñÆ÷¿¨Ò»ÏÂÕâ¸öÎÊÌâÔø¾À§ÈÅÁËÎÒ°ë¸ö¶àÔÂMySQLʹÓÃÊǺܾßÉìËõÐÔµÄËã·¨£¬Òò´ËÄãͨ³£ÄÜÓúÜÉÙµÄÄÚ´æÔËÐлò¸øMySQL¸ü¶àµÄ±»´æÒԵõ½¸üºÃµÄÐÔÄÜ¡£Í¬Ê±ÔÚÏß·ÃÎÊÁ¿¼ÌÐøÔö´ó¶ÔÓÚ1GÄÚ´æµÄ·þÎñÆ÷Ã÷ÏԸоõµ½³ÔÁ¦ÑÏÖØʱÉõÖÁÿÌ춼»áËÀ»ú»òÕßʱ²»Ê±µÄ·þÎñÆ÷¿¨Ò»ÏÂÕâ¸öÎÊÌâÔø¾À§ÈÅÁËÎÒ°ë¸ö¶àÔÂ,MySQLʹÓÃÊǺܾßÉìËõÐÔµÄËã·¨£¬Òò´ËÄãͨ
À¸Ä¿£ºMysql ÔĶÁ£º527 ÆÀÂÛ£º0 ÈÕÆÚ£º2014-03-13 23:11:06 http://122.114.238.25/article-15322.html
mysql´¦Àíº£Á¿Êý¾ÝʱµÄһЩÓÅ»¯²éѯËٶȷ½·¨
ÓÉÓÚÔÚ²ÎÓëµÄʵ¼ÊÏîÄ¿Öз¢ÏÖµ±mysql±íµÄÊý¾ÝÁ¿´ïµ½°ÙÍò¼¶Ê±£¬ÆÕͨSQL²éѯЧÂʳÊÖ±ÏßϽµ£¬¶øÇÒÈç¹ûwhereÖеIJéѯÌõ¼þ½Ï¶àʱ£¬Æä²éѯËٶȼòÖ±ÎÞ·¨ÈÝÈÌ¡£Ôø¾²âÊÔ¶ÔÒ»¸ö°üº¬400¶àÍòÌõ¼Ç¼£¨ÓÐË÷Òý£©µÄ±íÖ´ÐÐÒ»ÌõÌõ¼þ²éѯ£¬Æä²éѯʱ¼ä¾¹È»¸ß´ï40¼¸Ã룬ÏàÐÅÕâô¸ßµÄ²éѯÑÓʱ£¬ÈκÎÓû§¶¼»á×¥¿ñ¡£Òò´ËÈçºÎÌá¸ßsqlÓï¾ä²éѯЧÂÊ£¬ÏÔµÃÊ®·ÖÖØÒª¡£ÒÔÏÂÊÇÍøÉÏÁ÷´«±È½Ï¹ã·ºµÄ30ÖÖSQL²éѯÓï¾äÓÅ»¯·½·¨£º1
À¸Ä¿£ºMysql ÔĶÁ£º528 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-12-22 23:10:11 http://122.114.238.25/article-15299.html
mysql ²éѯij×Ö¶ÎÀﺬÓÐ(»òÕß²»º¬)ij×Ö·ûµÄËùÓмǼ·½·¨
selectgid,usernamefromuserswhereFIND_IN_SET(8,gid);//²éѯgidÀﺬÓÐÊý×Ö8µÄ¼Ç¼£¬gidÊÇvarchar,Êý¾Ý¸ñʽ:"1,12,8,18,5"selectgid,usernamefromuserswhere!FIND_IN_SET(8,gid);//²éѯgidÀï²»º¬ÓÐÊý×Ö8µÄ¼Ç¼£¬gidÊÇvarchar,Êý¾Ý¸ñʽ:"1,12,8,18,5"
À¸Ä¿£ºMysql ÔĶÁ£º627 ÆÀÂÛ£º0 ÈÕÆÚ£º2013-03-29 11:23:54 http://122.114.238.25/article-15283.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ÃüÁî