sql insert和update question..multiple查询在一个语句中

I have a table called auctions, which has various columns such as username, auction id(the primary key), firstname, lastname, location etc, as well as a category column. The category column is blank by default, unless it is filled in for a particular record by a user.I have a table called auctions, which has vario