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
ÏÖÔÚ¶Ô´íÎó¸öÊýÕâÁÐÇóÖµ£¡£¡
ллÀÏʦ£¬ÎÒÏȲâÊÔһϣ¡
ÊÇCOUNT(*)£¿
SELECT ×Ö¶ÎÃû,COUNT(*) from TT GROUP BY ×Ö¶ÎÃû
ÀÏʦ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002 ......
±íÁÐ×Ö¶ÎÔÚÎÞÖµµÄÇé¿öÏÂ
ĬÈÏֵΪnullºÃ,»¹Êǿհ×ÖµºÃÄØ?
1)¶ÔÊý¾Ý²åÈë/²éѯ/µÄÓ°ÏìÈçºÎ?
2)¶Ô¸ÃÁнøÐÐË÷Òý,»áÓв»Í¬µÄЧÓÃô?
´ó¼ÒÒ»°ã¶Ô±êÌâ×ֶεÄλÊýÉèΪ¶àÉÙ?256
ÕýÎÄ×ֶεÄ?text?
¼¸Ç§ÍòÌõµÄÊý¾Ý´æ´¢,Òª ......