mysqlµÄһЩ¸ß¼¶Óï¾ä
Ò»,½ñÌì¸ø´ó¼Ò½²Ò»ÏÂ,×öÁôÑÔµÄÒ»ÖÖ×·¼ÓµÄ·½Ê½Ö÷ÒªÈç¹ûµ±Ç°ÓÐÁôÑÔ,¾Í¸üе±Ç°µÄÁôÑÔÒÔ×·¼ÓµÄ·½Ê½,Èç¹ûûÄÜÁôÑԾͽ«ÈëÒ»ÌõеÄ
mysql:insert into `table` (field) values ('$value') on duplicate key update `field`=concat('value',ifnull(`field`,''));
¾ßÌå±¾ÌõSQLµÄÓ÷¨,Çë²é¿´ÊÖ²á
¶þ,½²Ò»ÏÂͳ¼ÆµÄÓ÷¨,Ö÷Òª½éÉÜÈçºÎÓÃÒ»ÌõSQLÓï¾ä,ͳ¼Æij¸öÓû§µÄij¸ö×Ö¶ÎÖв»Í¬×´Ì¬µÄºÏ
Ê×ÏÈ,(select t.username,t.action,count(*) as num from t group by t.username,t.action) as NÓ÷Ö×éµÄ·½Ê½½«²»Í¬µÄÓû§ÖеÄij¸ö×ֶεÄijЩ״̬·Ö×éÇóºÏÕâÊÇ×Ó¾ä
È»ºó,select N.username,max(CASE N.action where 'field1' then n.num else 0 end) as field1_num,max(CASE N.action where 'field2' then n.num else 0 end) as field2_num from ,(select t.username,t.action,count(*) as num from t group by t.username,t.action) as N group by N.username
È»ºó·Ö±ðÏÔʾusername,field1_num,field2_num
Ïà¹ØÎĵµ£º
¸öÈËÀͶ¯£¬»¹Çë×ðÖØ£¬ÈçÈôתÔØÇë×¢Ã÷³ö´¦¡£iihero@CSDN
¿´µ½ÓÐЩÅóÓÑÀÏÎÊÕâ¸ö·Ç°²×°°æÓë°²×°°æÓÐʲôÇø±ð£¨µ±È»ÊÇwindowsƽ̨)
¸É´àдÁËÒ»¸ö½Å±¾×Ô¶¯ÎªÆä´´½¨mysql5·þÎñ¡£
½Å±¾ÈçÏ£¬½«Æä·Åµ½½âѹÒÔºóµÄĿ¼Àï±ßÖ´Ðм´¿É¡£
@echo off
echo "This is a demo script for auto installation of noninstall version o ......
mysqlÊýÖµ·¶Î§
tinyint -128~127 0~255
smallint -32768~32767 0~65535
mediumint -8388608~8388607 0~16777215
int -2147483648~2147483647 0~4294967295
bigint -9223372036854775808~9223372036854775807 0~18446744073709551615
javaÖÐ
byte ......
query_cache_min_res_unit ²éѯ»º´æ·ÖÅäµÄ×îС¿éµÄ´óС(×Ö½Ú)
query_alloc_block_size Ϊ²éѯ·ÖÎöºÍÖ´Ðйý³ÌÖд´½¨µÄ¶ÔÏó·ÖÅäµÄÄÚ´æ¿é´óС
Qcache_free_blocks´ú±íÄÚ´æ×ÔÓÉ¿éµÄ¶àÉÙ£¬·´Ó³ÁËÄÚ´æËéƬµÄÇé¿ö
==========================
1£©µ±²éѯ½øÐеÄʱºò£¬Mysql°Ñ²éѯ½á¹û±£´æÔÚqurey ......
1£ºMysql ÃüÁî²»¿ÉÒÔÖ´ÐÐ
ÔÒò £ººÇºÇ ±ÈÈç show databases µÄÃüÁî £¬Ö´ÐÐÍêÖ®ºó ɶҲûÓÐ £¬×Ðϸ ÕÒÁËÔÒò £¬Oh my god ÉÙÁË ·ÖºÅ¡£
Ӧд³É£ºshow databases;
2£ºÃüÁîÐÐÖÐÎÄÂÒÂëÎÊÌâ
ÏÖÏó£ºmysqlµÄĬÈϱàÂëÉèÖÃΪutf-8£¬Ò³ÃæÒÔutf-8µÄ±àÂ뷽ʽдÈëµ½Êý¾Ý¿â¡£Óù¤¾ß²é¿´Ò»ÇÐÕý³££¬µ«´ÓmysqlµÄÃüÁîÐжÁÊý¾Ý³öÀ´× ......
CREATE PROCEDURE pro_page(
in _sql varchar(1000),
in _order varchar(1000),
in _pagecurrent int,
in _pagesize int
)
BEGIN
if _pagesize<=1 then
set _pagesize=20;
end if;
if _pagecurrent < 1 then
set _pagecurrent = 1;
&n ......