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

mysqlÊý¾Ý¿âÔõÑù²éѯÈÎÒâÒ»¸öÔµÄÊý¾Ý

¿ª·¢»·¾³£ºphp+mysql
table±íÖÐÓÐÒ»¸ö×Ö¶Îstarttime£¬Ê±¼ä¸ñʽÐÎÈ磺2009-09-18 10:15:16
ÏÖÔÚÏëͳ¼ÆÈÎÒâÒ»ÄêÖеÄÒ»¸öÔÂÊý¾Ý£¬²¢°´Ò»¸öÔÂÖеÄÌìÊýͳ¼Æ¼Ç¼Êý£¬$date ÊÇphpÖж¨ÒåµÄ±äÁ¿£¬¸ñʽÐÎÈ磺2009-09-18
ÎÒÏÖÔÚ°´ÕÕÒ»¸öÔµÄÌìÊý½øÐÐͳ¼Æ£¬¿ÉÊÇmysql²»Ö§³ÖYEARÖдø±äÁ¿µÄ²ÎÊý£¬Èç¹ûд³ÉYEAR('2009-09-18')¾ÍÄÜÕýÈ·Ö´ÐУ¬µ«ÊÇ$dateÊÇ´Ó±íµ¥ÖлñÈ¡µÄÊý¾Ý£¬ËüÊÇʵʱ¸üеģ¬ÇëÎÊÕâ¸öÎÊÌâ¸ÃÔõôʵÏÖ£¿
SELECT DATE_FORMAT( starttime, '%d' ) AS day , count(*) AS num
from table
where YEAR($date)=YEAR(starttime)
AND MONTH($date)=MONTH(starttime)
GROUP BY day
¼ì²éÒ»ÏÂÄãµÄ²ÎÊý¸ñʽ,mysqlÓ¦¸ÃÊÇÖ§³ÖYEAR()º¯ÊýÖÐÓñäÁ¿µÄ¡£

ÒýÓÃSELECT DATE_FORMAT( starttime, '%d' ) AS day , count(*) AS num
from table
where YEAR($date)=YEAR(starttime)
AND MONTH($date)=MONTH(starttime)
GROUP BY day


ÄãµÄÕâ¸öÓï¾äÓ¦¸Ã¾Í¿ÉÒÔ°¡£¿ ÕâÌõÓï¾äÓÐʲôÎÊÌâÂð£¿


YEAR($date)
==>>  YEAR(2009-09-18)
ÐèÒª¼ÓÉÏÒýºÅ Éú³É YEAR('2009-09-18')


SQL code:
mysql> set @a='2009/08/07';
Query OK, 0 rows affected (0.00 sec)

mysql> select year(@a);
+----------+
| year(@a) |
+----------+
| 2009 |
+----------+
1 row in set (0.00 sec)

¶¨Òå±äÁ¿ »òÕßÔÚmysqlÖÐд¸ö²ÎÊý


Ïà¹ØÎÊ´ð£º

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

MysqlÁ¬½Óoracle

ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ

oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó

ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬

ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ