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

mysql ÈçºÎ°´ÖܽøÐзÖÇø£¿

±íÖÐÓÐDATE»òTIMESTAMP×Ö¶Î,ÎÒÏë°´ÕÕ¸Ã×Ö¶ÎÿÖÜÒ»¸ö·ÖÇø¡£ÈçºÎ×öµ½£¿

SQL code:
mysql> CREATE TABLE netxuning (
-> id INT NOT NULL,
-> mydate DATE
-> )
-> PARTITION BY RANGE (YEARWEEK(mydate)) (
-> PARTITION p0 VALUES LESS THAN (200901),
-> PARTITION p1 VALUES LESS THAN (200902),
-> PARTITION p2 VALUES LESS THAN (200906),
-> PARTITION p3 VALUES LESS THAN (200953)
-> );
Query OK, 0 rows affected (0.16 sec)

mysql>



ÒýÓÃ
Äã¿ÉÒÔÓà YEARWEEK()  À´·ÖÇø


Èç¹û×Ö¶ÎÊÇʱ¼ä´ÁÄØ£¿

YEARWEEK(from_UNIXTIME(1261555175, '%Y-%m-%d')); //ÕâÑù´îÅäÄܲ»ÄÜÓÃÀ´·ÖÇø£¿

ÒýÓÃ
ÒýÓà 1 Â¥ acmain_chm µÄ»Ø¸´:
Äã¿ÉÒÔÓà YEARWEEK()  À´·ÖÇø


Èç¹û×Ö¶ÎÊÇʱ¼ä´ÁÄØ£¿

YEARWEEK(from_UNIXTIME(1261555175, '%Y-%m-%d')); //ÕâÑù´îÅäÄܲ»ÄÜÓÃÀ´·ÖÇø£¿


ÊÔÁËһϣ¬²»ÐУº
SQL code:

mysql> CREATE TABLE netxuning (
-> id INT NOT NULL,
-> mydate TIMESTAMP
-> )
-> PARTITION BY RANGE (YEARWEEK(from_UNIXTIME(mydat


Ïà¹ØÎÊ´ð£º

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

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

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......

ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ