1. 

   Kevin New Member

   Joined:

   Oct 23, 2005

   Messages:

   12,728

   Likes Received:

   55

   采集的时候没注意，某个字段的开始和结束都多了好多空格，请问怎么批量去掉呢？谢谢！:lovely:
   mysql数据库的
   最好是在phpmyadmin下可以运行的代码，谢谢了！
   
   在phpmyadmin中运行：
   

   Code:

   update blog_spaceitems set subject = trim(subject);

   无效!:cry:

    

   #1 Kevin, Jan 8, 2007
2. 

   Kevin New Member

   Joined:

   Oct 23, 2005

   Messages:

   12,728

   Likes Received:

   55

   

    

   #2 Kevin, Jan 8, 2007
3. 

   西子宜 Well-Known Member

   Joined:

   Sep 5, 2005

   Messages:

   15,739

   Likes Received:

   62

   呵呵

    

   #3 西子宜, Jan 8, 2007

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in