Á½Ì¨Mysql·þÎñÆ÷£¬Êý¾Ýͬ²½
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ
ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµÄ¸üРºÍ Óû§ÉÏ´«µÄÎļþ¸üÐÂ
ÎÒÏÖÔÚÔÚ¿´mysqlÊý¾Ý¿âµÄͬ²½¡£ ÔÚÁ½Ì¨·þÎñÆ÷ÉϵÄmysqlÊý¾Ý¿âÖ®¼äµÄͬ²½
ÍøÉϲéÁËÏÂmysqlÈȱ¸·Ý£¬´ó¶à½²µÄÊÇÊý¾Ý´Ó Ö÷·þÎñÆ÷ µ½ ´Ó·þÎñÆ÷ÉÏ¡£½²Ë«ÏòÈȱ¸µÄ±È½ÏÉÙ¡£ÓÉÓÚmysqlÈȱ¸·ÝÊÇÒì²½´¦ÀíµÄ£¬¶ÔÓÚauto_increment×ֶεÄÖµ£¬Ë«ÏòÈȱ¸µÄʱºò²»ÖªµÀ»á²»»á³öÎÊÌ⣿
»¹ÓÐMysql´Ø£¬ÎÒ»¹Ã»ÓÐ×Ðϸ¿´¡£
Ï£Íû´ó¼Ò¿ÉÒÔ¸øСµÜÌṩһЩ½¨ÒéºÍ·½°¸£¬Ð»Ð»¡£
û×ö¹ý£¬°ï¶¥¡£
°ï¶¥°É
û×ö¹ý µÈ´ý´óÅ£ÃÇÀ´¸øÄã½â´ð
ÎÒ¿´ÁËÏÂMysql´Ø£¬×÷ΪӲ¼þµÄ¼¸Ì¨·þÎñÆ÷Ö®¼ä´ø¿íÒª´ïµ½100Mbps£¬Ö»ÄÜÊÇÒ»¸ö¾ÖÓòÍøÖ®ÄÚ²ÅÐУ¬ÔÚ¹ãÓòÍøºÜÄÑʵÏֳɹ¦£¬Ò²²»ÍƼöÔÚ¹ãÓòÍø¼ÜÉè¡£
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
select time from table
time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15
Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
......
Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ
ÃÜÂë´íÁË°É¡£
¸Õѧmysql,ÕÕ×ÅÊ ......
ÎÒ½¨ÁËÁ½¸ö±í£¬Ò»¸ö±íÃ÷user£¬Ò»¸ö±íanswer
±íuserµÄ½á¹¹{id,username,password}
±íanswerµÄ½á¹¹{A_id,question,answer,U_id}
Çë½Ì´ó¼ÒÎÒÔõôÉèÖòÅÄÜÔÚ±íuser²åÈëÊý¾Ýʱ£¬±íanswer¶ÔÓ¦µÄU_id×Ô¶¯¸üжÔÓ¦± ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......