如何根据当前数据修改所有数据库列数据？

In my particular case, we've got a db table that, among other fields, has an "Image" field. We'd like to append ".jpg" to every row in this table for this column. To keep it simple we'll say it just has two columns...an ID column and an Image column. (bonus points for skipping rows that have an empty string for "Image".)In my particular case, we've got a db table tha