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µÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......