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
Ïà¹ØÎÊ´ð£º
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡ Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7 µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡ ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£ ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
echo %~dp0 CD %~dp0 mysqld.exe --defaults-file=..\my.ini --console pause ´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£ ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£ echo %~dp0 ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû CD %~dp0 ......