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

sqlС¼Æ»ã×Ü rollupÓ÷¨ÊµÀý·ÖÎö

 ÕâÀï½éÉÜsql server2005ÀïÃæµÄÒ»¸öʹÓÃʵÀý£º
CREATE TABLE tb(province nvarchar(10),city nvarchar(10),score int)
INSERT tb SELECT 'ÉÂÎ÷','Î÷°²',3
UNION ALL SELECT 'ÉÂÎ÷','°²¿µ',4
UNION ALL SELECT 'ÉÂÎ÷','ººÖÐ',2
UNION ALL SELECT '¹ã¶«','¹ãÖÝ',5
UNION ALL SELECT '¹ã¶«','Ö麣',2
UNION ALL SELECT '¹ã¶«','¶«Ý¸',3
UNION ALL SELECT '½­ËÕ','ÄϾ©',6
UNION ALL SELECT '½­ËÕ','ËÕÖÝ',1
GO
1¡¢ Ö»ÓÐÒ»¸ö»ã×Ü
select province as Ê¡,sum(score) as ·ÖÊý from tb group by province with rollup
½á¹û£º
¹ã¶« 10
½­ËÕ 7
ÉÂÎ÷ 9
NULL 26
select case when grouping(province)=1 then 'ºÏ¼Æ' else province end as Ê¡,sum(score) as ·ÖÊý from tb group by province with rollup
½á¹û£º
¹ã¶« 10
½­ËÕ 7
ÉÂÎ÷ 9
ºÏ¼Æ 26
2¡¢Á½¼¶£¬ÖмäС¼Æ×îºó»ã×Ü
select province as Ê¡,city as ÊÐ,sum(score) as ·ÖÊý from tb group by province,city with rollup
½á¹û£º
¹ã¶« ¶«Ý¸ 3
¹ã¶« ¹ãÖÝ 5
¹ã¶« Ö麣 2
¹ã¶« NULL 10
½­ËÕ ÄϾ© 6
½­ËÕ ËÕÖÝ 1
½­ËÕ NULL 7
ÉÂÎ÷ °²¿µ 4
ÉÂÎ÷ ººÖÐ 2
ÉÂÎ÷ Î÷°² 3
ÉÂÎ÷ NULL 9
NULL NULL 26
select province as Ê¡,city as ÊÐ,sum(score) as ·ÖÊý,grouping(province) as g_p,grouping(city) as g_c from tb group by province,city with rollup
½á¹û£º
¹ã¶« ¶«Ý¸ 3 0 0
¹ã¶« ¹ãÖÝ 5 0 0
¹ã¶« Ö麣 2 0 0
¹ã¶« NULL 10 0 1
½­ËÕ ÄϾ© 6 0 0
½­ËÕ ËÕÖÝ 1 0 0
½­ËÕ NULL 7 0 1
ÉÂÎ÷ °²¿µ 4 0 0
ÉÂÎ÷ ººÖÐ 2 0 0
ÉÂÎ÷ Î÷°² 3 0 0
ÉÂÎ÷ NULL 9 0 1
NULL NULL 26 1 1
select case when grouping(province)=1 then 'ºÏ¼Æ' else province end Ê¡,
case when grouping(city)=1 and grouping(province)=0 then 'С¼Æ' else city end ÊÐ,
sum(score) as ·ÖÊý
from tb group by province,city with rollup
½á¹û£º
¹ã¶« ¶«Ý¸ 3
¹ã¶« ¹ãÖÝ 5
¹ã¶« Ö麣 2
¹ã¶« С¼Æ 10
½­ËÕ ÄϾ© 6
½­ËÕ ËÕÖÝ 1
½­ËÕ Ð¡¼Æ 7
ÉÂÎ÷ °²¿µ 4
ÉÂÎ÷ ººÖÐ 2
ÉÂÎ÷ Î÷°² 3
ÉÂÎ÷ С¼Æ 9
ºÏ¼Æ NULL 26
±¾ÎÄÀ´×Ô: ½Å±¾Ö®¼Ò(www.jb51.net) Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/18860.htm


Ïà¹ØÎĵµ£º

SQL ×Ö·û´®Óë16½øÖÆ»¥»»

ÔÚÍøÉÏ¿´µ½SQL×Ö·û´®×ª16½øÖƵÄÓï¾ä£¬¾­¹ýССÌí¼Ó£¬ÏÖ½«SQL×Ö·û´®Óë16½øÖÆ»¥»»µÄ·½·¨¼Ç¼£¬ÒÔ¹©ÒÔºó²é¿´¡£ 
--SQL char->HEX code
DECLARE @str VARCHAR(4000)
SET @str='SELECT * from dbo.TaskHistory' --Your sql char
DECLARE @i INT,@Asi INT,@ModS INT,@res VARCHAR(800),@Len INT,@Cres VARCHAR(4),@te ......

µÚ10Õ£ºSQLºÍTQuery¶ÔÏó

±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......

phpmyadmin ÐÞ¸ÄÖ´ÐÐsqlÎļþ´óСÏÞÖÆ

phpmyadmin ÐÞ¸ÄÖ´ÐÐsqlÎļþ´óСÏÞÖÆ
´ò¿ªphp.ini
post_max_size = 100M       ; ±íµ¥Ìá½»Îļþ´óСÉÏÏÞ
memory_limit = 128M    ; ÄÚ´æÉÏÏÞ
upload_max_filesize = 100M ; ÉÏ´«Îļþ´óСÉÏÏÞ
ÐÞ¸ÄÒÔÉÏÈýÏ¾Í¿ÉÒÔ½â¾ö¡£ µ«ÊÇ´ËʱPHPMYADMINÖÐ×î´óÏÞÖÆ£º22,528 KB£¬ ......

ʵÓÃSQL語¾ä

http://blog.csdn.net/fenglibing/archive/2007/10/24/1841537.aspx
1¡¢½«Ò»¸ö±íÖеÄÄÚÈÝ¿½±´µ½ÁíÍâÒ»¸ö±íÖÐ
insert into testT1(a1,b1,c1) select a,b,c from test;
insert into testT select * from test; (Ç°ÌáÊÇ兩個±íµÄ結構ÍêÈ«Ïàͬ)
 
insert into notebook(id,title,content)
se ......

sql È«ÎÄË÷Òý

1¡¢ÒªÆôÓÃÈ«ÎÄË÷Òý¹¦ÄÜÊ×ÏÈÐèÒª°²×°full text searchÈ«ÎÄË÷Òý·þÎñ
2¡¢Æô¶¯full text search·þÎñ
3¡¢ÏÈ´´½¨UniqueË÷ÒýºÍÈ«ÎÄË÷Òý£ºCREATE FULLTEXT INDEX ON table_name
4¡¢Ã¿¸ö±íÖ»ÔÊÐí´´½¨Ò»¸öÈ«ÎÄË÷Òý
ɾ³ýÈ«ÎÄË÷Òý DROP FULLTEXT INDEX ON table_name
È«ÎÄËÑË÷Óï¾ä£¬contains(),freeText()
×¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ