mysqlÖÐÀàÐÍΪintµÄÊý¾ÝÔõÑù×Ô¼Ó1£¿
±ÈÈ磺ÔÚͳ¼ÆÍøÕ¾µÄ·ÃÎÊÈËÊýʱ£¬Ã¿µ±ÓÐÒ»¸öÓû§·ÃÎÊʱ£¬¾ÍÐèÒª½«Êý¾ÝÖд洢·ÃÎÊÈËÊýµÄÊý¾Ý¼Ó1.Õâ¸öÔõôʵÏÖ£¿ µ±È»¿ÉÒÔÕâÑù×ö£º1.ÏȶÁÈ¡±íÖзÃÎÊÈËÊýµÄÊý¾Ý£¬È»ºó¼Ó1. 2.È»ºóÔÚÓÃupdateÓï¾ä¶ÔÊý¾Ý½øÐиüС£ µ«Ó¦¸Ã²»ÓÃÕâôÂé·³°É£¿ ²»ÖªµÀÓÐûÓкõķ½·¨£¿Ð»Ð»£¡
ûÓÐÌõ¼þ£¬ÓÃÕâÕУ¬Õâ¸ö±íÀïÖ»ÄÜÓÐÒ»Ìõ¼Ç¼£¬¶àÁ˿ɾÍÂé·³ÁË£¬Êǰѣ¿ Ö±½ÓÌæ»»²»ÐУ¿ÒýÓà update tabe1 set cnt=cnt+1; ¼ÆËã×ÜÈËÊý£¬Ò»°ã¶¼ÊÇÕâÑù۵ġ£ ºÇºÇ лл£¡°´ÕÕÄãµÄ·½·¨ÒѾ½â¾ö£¡ ÒýÓà ±ÈÈ磺ÔÚͳ¼ÆÍøÕ¾µÄ·ÃÎÊÈËÊýʱ£¬Ã¿µ±ÓÐÒ»¸öÓû§·ÃÎÊʱ£¬¾ÍÐèÒª½«Êý¾ÝÖд洢·ÃÎÊÈËÊýµÄÊý¾Ý¼Ó1.Õâ¸öÔõôʵÏÖ£¿ µ±È»¿ÉÒÔÕâÑù×ö£º1.ÏȶÁÈ¡±íÖзÃÎÊÈËÊýµÄÊý¾Ý£¬È»ºó¼Ó1. 2.È»ºóÔÚÓÃupdateÓï¾ä¶ÔÊý¾Ý½øÐиüС£ µ«Ó¦¸Ã²»ÓÃÕâôÂé·³°É£¿ ²»ÖªµÀÓÐûÓкõķ½·¨£¿Ð»Ð»£¡
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â 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: ......
±í CREATE TABLE `ch1` ( `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `no` int(10) unsigned DEFAULT NULL, `dtime` datetime DEFAULT NULL, PRIMARY KEY (`id ......