mysqlÖÐÊôÐÔΪvarcharÀàÐ͵ÄÁеÄÖµÇóºÍ?(ÔÚÏߵȣ¡)

ÏÂÃæµÄÓï¾äÊÇÇóºÍÓï¾ä£ºµ«ÊÇsum(ÁÐÃû) ¶ÔijһÁеÄÖµÇóºÍ£¬µ«ÊôÐÔ±ØÐëÊÇÕûÐÍ
select sum(×Ö¶Î)as a from table where .....

ÏÖÔÚÎÒµÄÁÐÊôÐÔΪvarcharÀàÐÍ£¬ÇëÎÊÔõôÇóºÍ£¿ÇëÀÏʦָµã£¬±È½Ï¼±£¡£¡

---

select sum(0+×Ö¶Î) as a from table where .....

---

½¨±íÓï¾äÌùһϰɣ¬ÎÒ»³ÒÉLZÒªµÄ²»ÊÇ sum(),¿ÉÄÜÊÇcount()...

---

×Ö¶ÎÃû ×Ö¶ÎÀàÐÍ ¿í¶È ˵Ã÷
оƬ±àºÅ   varchar        20 ×Ö·û ·ÇNULL
оƬÅú´Î   varchar        20 ×Ö·û ·ÇNULL
оƬÐͺŠ  varchar        20 ×Ö·û ·ÇNULL
Ô±¹¤¹¤ºÅ   varchar        10 ×Ö·û ·ÇNULL
¼ì²âʱ¼ä   varchar        20 ×Ö·û ·ÇNULL
ȱÏÝÀàÐÍ   varchar        20 ×Ö·û ·ÇNULL
¼ì²âÏî   varchar        10 ×Ö·û ·ÇNULL
¼ì²â½á¹û   varchar        6 ×Ö·û ·ÇNULL
´íÎó¸öÊý   varchar        10 ×Ö·û ·ÇNULL
´íÎó±ÈÀý   varchar        20 ×Ö·û ·ÇNULL


ÏÖÔÚ¶Ô´íÎó¸öÊýÕâÁÐÇóÖµ£¡£¡

---

ÒýÓÃ

select sum(0+×Ö¶Î) as a from table where .....

ллÀÏʦ£¬ÎÒÏȲâÊÔһϣ¡

---

ÊÇCOUNT(*)£¿
SELECT ×Ö¶ÎÃû,COUNT(*) from TT GROUP BY ×Ö¶ÎÃû

---

ÒýÓÃ

ÊÇCOUNT(*)£¿
SELECT ×Ö¶ÎÃû,COUNT(*) from TT GROUP BY ×Ö¶ÎÃû

ÀÏʦ