°æ±¾Ò»¶¨Òª³¬¹ý5.1µÄÂ𣿠mysql Ver 14.12 Distrib 5.0.83, for unknown-openbsd4.6 (i386) using readline 4.3 ÎÒÏÖÔÚ°æ±¾²Å5.0.83 ¿´À´»¹ÒªÉý¼¶Ï Êǵģ¬Õâ¸ö¹¦ÄÜ´Ó 5.1ºó¿ªÊ¼¡£ º¹¡£¡£¡£ÎÒobϵͳ Éý¼¶´íÎóunvis.c:76: error: syntax error before "int"Õâ¸öÄܽâ¾öÂ𣿠ʹÓÃmysql 5.1×îÐÂrelease°æ£¬ÀûÓÃrange·ÖÇø¿ÉÒÔ½â¾öÄãµÄÎÊÌâ¡£
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í: You can't specify target table 'a_table' for update in from clause ÍêÕûSQLÓï¾äÊÇ UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â 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: ......