ÎÒÏë×ö¸öÍøÒ³,ÍøÒ³ÖÐÓÐÒ»¸ö±í¸ñ,ÐÐÊýÏÞÖÆ30ÐÐ,ÓÉÓû§À´¾ö¶¨ÊäÈë¶àÉÙÐÐ,È»ºó°ÑÕâЩÊý¾ÝдÈëÊý¾Ý¿âÖÐ,
ÎÒÏëÎÊһ϶ÔÓÚÕâÑùµÄÇé¿ö,ÊÇÓõ¥¶ÀµÄ±íÀ´±£´æÃ¿ÕűíµÄÊý¾Ý,»¹ÊÇÔõÑù´¦Àí?ÁíÍ⻹ÓжÔÿÁеÄÇóºÍ
³õѧ²ËÄñ,Çë¶à¶àÖ¸½Ì,лл{{ ......
mysql ´¥·¢Æ÷²Ù×÷дÈë¶þ½øÖÆÈÕÖ¾£¬¾¹ýÎÒµÄʵÑéÊÒ²»¿ÉÐеġ£
ÄÇôÎÒÊÇ·ñ¿ÉÒÔͨ¹ýijЩ·½Ê½Èô¥·¢Æ÷µÄ²Ù×÷¿ÉÒÔдÈëÈÕ־Ĩ£¿£¿
ûÓа취¡£BINLOGÖ»¼Ç¼µÄÖ»ÊÇ INSERT / UPDATE / DELTE .... µÈÓï¾ä£¬²¢²»¼Ç¼ ÄãµÄ´æ´¢¹ý³ÌÖеÄÖ´Ðв½ÖèºÍÓï¾ä¡£
ËÀ´¶¥¸ö£¬ÎÒ°ÑÌù½áÁË¡£
Row-based binary logging logs
¶¥¸ö£¡¹þ¹ ......
±ÈÈçÒ»ÕÅbug¼Ç¼µÄ±í£¬ÆäÖÐÓÐ×Ö¶Îfinddate,ÐèÇóÊÇͳ¼Æ³öÓмǼµÄÌì·¢ÉúÁ˶àÉÙ¸öbug.
field£ºfinddate
2009-1-2
2009-1-4
2009-1-6
2009-1-6
2009-1-6
2009-1-10
2009-1-10
ÆÚ´ý½á¹û£º
2009-1-2£¬1
2009-1-4£¬1
2009-1-6£¬3
2009-1-10£¬2
{{-- ......
ÔÚlinuxÀï°²×°ÁË oracle mysql ¶¼³É¹¦¡£
ÔÚ/homeÏ ȥ·¢ÏÖÖ»ÓÐoracleµÄÎļþ ûÓÐmysqlµÄÎļþ
ÁíÍâÎÒadduser li£¬ ÄÜÔÚ/homeÏ ·¢ÏÖÓÐliÎļþ¡£
ʲôÔÒòµ¼ÖÂÎÒÖ»ÄÜ¿´¼ûoracle ²»¼ûmysqlÎļþ£¿£¿
mysqlÓû§Ö÷Ŀ¼ where??
ind / -name "mysql" -print
Ö´ÐÐÍêµÃµ½ÏÂÁнá¹û ......
select a.*,b.ÃèÊö from ( select a.ÐòÁкÅ1,b.ÃèÊö,a.ÐòÁкÅ2 from tb2 a, tb1 b where a.ÐòÁкÅ1=b.ÐòÁкÅ) a,tb1 b where a.ÐòÁкÅ2=b.ÐòÁкÅ;
²éѯ½á¹ûÈçÏ£º
---------------------------
+------+--------+------+--------+
| ÐòÁкÅ1 | ÃèÊö | ÐòÁкÅ2 | ÃèÊö|
+------+--------+------+-- ......
linux ÏÂÓм¯³ÉÁËphp mysql Apache µÄÈí¼þ£¿Ð»Ð»£¡£¡
ÕâÊÇʲô¶«Î÷£¿
Ò»¸öÒ»¸ö°²×°²»¾Í¿ÉÒÔÁË
°²×°linux Èç¹ûÄãûȥµôµÄ»° phpºÍApache¶¼ÊÇĬÈϰ²×°µÄ mysqlºÃÏñÒ²¿ÉÒÔÑ¡Ôñ°²×°£¨ÎÒûÊÔ¹ý£©
ÎÒÃǿͻ§ÒªµÄ£¬ËûÏë°²×°µÄ¼òµ¥Ò»µã£¬ÀàËÆappservÔÚwindow ϵݲװÈí¼þ¡£
Èç¹ûÄã»álinux   ......