1. runoob_id  runoob_title  runoob_author  
  2. ---------  ------------  ---------------
  3.         3  Java          qq.com         
  4.         4  Python        qq.com         
  5.         6  JavaScript    csdn.com       
  6.         7  SQL           baidu.com      
  7.         8  R             weixin.com     
  8.         9  Objective-C   qq.com
  1. runoob_id  runoob_title  runoob_author  
  2. ---------  ------------  ---------------
  3.         3  Java          qq.com         
  4.         4  Python        qq.com         
  5.         6  JavaScript    csdn.com       
  6.         7  SQL           baidu.com      
  7.         8  R             weixin.com     
  8.         9  Objective-C   qq.com   
  9. --  runoob 为主键
  1. run_id_bp  run_title_bp  run_author_bp 
  2. ---------  ------------  ---------------
  3.                 6  JavaScript    csdn.com         
  4.                 7  SQL           baidu.com        
  5.         8  R             weixin.com 
  6.                 9  Objective-C   qq.com           
  7. -- runoob 为主键
  1. UPDATE table_name SET field1=new-value1, field2=new-value2
  2. [WHERE Clause]

1.更新单个数据

  1. UPDATE  `runoob` 
  2. SET `runoob_title`='Java1' 
  3. WHERE `runoob_id`=3
  1. runoob_id  runoob_title  runoob_author  
  2. ---------  ------------  ---------------
  3.         3  Java1         qq.com         
  4.         4  Python        qq.com         
  5.         6  JavaScript    csdn.com       
  6.         7  SQL           baidu.com      
  7.         8  R             weixin.com     
  8.         9  Objective-C   qq.com

2.更新多个数据

  1. UPDATE  `runoob` 
  2. SET `runoob_title`='Java1',
  3.         `runoob_author`='backup.com' 
  4. WHERE `runoob_id`=3
  1. runoob_id  runoob_title  runoob_author  
  2. ---------  ------------  ---------------
  3.         3  Java1         backup.com     
  4.         4  Python        qq.com         
  5.         6  JavaScript    csdn.com       
  6.         7  SQL           baidu.com      
  7.         8  R             weixin.com     
  8.         9  Objective-C   qq.com

3.多表数据更新

  1. UPDATE table_name1,table_name2,...table_nameN 
  2. SET table_name1.field1=new-value1, table_name2.field2=new-value2
  3. [WHERE table_name1.key1=value1,table_name2.key2=value2,...,table_nameN.keyN=valueN]
  1. UPDATE  
  2.     `runoob`,
  3.   `runoob_backup` 
  4. SET 
  5.   `runoob`.`runoob_title` 
  6.    ='Java_bp',
  7.   `runoob_backup`.`runoob_title_backup`='python_bp'
  8. WHERE 
  9.       `runoob`.`runoob_id`=3 AND`runoob_backup`.`runoob_id_backup`=6
  1. 3  Java_bp     backup.com
  2. 4  Python      qq.com   
  3. 6  JavaScript  csdn.com  
  4. 7  SQL         baidu.com 
  5. 8  R           weixin.com 9  Objective-C qq.com
  1. 6  python_bp   csdn.com   
  2. 7  SQL         baidu.com 
  3. 8  R           weixin.com 9  Objective-C qq.com