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

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ÃüÁîÐÐÏÂÏÔʾ³öÀ´µÄʱ¼ä


Ïà¹ØÎÊ´ð£º

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ÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ