<8>mysql：表数据修改

语法

update <tbname> set <column>=<value>,... [where语句] [limit语句]

• where语句：设置修改条件
• limit语句：设置修改行数

例子

update Address set person_id=5,address='Chengdu' where address_id>=2;