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
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
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.
¿ ......