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

MySQL¶àÏß³Ì

ÔÚ½øÐÐÊý¾Ý¿â¶ÁдµÄʱºò£¬Ò»°ãÇé¿ö϶¼Êǵ¥Ï̵߳ģ¬µ«ÊÇÈçºÎÔÚ²Ù×÷µÄʱºòҲʹÓöàÏß³ÌÄØ£¿Ê¹ÓöàḬ̈߳²È«Â𣿶àÏß³ÌÊÇÈçºÎ±£Ö¤°²È«µÄÄØ£¿Èç¹ûÓдúÂëµÄ»°£¬Ìù³öÀÛ»òÕß°Ñ´úÂë¹²Ïí¸øÎÒѧϰѧϰ¡£¡£¡£¶àл£¡
ÄãÊÇÖ¸ÍâÃæ³ÌÐòÓöàÏ߳̽øÐÐÊý¾Ý¿â¶Áд£¿
Èç¹ûÊÇÕâÑùµÄ»°£¬ÄãÖ»Òª±£Ö¤ÄãÍâÃæ³ÌÐò¶àÏ̵߳¥¶ÀÁ¬½ÓÊý¾Ý¿â¾ÍÐÐÁË£¬ÖÁÓÚºǫ́Êý¾Ý¿âµÄ¶à¸ö¶Áдͬʱ´¦ÀíµÄÎÊÌ⣬Êý¾Ý¿âÄÚ²¿ÓÐËø»úÖÆ×Ô¶¯¹ÜÀíµÄ¡£


Ò»¸öÁ¬½Ó£¬ÍâÃæ³ÌÐò¶àỊ̈߳¬ÎÒÏëÒªÊý¾Ý¿â·½ÃæÒ²ÊǶàÏ̡߳£

ÄÇÓ¦¸ÃÀàËÆmysql cluster
ºÍmaster and slave °É


ÒýÓÃ
Ò»¸öÁ¬½Ó£¬ÍâÃæ³ÌÐò¶àỊ̈߳¬ÎÒÏëÒªÊý¾Ý¿â·½ÃæÒ²ÊǶàÏ̡߳£


ÄÇÄãÿ¸öÏ̵߳¥¶ÀÁ¬Êý¾Ý¿â²ÅÐС£

ÄѵÀMySQLÔÚÖ´ÐÐsqlÓï¾äµÄʱºòÖ»ÄÜ¿ªÒ»¸öÏß³ÌÖ´ÐÐÖðÌõ¶à¸ösqlÓï¾äÂ𣿠²»¿ÉÒÔ¿ª¶à¸öÏß³ÌͬʱִÐÐsqlÓï¾äÂð£¿


Ïà¹ØÎÊ´ð£º

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysql µ¼ÖÂËÀ»ú

»·¾³£º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 ......

ÇóÖúMySQL²éѯ

select *from tabA limit (2*pagesize)
ÎÒÏëÔÚ´æ´¢¹ý³ÌÀïʵÏÖÒÔÉϹ¦ÄÜ£¬pagesizeÊÇint²ÎÊý£¬
ÔõôŪÄØ£¿
ÆäʵÊÇÏëŪ¸ö·ÖÒ²µÄ´æ´¢¹ý³Ì ²ÎÊýÊÇ µ±Ç°Ò³Êý¡¢Ò³ÃæÏÔʾÌõÊý

²»¶®£¬°ï¶¥

ûÓа취£¬Ö»ÄÜÓÃ
......

MySQL update ÑÏÖØÎÊÌâ


ÏÖÔÚÎÒÏëʵÏÖÒÔÏ·½·¨£º

»·¾³struts2+ibatis2.3+mysql5

    ´ÓjspµÃµ½Êý¾ÝºóÏÈupdate £¬Èç¹ûÊý¾Ý¿âÀïûÓиÃÐÅÏ¢ÔÙ insert £¬ÎÒÓÃÁËtry catch Òì³£²¶×½£¬±¾Ïëtry{ update}

catc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ