ÈçºÎ°ÑMySQLÖÃÓÚÖ»¶Á£¨²»Ê¹ÓÃread_only±äÁ¿£©£¿
ÈçºÎ°ÑMySQLÖÃÓÚÖ»¶Á£¨²»Ê¹ÓÃread_only±äÁ¿£ºhttp://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_read_only£©£¿
ÏÖÔÚÓÐÒ»¸öÇ¨ÒÆ³ÌÐò¡£ÎÒ´òËã¹ýÁËÇ¨ÒÆÈÕÖ®ºó£¬¾Í³ÌÐòÒÀÈ»¿ÉÓ㬵«ÊDZ£³ÖÖ»¶Á¡££¨²»±£´æÓû§Ð޸Ľá¹û¡££©
ÏÖÔÚÓÃread_onlyÖ®ºó£¬³ÌÐòÔËÐоͻá³ö´í¡£ÓÐûÓÐÓÐÒ»ÖÖ°ì·¨£¬¸ü°ì·¨ÊǵijÌÐò²»³ö´í¶ø±£³ÖÖ»¶Á£¿
ÎÒÓм¸¸ö˼·¡£
1.¾ÍÊÇʹÓÃread_only±äÁ¿£¬µ«ÊÇÄã²»Ó᣿϶¨ÓÐÄãµÄÓ¦Óð¡¡£
2.´ÓÓ¦ÓóÌÐò¶Ë¿ØÖÆÏ¡£ÊµÏÖÉÔ΢¸´Ôӵ㡣
3.ͨ¹ýȨÏÞ¿ØÖÆ£¬¹ýÁËÇ¨ÒÆÈպ󣬽«Óû§µÄȨÏÞÉèΪֻ¶Á¡£
¿´ÄãÔõôʹÓÃÀ²¡£
ÐÞ¸ÄÄǸöµÇ¼Óû§µÄȨÏÞÖ»¶Á
²»ÉèÖ÷¼üºÃÏñÓû§²Ù×÷Ò²²»Äܱ£´æ
Óù¤¾ßÊÇÕâÑùµÄÏÖÏó
½¨¸öÖ»¶ÁÕ˺Å
---------
¿¿£¬Ôõô¾Í¡°»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡¡± csdn±©Á¦µÄ²úÆ·²ßÂÔ¡£¡£¡£¡£
Â¥Ö÷µÄÒâ˼¹À¼ÆÊÇÔÚ³ÌÐòÖÐÓÐһЩ insert / update / delete Ö®ÀàµÄÓï¾ä¡£ÏëÔÚ²»¸Ä³ÌÐòµÄÇé¿öÏ£¬¼´ÔÊÐí³ÌÐòÖ´ÐÐÕâЩupdate Óï¾ä£¬ÓÖ²»»áʵ¼ÊÐÞ¸ÄÊý¾Ý¡£
Õâ¸ö±È½Ï¸´ÔÓ¡£±È½ÏÈÝÒ׵ķ½·¨¾ÍÊÇÐÞ¸ÄMYSQLµÄÔ´´úÂ룬ȻºóÖØÐ±àÒë¡£
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
iocpͬmysql´¦ÀíÊý¾Ý ¾ä±úÒ»Ö±Ôö¼Ó
·ÖÏí ³ÌÐòÔ±Ö®¼Ò£¨www.phome.asia£©¼¼Êõ¹Ù·½Èº£¬Ï£ÍûÓÐ־֮ʿµÄ¼ÓÈëŶ~~ºÙºÙ£¡
javaȺ£º
javaÐÂÊÖȺ£º 19976477
javaÐÂÊÖȺ2£º61983722
......