MySqlÎÊÌâ
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/**
now()
-------------------
2009-09-29 14:16:39
**/
select current_date();
/**
current_date()
--------------
2009-09-29
**/
jintian()
???
Ï£Íû´ó¼ÒÓ»Ô¾·¢ÑÔ£¬ÎÒ¶¥ÏÈ
Ïà¹ØÎÊ´ð£º
ÔÚmysqlÖÐrepair table xxxxx;Ìáʾ
mysql> repair table recordTbl;
+-----------------+--------+----------+----------------------------------------------+
| Table   ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇΪʲôÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
ÏÖÓÐÒ»¸ö±íÓÐ185ÍòÌõ¼Ç¼
ËÑË÷ʱ£¬×î¸ß·åÖµ¿É´ï1.2G×óÓÒ
ʹÓÃmy-xxx.ini±È½ÏºÃ£¿£¡
ÈçºÎ½«ÕâЩÅäÖñä³ÉĬÈÏÅäÖã¿£¡
°ÑÔÀ´µÄ my.ini ¸ÄÃû±¸·Ý£¬È»ºóÔÙ°ÑÕâ¸ö my-huge.ini ¸Ä³É my.ini
» ......