MysqlÖÐcount(*),DISTINCTµÄʹÓ÷½·¨ºÍЧÂÊÑо¿
ÔÚ´¦ÀíÒ»¸ö´óÊý¾ÝÁ¿Êý¾Ý¿âµÄʱºò
ͻȻ·¢ÏÖmysql¶ÔÓÚcount(*)µÄ²»Í¬´¦Àí»áÔì³É²»Í¬µÄ½á¹û
±ÈÈçÖ´ÐÐ
SELECT count(*) from tablename
¼´Ê¹¶ÔÓÚǧÍò¼¶±ðµÄÊý¾ÝmysqlÒ²Äܷdz£Ñ¸Ëٵķµ»Ø½á¹û
¶ø¶ÔÓÚ
SELECT count(*) from tablename WHERE…..
mysqlµÄ²éѯʱ¼ä¿ªÊ¼ÅÊÉý
×Ðϸ²éÔÄÀÛÏÂÊÖ²á,·¢ÏÖµ±Ã»ÓÐWHEREÓï¾ä¶ÔÓÚÕû¸ömysqlµÄ±í½øÐÐcountÔËËãµÄʱºò
MyISAMÀàÐ͵ıíÖб£´æÓÐ×ܵÄÐÐÊý,¶øµ±Ìí¼ÓÓÐWHEREÏÞ¶¨Óï¾äµÄʱºòMysqlÐèÒª¶ÔÕû¸ö±í½øÐмìË÷
´Ó¶øµÃ³öcountµÄÊýÖµ
ͻȻÓÖÏëÆðÀ´¿´µ½µÄ²»ÉÙÐÂÐ˵Äphp³ÌÐò¶ÔÓÚcountµÄ´¦Àí²¢Ã»ÓкܺõÄÒâʶµ½Õâµã
¼Ç¼ÏÂ
˳±ãÌáÏÂmysqlµÄDISTINCTµÄ¹Ø¼ü×ÖÓкܶàÄãÏë²»µ½µÄÓô¦
1.ÔÚcount ²»Öظ´µÄ¼Ç¼µÄʱºòÄÜÓõ½
±ÈÈçSELECT COUNT( DISTINCT id ) from tablename;
¾ÍÊǼÆËãtalbebname±íÖÐid²»Í¬µÄ¼Ç¼ÓжàÉÙÌõ
2,ÔÚÐèÒª·µ»Ø¼Ç¼²»Í¬µÄidµÄ¾ßÌåÖµµÄʱºò¿ÉÒÔÓÃ
±ÈÈçSELECT DISTINCT id from tablename;
·µ»Øtalbebname±íÖв»Í¬µÄidµÄ¾ßÌåµÄÖµ
3.ÉÏÃæµÄÇé¿ö2¶ÔÓÚÐèÒª·µ»Ømysql±íÖÐ2ÁÐÒÔÉϵĽá¹ûʱ»áÓÐÆçÒå
±ÈÈçSELECT DISTINCT id, type from tablename;
ʵ¼ÊÉÏ·µ»ØµÄÊÇ idÓëtypeͬʱ²»ÏàͬµÄ½á¹û,Ò²¾ÍÊÇDISTINCTͬʱ×÷ÓÃÁËÁ½¸ö×ֶΣ¬±ØÐëµÃidÓëtyoe¶¼ÏàͬµÄ²Å±»ÅųýÁË,ÓëÎÒÃÇÆÚÍûµÄ½á¹û²»Ò»Ñù
4.Õâʱºò¿ÉÒÔ¿¼ÂÇʹÓÃgroup_concatº¯ÊýÀ´½øÐÐÅųý,²»¹ýÕâ¸ömysqlº¯ÊýÊÇÔÚmysql4.1ÒÔÉϲÅÖ§³ÖµÄ
5.Æäʵ»¹ÓÐÁíÍâÒ»ÖÖ½â¾ö·½Ê½,¾ÍÊÇʹÓÃ
SELECT id, type, count(DISTINCT id) from tablename
ËäÈ»ÕâÑùµÄ·µ»Ø½á¹û¶àÁËÒ»ÁÐÎÞÓõÄcountÊý¾Ý(»òÐíÄã¾ÍÐèÒªÕâ¸öÎÒ˵µÄÎÞÓÃÊý¾Ý)
·µ»ØµÄ½á¹ûÊÇ Ö»ÓÐid²»Í¬µÄËùÓнá¹ûºÍÉÏÃæµÄ4ÀàÐÍ¿ÉÒÔ»¥²¹Ê¹ÓÃ,¾ÍÊÇ¿´ÄãÐèҪʲôÑùµÄÊý¾ÝÁË
PS:
Ô½À´Ô½·¢ÏÖÓкܶàϸ½ÚÊÇÐèҪȥ̽¾¿µÄ,
Ô½À´Ô½·¢ÏÖ×Ô¼ºÐ´ÎÄ×ÖÕæµÄºÜÔÓÂÒ,
ÓпÕÑо¿ÏÂDISTINCTµÄЧÂÊ
Ïà¹ØÎĵµ£º
mysql ÃüÁîѧϰ£º
1. mysql -uroot ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ; //ÏÔʾËùÓеÄÊý¾Ý¿â ;
4.show tables ; ......
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽ ......
1:>;create databases newname(ÔÚеÄserverÉϽ¨Á¢¿ÕµÄÊý¾Ý¿â)
2:#/usr/local/mysql/bin/mysqldump databasename >;*.sql(ÔھɵķþÎñÆ÷Éϵ¼³öÊý¾Ý¿â)
3:#/usr/local/mysql/bin/mysql databasename < *.sql(ÔÚеķþÎñÆ÷Éϵ¼Èë*.sql) ......
1¡¢´ò¿ªMyEclipse6.6
2¡¢Ñ¡Ôñ²Ëµ¥£ºWindow/Open Perspective/MyEclipse Database Explorer£¬µã»÷OK£¬ÔÚ×ó±ß´ò¿ªDB Brower´°¿Ú¡£
3¡¢ÔÚDB Brower´°¿ÚÄÚÈÎÒâ¿Õ°×´¦»÷ÓÒ¼ü£¬Ñ¡ÔñNewÃüÁµ¯³öDatabase Driver´°¿Ú
4¡¢±¾´°¿Ú¸÷Ïî˵Ã÷£º
Driver template: MySQL Connector/J Ñ¡ÔñÇý¶¯Ä£°å
& ......