最快的方法来区分数据集并将大量行更新/插入到大型MySQL表中？

The schema

I have a MySQL database with one large table (5 million rows say). This table has several fields for actual data, an optional comment field, and fields to record when the row was first added and when the data is deleted. To simplify to one "data" column, it looks a bit like this:I have a MySQL database with one l