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´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G ²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇ¼à¿ØMYSQL¸´ÖÆÄ³¸ö´Ó·þÎñÆ÷µÄÊä³ö£º
mysql> show slave status\G
*************************** 1. row ***************************
&nbs ......
ÎÊÌ⣺
1¡¢Êý¾Ý¿âĬÈϵÄ×Ö·û¼¯ÉèÖÃΪUTF-8£»
2¡¢Í¨¹ýibatis¶ÁдÊý¾ÝÖÐÎÄÕý³££»
3¡¢µ«ÊÇÓÃwindowsÃüÁîÐÐÖ´ÐÐselectÓï¾äÖÐÎÄÏÔʾÂÒÂë¡£
½â¾ö£º
Êý¾Ý¿âÓû§µÇ¼ʱ²ÎÊýÉ趨×Ö·û¼¯£º
mysql --default-character-set=gb2312 -u Óû§Ãû -p
£¨¹À¼ÆºÍwindowsµÄcmdÃüÁîÐÐÓйأ© ......
ת×Ôhttp://blog.csdn.net/ytz_linuxer/archive/2009/07/04/4321259.aspx
ÒÔ°æ±¾phpMyAdmin-2.6.1.tar.gzΪÀý
ÏȽâѹphpMyAdmin-2.6.1.tar.gzµ½/usr/local/apache2/htdocs£¬
µÃµ½Îļþ¼ÐphpMyAdmin-2.6.1£¬½«ÆäÖØÃüÃûΪphpmyadmin,(ÕâÑùÔÚÒÔºóµÄ²Ù×÷Öн«»á±äµÄ¼ò±ã)¡£
  ......
×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾¹ýÍ´¿àµÄÒ»¶Î¾Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¬²»ÓñàÒ룬ÏÂÔØµØÖ·£º
http://dev.mysql.com/downloads/
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´ ......
ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇ
InnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙĿǰ²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL
4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØÏµµ ......