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

¹ØÓÚmysqlµÄTIMESTAMPÁÐÒ»¸öÎÊÌ⣬лл

ΪʲôTIMESTAMPÁУ¬ÔÚÎÒ¸üÐÂÊý¾ÝµÄʱºòÒ²»á¸üÐÂÄØ£¿ÎÒÔõô¶¼Ïë²»Ã÷°×£¬ÎÒÖ»ÏëÔÚÔö¼Ó¼Ç¼ʱͬʱ¼Ç¼һ¸öʱ¼ä£¬µ«¸üмǼµÄʱºòʱ¼äÁÐÒ²»á¸üУ¬ÇëÎÊÈçºÎ×èÖ¹ÕâÑù×ö£¬Ð»Ð»

time2 TIMESTAMP  CURRENT_TIMESTAMP
MySQL»á°Ñ±íÖеÚÒ»¸ötimestamp ×Ö¶Î×Ô¶¯µÄ¼ÓÉÏĬÈϺÍon update
Èç¹ûÒª½ûÖ¹£¬ÔòÖ»ÄÜ×Ô¼ºÊÖ¹¤µÄ¼Ó¸ödefault

create table x (id int primary key, t1 timestamp default 0,col int);

´ÓÀ´Ã»Óöµ½¹ýÕâÖÖÎÊÌ⣬ѧϰÁË

timestampÀàÐÍ×Ö¶ÎÔÚ½¨±íʱûÓÐÉèÖÃÖÃĬÈÏÖµ¾Í»á·¢ÉúÕâÖÖÇé¿ö


Ïà¹ØÎÊ´ð£º

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

mysqlÊý¾ÝÕÒ»ØÄÑÌ⣬¸ß·Ö£¬¼±£¡£¡£¡

ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......

Çë½Ì£ºÇ¶Èëʽϵͳ°²×°MySQLÊý¾Ý¿âµÄÎÊÌâ

½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......

mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ ¼±

mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é

mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error

²»ÖªµÀÓÐûÓÐÀàË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ