mysql delete from in ±¨´í£¡ ÔÚÏßµÈ
ÎÒÓÐÒ»¸ösqlÓï¾ä ´ó¸ÅÊÇÕâÑùµÄ£ºdelete from tab1 s where s.c=2 and (s.a,s.b) in (select t.a,m.b from tab1 t ,tab2 m where ...)
µ«ÊÇmysqlÒ»Ö±±¨ You can't specify target table 'tab1' for update in from clause £¬oracleÊÇ¿ÉÒÔÖ´ÐÐÕâ¸öÓï¾äµÄ£¬mysql¾Í²»ÐУ¬ÔõôÑù¸ÄÔìÕâ¸öÓï¾äÄØ£¿ËÓкõİ취£¿
or
DELETE s from tab1 s,tab2 t,tab1 m
WHERE s.b=m.b and s.a=t.a and s.c=2
or
delete s from tab1 s inner join tab2 m
on s.b=m.b
inner join tab1 t on s.a=t.a
where s.c=2
delete s from tab1 s inner join (select t.a,m.b from tab1 t ,tab2 m where ...) n on s.a=n.a and s.b=n.b
where s.c=2 ¸ã¶¨ÁË£¬Ð»Ð»WWWWAÐÖÁË¡£
»¹ÓÐWWWWbÐÖ£¬ÄãÁ©²»ÊÇͬһ¸ö£¿²îµã¿´´íÁË¡¢¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......