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

ÇóÒ»¸ömysql ×ֶβð·ÖËÑË÷sqlÓï¾ä

±êÌâ½²²»Çå³þ¹þ¡­¡­¡­¡­


Êý¾Ý´æ´¢¸ñʽ

×Ö¶ÎÃû      Êý¾Ý
year      2009
month      11
days      |2:40|3:23|4:21|  ......    (½âÊÍ,Ç°ÃæÊÇÈÕÆÚ£¬ºóÃæÊǼ۸ñ  ÈÕÆÚ:¼Û¸ñ)

ÎÒÏë²»³öÆäËûµÄÊý¾Ý½á¹¹ÁË£¬ÒòΪÐèÒª½«ºǫ́ÊäÈëµÄÈÕÆÚÉú³É1Äê365Ì죬ÒÔÄêºÍÔ·ֿª£¬Ã¿¸öÔÂ31Ìì´æ³ÉÒ»ÌõÊý¾Ý£¬²¢°üº¬ÁËÃû³Æ£¬ÐǼ¶£¬¼Û¸ñ£¬Â·Ïß¡£
Èç¹û²»ÓÃÕâÖֽṹµÄ»°£¬¾ÍµÃ±ä³É365ÌõÊý¾Ý¡­¡­¶àÀË·Ñ¡£

´ó¼Ò¸ø³ö³öÖ÷Òå¡£


ËÑË÷¼Û¸ñµÄsqlÓÐʲô°ì·¨ÔÚÒ»ÌõÓï¾äÉ϶Լ۸ñ½øÐбȽϣ¿

ËÑË÷¿ò£º
ÓÊÂÖÃû£º ______

ÓÍÂÖ¼Û¸ñ$£º ÏÂÀ­¿ò: <300        300-400            400-500        >600

³öº½ÈÕÆÚ:yyyy/mm/dd        2009/11/25


¼ÙÉ裺
Ï£ÍûËÑË÷2009Äê11ÔÂ3ÈÕ¼Û¸ñµÍÓÚ300µÄÊý¾Ý¡£
ÒýÓÃÎÒÏë²»³öÆäËûµÄÊý¾Ý½á¹¹ÁË£¬ÒòΪÐèÒª½«ºǫ́ÊäÈëµÄÈÕÆÚÉú³É1Äê365Ì죬ÒÔÄêºÍÔ·ֿª£¬Ã¿¸öÔÂ31Ìì´æ³ÉÒ»ÌõÊý¾Ý£¬²¢°üº¬ÁËÃû³Æ£¬ÐǼ¶£¬¼Û¸ñ£¬Â·Ïß¡£
Èç¹û²»ÓÃÕâÖֽṹµÄ»°£¬¾ÍµÃ±ä³É365ÌõÊý¾Ý¡­¡­¶àÀË·Ñ¡£


Ê×ÏÈ£¬ÕâÖÖÉè¼ÆÊÇÎ¥·´Êý¾Ý¿âÉè¼Æ»ù±¾¹æÔòµÄ¡£Ó¦¸ÃÉè¼Æ³É  (ÈÕÆÚ£¬¼Û¸ñ)
Æä´Î£¬¡°¾ÍµÃ±ä³É365ÌõÊý¾Ý¡­¡­¶àÀË·Ñ¡± Õâ¸ö˵·¨µÄÒÀ¾ÝÊÇʲô£¿

ÄãÏÖÔڵĴ洢·½Ê½
year 2×Ö½Ú£« month 2×Ö½Ú + 30Ìì* (dd:nn|) 6×Ö½Ú = 184 ×Ö½Ú

¶ø&nb


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

sql º¯ÊýÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô

select parsen ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ