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

MySQL£ºÈÕÆÚº¯Êý¡¢Ê±¼äº¯Êý×ܽᣨMySQL 5.X£©

MySQL£ºÈÕÆÚº¯Êý¡¢Ê±¼äº¯Êý×ܽᣨMySQL 5.X£©
²Î¿¼³¤ÎÄ£º
Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQL Öл¹ÓÐÏÂÃæµÄº¯Êý£º
current_timestamp()
,current_timestamp
,localtime()
,localtime
,localtimestamp -- (v4.0.6)
,localtimestamp() -- (v4.0.6)
ÕâЩÈÕÆÚʱ¼äº¯Êý£¬¶¼µÈͬÓÚ now()¡£¼øÓÚ now() º¯Êý¼ò¶ÌÒ׼ǣ¬½¨Òé×ÜÊÇʹÓà now() À´Ìæ´úÉÏÃæÁгöµÄº¯Êý¡£
1.2 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºsysdate()
sysdate() ÈÕÆÚʱ¼äº¯Êý¸ú now() ÀàËÆ£¬²»Í¬Ö®´¦ÔÚÓÚ£ºnow() ÔÚÖ´ÐпªÊ¼Ê±Öµ¾ÍµÃµ½ÁË£¬ sysdate() ÔÚº¯ÊýÖ´ÐÐʱ¶¯Ì¬µÃµ½Öµ¡£¿´ÏÂÃæµÄÀý×Ó¾ÍÃ÷°×ÁË£º
mysql> select now(), sleep(3), now();
+---------------------+----------+---------------------+
| now() | sleep(3) | now() |
+---------------------+----------+---------------------+
| 2008-08-08 22:28:21 | 0 | 2008-08-08 22:28:21 |
+---------------------+----------+---------------------+
mysql> select sysdate(), sleep(3), sysdate();
+---------------------+----------+---------------------+
| sysdate() | sleep(3) | sysdate() |
+---------------------+----------+---------------------+
| 2008-08-08 22:28:41 | 0 | 2008-08-08 22:28:44 |
+---------------------+----------+---------------------+
¿ÉÒÔ¿´µ½£¬ËäÈ»ÖÐ; sleep 3 Ã룬µ« now() º¯ÊýÁ½´ÎµÄʱ¼äÖµÊÇÏàͬµÄ£» sysdate() º¯ÊýÁ½´ÎµÃµ½µÄʱ¼äÖµÏà²î 3 Ãë¡£MySQL Manual ÖÐÊÇÕâÑùÃèÊö sysdate() µÄ£ºReturn the time at which the function executes¡£
sysdate() ÈÕÆÚʱ¼äº¯Êý£¬Ò»°ãÇé¿öϺÜÉÙÓõ½¡£
2. »ñµÃµ±Ç°ÈÕÆÚ£¨date£©º¯Êý£ºcurdate()
mysql> select curdate();
+------------+
| curdate() |
+------------+
| 2008-08-08 |
+------------+
ÆäÖУ¬ÏÂÃæµÄÁ½¸öÈÕÆÚº¯ÊýµÈͬÓÚ curdate()£º
current_date()
,current_date
3. »ñµÃµ±Ç°Ê±¼ä£¨time£©º¯Êý£ºcurtime()
mysql> select curtime();
+-----------+
| curtime() |
+-----------+
| 22:41:30 |
+-----------+
ÆäÖУ¬ÏÂÃæµÄÁ½¸öʱ¼


Ïà¹ØÎĵµ£º

mysqlÔÚÔÙ´ÎÐ¶ÔØºó֨װ³öÏÖStart services²»ÄÜÆô¶¯

    ×î½ü×öÒ»¸öСÏîÄ¿£¬¸ÕºÃÓöµ½Õâ¸öÎÊÌ⣬ûʲôʱ¼äÈ¥½â¾öÕâ¸öÎÊÌ⣬´ó¸ÅÔÚÍøÉÏÕÒÁËһϣ¬Ëµ¸ÄʵÀýÃû£¬¸Ä×¢²á±í£¬ÏȲ»ÊǺܸҸģ¬±Ï¾¹¶Ô×¢²á±íÒ»Ö±¾õµÃÊǸö´óÉñ£¬²»¸ÒËæ±ã¶¯£¬½ñ¶ùÊÇ»í³öÈ¥ÁË£¬¾ÍÔÚ×¢²á±íÖвéÕÒËùÓдúmysql×ÖÑùµÄÐÅϢȫ²¿É¾³ý£¬×îºó¾¹È»³ÉÁË£¬µ±È»Ð¶Ôغóɾ³ý֮ǰËùÓеÄÏà¹ØÐÅÏ¢£¬°²×°ÎļþÄ¿ ......

MySQL 5.5 °æ±¾·¢²¼

½üÈÕ£¬MySQL 5.5 µÚÒ»¸ö°æ±¾·¢²¼ÁË£¬»ùÓÚMySQl 5.4£¬µ«ÊÇÔÚÐÔÄÜÉÏÏà¶ÔÓÚµ±Ç°µÄ5.0/5.1ÓÐÁ˺ܴóµÄÌáÉý¡£
 ÐÂÌØÐÔ£º
Ö§³Ösemisynchronous £¨°ëͬ²½£©¸´Öƽӿڣ¬¿É´î½¨³öÒ»¸öÏà¶ÔÍêÃÀµÄMySQL¸ß¿ÉÓÃÐÔ·½°¸
¼¯³ÉInnodb plugin 1.0.6
Ö§³Ö SQL ±ê×¼ SIGNAL ºÍ RESIGNAL Óï¾ä
ÔöÇ¿XML¹¦ÄÜ£¬Ö§³Ö LOAD XML Óï¾ä
¿Éͨ¹ý A ......

MySQL 5.0´æ´¢¹ý³Ì±à³ÌÈëÃÅ

Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
CREATE
    [DEFINER = { user | CURRENT_USER }]
    PROCEDURE sp_name ([proc_parameter[,...]])
    [characteristic ...] routine_body
   
proc_parameter:
    [ IN | ......

Mysql ´¥·¢Æ÷ʵÀý

MySQL ´¥·¢Æ÷¼òµ¥ÊµÀý
1¡¢Óï·¨£º
CREATE TRIGGER <´¥·¢Æ÷Ãû³Æ>  --´¥·¢Æ÷±ØÐëÓÐÃû×Ö£¬×î¶à64¸ö×Ö·û£¬¿ÉÄܺóÃæ»á¸½Óзָô·û.ËüºÍMySQLÖÐÆäËû¶ÔÏóµÄÃüÃû·½Ê½»ù±¾ÏàÏó.
{ BEFORE | AFTER }  --´¥·¢Æ÷ÓÐÖ´ÐеÄʱ¼äÉèÖ㺿ÉÒÔÉèÖÃΪʼþ·¢Éúǰ»òºó¡£
{ INSERT | UPDATE | DELETE }  --ͬÑùÒ²ÄÜÉ趨´¥· ......

mysql cache¹¦ÄÜС¼Ç

http://www.cnblogs.com/rethink/archive/2009/10/09/1579634.html
mysql cache¹¦ÄÜ·ÖÎö£º
1
mysqlµÄcache¹¦ÄܵÄkeyµÄÉú³ÉÔ­ÀíÊÇ£º°ÑselectÓï¾ä°´ÕÕÒ»¶¨µÄhash¹æÔòÉú³ÉΨһµÄkey£¬selectµÄ½á¹ûÉú³Évalue£¬¼´key=>value¡£ËùÒÔ¶ÔÓÚcache¶øÑÔ£¬selectÓï¾äÊÇÇø·Ö´óСдµÄ£¬Ò²Çø·Ö¿Õ¸ñµÄ¡£Á½¸öselectÓï¾ä±ØÐëÍêÍêȫȫһÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ