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

Á½Ì¨Mysql·þÎñÆ÷£¬Êý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµÄ¸üР ºÍ Óû§ÉÏ´«µÄÎļþ¸üÐÂ

ÎÒÏÖÔÚÔÚ¿´mysqlÊý¾Ý¿âµÄͬ²½¡£ ÔÚÁ½Ì¨·þÎñÆ÷ÉϵÄmysqlÊý¾Ý¿âÖ®¼äµÄͬ²½
ÍøÉϲéÁËÏÂmysqlÈȱ¸·Ý£¬´ó¶à½²µÄÊÇÊý¾Ý´Ó Ö÷·þÎñÆ÷ µ½ ´Ó·þÎñÆ÷ÉÏ¡£½²Ë«ÏòÈȱ¸µÄ±È½ÏÉÙ¡£ÓÉÓÚmysqlÈȱ¸·ÝÊÇÒì²½´¦ÀíµÄ£¬¶ÔÓÚauto_increment×ֶεÄÖµ£¬Ë«ÏòÈȱ¸µÄʱºò²»ÖªµÀ»á²»»á³öÎÊÌ⣿

»¹ÓÐMysql´Ø£¬ÎÒ»¹Ã»ÓÐ×Ðϸ¿´¡£

Ï£Íû´ó¼Ò¿ÉÒÔ¸øСµÜÌṩһЩ½¨ÒéºÍ·½°¸£¬Ð»Ð»¡£

û×ö¹ý£¬°ï¶¥¡£

°ï¶¥°É

û×ö¹ý µÈ´ý´óÅ£ÃÇÀ´¸øÄã½â´ð

ÎÒ¿´ÁËÏÂMysql´Ø£¬×÷ΪӲ¼þµÄ¼¸Ì¨·þÎñÆ÷Ö®¼ä´ø¿íÒª´ïµ½100Mbps£¬Ö»ÄÜÊÇÒ»¸ö¾ÖÓòÍøÖ®ÄÚ²ÅÐУ¬ÔÚ¹ãÓòÍøºÜÄÑʵÏֳɹ¦£¬Ò²²»ÍƼöÔÚ¹ãÓòÍø¼ÜÉè¡£


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

mysql Ð޸IJéѯÊý¾ÝµÄÎÊÌâ

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ʱ
......

mysqlÁ¬½ÓÎÊÌâ

Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ

ÃÜÂë´íÁË°É¡£

¸Õѧmysql,ÕÕ×ÅÊ ......

MySQLÊý¾Ý¿â¹ØÁªµÄÎÊÌâ

ÎÒ½¨ÁËÁ½¸ö±í£¬Ò»¸ö±íÃ÷user£¬Ò»¸ö±íanswer
±íuserµÄ½á¹¹{id,username,password}
±íanswerµÄ½á¹¹{A_id,question,answer,U_id}
Çë½Ì´ó¼ÒÎÒÔõôÉèÖòÅÄÜÔÚ±íuser²åÈëÊý¾Ýʱ£¬±íanswer¶ÔÓ¦µÄU_id×Ô¶¯¸üжÔÓ¦± ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ