mysqlÓï¾äÖ´ÐÐʱ¼äµÄ»ñÈ¡
ÎÒÓõÄNavicat´øµÄcosoleÖ´ÐÐsqlÓï¾ä£¬Ã»ÓÐÓï¾äÖ´ÐÐʱ¼ä£¬µ«ÎÒ¿´µ½ACMAIN_CHMµÄ»ØÌû¶¼´øÓÐÖ´ÐÐʱ¼ä£¬ÈçϵÄ0.00 sec.
ÇëÎÊÊÇʹÓõŤ¾ß²»Ò»Ñù£¬»¹ÊÇÓиöÅäÖÃû¿ª£¬»òÕßÊǰ汾µÄÎÊÌ⣿
mysql> select * from t_advancejar;
+------+------+----------+
| name | num | order_id |
+------+------+----------+
| ÕÅÈý | 10 | 0 |
| ÕÅÈý | 10 | 1 |
| ÕÅÈý | 11 | 0 |
| ÕÅÈý | 11 | 1 |
| ÕÅÈý | 12 | 0 |
| ÕÅÈý | 13 | 1 |
| ÀîËÄ | 12 | 1 |
+------+------+----------+
7 rows in set (0.00 sec)
ÊÇÔÚMYSQLÃüÁîÐÐÏÂÏÔʾ³öÀ´µÄʱ¼ä
Ïà¹ØÎÊ´ð£º
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
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 ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......