使用union all + inner join 更新 速度很快。 SQL语法: update table_test tt inner join ( select -1 as id, 'test' as name, 1 as age ---创建列头 union all select 1, '小红', 18 union all select 2, '…