MySQL¶àÏß³Ì
ÔÚ½øÐÐÊý¾Ý¿â¶ÁдµÄʱºò£¬Ò»°ãÇé¿ö϶¼Êǵ¥Ï̵߳ģ¬µ«ÊÇÈçºÎÔÚ²Ù×÷µÄʱºòҲʹÓöàÏß³ÌÄØ£¿Ê¹ÓöàḬ̈߳²È«Â𣿶àÏß³ÌÊÇÈçºÎ±£Ö¤°²È«µÄÄØ£¿Èç¹ûÓдúÂëµÄ»°£¬Ìù³öÀÛ»òÕß°Ñ´úÂë¹²Ïí¸øÎÒѧϰѧϰ¡£¡£¡£¶àл£¡
ÄãÊÇÖ¸ÍâÃæ³ÌÐòÓöàÏ߳̽øÐÐÊý¾Ý¿â¶Áд£¿ Èç¹ûÊÇÕâÑùµÄ»°£¬ÄãÖ»Òª±£Ö¤ÄãÍâÃæ³ÌÐò¶àÏ̵߳¥¶ÀÁ¬½ÓÊý¾Ý¿â¾ÍÐÐÁË£¬ÖÁÓÚºǫ́Êý¾Ý¿âµÄ¶à¸ö¶Áдͬʱ´¦ÀíµÄÎÊÌ⣬Êý¾Ý¿âÄÚ²¿ÓÐËø»úÖÆ×Ô¶¯¹ÜÀíµÄ¡£ Ò»¸öÁ¬½Ó£¬ÍâÃæ³ÌÐò¶àỊ̈߳¬ÎÒÏëÒªÊý¾Ý¿â·½ÃæÒ²ÊǶàÏ̡߳£ ÄÇÓ¦¸ÃÀàËÆmysql cluster ºÍmaster and slave °É ÒýÓà һ¸öÁ¬½Ó£¬ÍâÃæ³ÌÐò¶àỊ̈߳¬ÎÒÏëÒªÊý¾Ý¿â·½ÃæÒ²ÊǶàÏ̡߳£ ÄÇÄãÿ¸öÏ̵߳¥¶ÀÁ¬Êý¾Ý¿â²ÅÐС£ ÄѵÀMySQLÔÚÖ´ÐÐsqlÓï¾äµÄʱºòÖ»ÄÜ¿ªÒ»¸öÏß³ÌÖ´ÐÐÖðÌõ¶à¸ösqlÓï¾äÂ𣿠²»¿ÉÒÔ¿ª¶à¸öÏß³ÌͬʱִÐÐsqlÓï¾äÂð£¿
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺 <?php $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error()); & ......
MySQLÈëÃÅ ¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿ ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£ È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html ¾ÍÕÒÒ»±¾ºÜ»ù´ ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5 mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£ InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_log ......
select *from tabA limit (2*pagesize) ÎÒÏëÔÚ´æ´¢¹ý³ÌÀïʵÏÖÒÔÉϹ¦ÄÜ£¬pagesizeÊÇint²ÎÊý£¬ ÔõôŪÄØ£¿ ÆäʵÊÇÏëŪ¸ö·ÖÒ²µÄ´æ´¢¹ý³Ì ²ÎÊýÊÇ µ±Ç°Ò³Êý¡¢Ò³ÃæÏÔʾÌõÊý ²»¶®£¬°ï¶¥ ûÓа취£¬Ö»ÄÜÓà ......
ÏÖÔÚÎÒÏëʵÏÖÒÔÏ·½·¨£º »·¾³struts2+ibatis2.3+mysql5 ´ÓjspµÃµ½Êý¾ÝºóÏÈupdate £¬Èç¹ûÊý¾Ý¿âÀïûÓиÃÐÅÏ¢ÔÙ insert £¬ÎÒÓÃÁËtry catch Òì³£²¶×½£¬±¾Ïëtry{ update} catc ......