Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

°ïæ¿´¿´MySQLÓйصÄÅú´¦ÀíÎļþµÄÓï·¨

echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£

echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ