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

mysql ÈçºÎºÏ²¢·ÖÇø£¿

SQL code:

ALTER TABLE tbl REORGANIZE PARTITION p_50000000 INTO
(
PARTITION p_50000000 VALUES LESS THAN (50000000),
PARTITION p_2008_12 VALUES LESS THAN (2307392000),
PARTITION p_2009_01 VALUES LESS THAN (2334176000),
PARTITION p_2009_02 VALUES LESS THAN (2358368000),
PARTITION p_2009_03 VALUES LESS THAN (2385152000),
PARTITION p_2009_04 VALUES LESS THAN (2411072000),
PARTITION p_2009_05 VALUES LESS THAN (2437856000)
);



ÎÒ´Ó·ÖÇøp_50000000Öл®·Ö³öÕâô¶à·ÖÇø£¬ÏÖÔÚºó»ÚÁË£¬Ï뽫ÕâЩ·ÖÇøºÏ²¢»Øp_50000000£¡

ÈçºÎ×öµ½£¿
ʾÀý£º
SQL code:
alter table tb_key_part11 reorganize partition p2,p3 into
(partition p3 values less than (30)
)


·Ö¼¸²½´¦Àí£º
SQL code:
ALTER TABLE tbl REORGANIZE PARTITION p_50000000,p_2008_12,p_2009_01,p_2009_02,p_2009_03,p_2009_04,p_2009_05 INTO
(
PARTITION p_2009_05 VALUES LESS THAN (2437856000)
);


ALTER TABLE tbl REORGANIZE PARTITION p_2009_05 into
(
PARTITION p_2009_05 VALUES LESS THAN (2437855000),
PARTITION p_50000000 VALUES LESS THAN (2437856000)
);

ALTER TABLE tbl REORGANIZE PARTITION


Ïà¹ØÎÊ´ð£º

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

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

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


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

......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ