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()
???
Ï£Íû´ó¼ÒÓ»Ô¾·¢ÑÔ£¬ÎÒ¶¥ÏÈ
Ïà¹ØÎÊ´ð£º
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒµÄϵͳÊÇwindows XPµÄ,ÉÏ´ÎÓõçÄÔʱ¿ÉÒÔÔËÐÐmysql,µ«¹Ø»úºó,¸ô¶Ïʱ¼äÔÙ¿ª»ú,mysql¾Í²»ÄÜÕý³£ÔËÐÐÁË......¿ª»úºó,Mysql·þÎñÊÇ¿ªÆôµÄ,½ø³ÌÀïÃæµÄmysqld.exeµÄCPUÕ¼ÓÃÂÊΪ00,ÄÚ´æÊ¹ÓÃΪ72k(ºÍÎÒÉÏ´ÎÕý³£Ê¹ÓÃmysqlʱµÄ ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º
create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;
±£´æÎªindex.s ......
ÏÖÓÐÒ»¸ö±íÓÐ185ÍòÌõ¼Ç¼
ËÑË÷ʱ£¬×î¸ß·åÖµ¿É´ï1.2G×óÓÒ
ʹÓÃmy-xxx.ini±È½ÏºÃ£¿£¡
ÈçºÎ½«ÕâЩÅäÖñä³ÉĬÈÏÅäÖã¿£¡
°ÑÔÀ´µÄ my.ini ¸ÄÃû±¸·Ý£¬È»ºóÔÙ°ÑÕâ¸ö my-huge.ini ¸Ä³É my.ini
» ......