mysqlµÄ¸üÐÂÓï¾ä - Java / Java SE
id name datetime 1 a 2010-05-13 10:15:00 2 b 2010-05-14 09:10:00 3 d 2010-05-14 10:10:00 ÈçºÎ½«¾àÀëÄ¿Ç°×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ Ð»Ð»¿© °¡ ºÇºÇ
update table_name set name='x' where datetime in (select max(datetime) as datetime from table_name)ÒýÓà update table_name set name='x' where datetime in (select max(datetime) as datetime from table_name) up£¡£¡£¡£¡ ¶Ô Ó¦¸Ã¾ÍÕâÑùµÄ ²»¹ýÈç¹ûÊý¾ÝÁ¿´óµÄ»°¿ÉÒÔÓÃexists update table_name a set name='x' where exists ( select 1 from ( select max(datetime) from table_name ) b where b.datetime=a.datetime ); update tble set name='x' where not exists (select 1 from tbl b where b.ttime<tble.ttime);ÒýÓà update table_name set name='x' where datetime in (select max(datetime) as datetime from table_name) ºÃÏñ²»ÐÐŶ ³öÏÖÕâÑùµÄ´íÎóŶ #1093 - You can't specify target table 'te_log' for update in from clause MYSQLÊý¾Ý¿â²»Ö§³Ö°É¡£ ´íÎóÌáʾ¾ÍÊÇ˵£¬²»ÄÜÏÈselect³öͬһ±íÖеÄijЩֵ£¬ÔÙupdateÕâ¸ö±í(ÔÚͬһÓï¾äÖÐ) ˼·£¬create table_name as select max(datetime) as datetime from table_name È»ºóupdate table_name set name='x' where datetime in ÉÏÃæÄǸö±í; È»ºódropÄǸö±íÊÔÊÔ ÊÔÁËһϲ»Ö§³Ö£¬×Ö²éѯÓÃÁÙ
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄÇ°ºóÁ½¸öÈÕÆÚÈ¡³ö ±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910 Êä³ö20090901 20090910 È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value) ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£ ´Ê¿âÔõôÉú³ÉÄØ£¿ ²»»á¡£ ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ ÕÒ±¾×Öµä ÒýÓà ´Ê¿âÔõôÉú³ÉÄØ£¿ Êý¾Ý¿â ºÇºÇ ÓÃmap ¼üÖµ¶ÔÓ¦ Èç¹ûÓÃÊý¾Ý¿ ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£ Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïenglish-unitedstates ΨһÇø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬ exec sp_helpsor ......
È磺 @superwaring("unchecked"); Õâ¸öÀïÃ涼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡ ûÓùý¡£¡£ ¿´jeeµÄapi javax.persistenceÀï @superwaring("unchecked");Ö»ÊǺöÂÔ ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓà »¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä, ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò, ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......