±ÈÈ磺±í1×Ö¶Îtop °üÀ¨Êý¾Ý¡°a,b,c,d¡± ÎÒÒª¸üÐÂtop×Ö¶ÎÊý¾ÝΪ¡°a,c,d¡± Ò²¾ÍÊÇÈ¥µô¡°,b¡± µ«ÊÇ¡°,b¡±µÄλÖò»È·¶¨Ò²¿ÉÄÜÊÇ¡°a,c,d,b¡±
û¿´¶®ÄãµÄÎÊÌ⣬ÊǸüÐÂÊý¾Ý¿âÖеÄ×ֶΣ¿
Èç¹ûÄÇÑùÓ¦¸ÃÊÇSQLµÄÎÊÌâÁË
SQL code:
update tablename set top=replace(top,',b','');
ÕâÑùÖ»ÄÜÌæ»»¡®,b¡¯
ÒòΪ¡®,b¡¯µÄλÖÃÊDz»Ò»¶¨µÄ£¬ÓпÉÄÜ»áÊÇ¡®b¡¯£¬Ò²¾ÍÊÇ˵ÓпÉÄÜ¡®b¡¯ÅÅÔÚÇ°Ãæ»òºóÃæ
Õâ¾ÍÖ»ÄÜÓóÌÐòÍâÃæÊµÏÖÁË£¬±ÈÈçÓÃÕýÔò±í´ïʽ°ÑËüÌæ»»µô
Ö±½Ó°ÑÕûÁÐÌæ»»ÁËÄØ£¿
¶Ô£¡ÎÒ¾ÍÊÇÒ»¸öºÃµÄʵÁУ¡
SQL codeupdate t
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......