如果column1为空，则移位列数据，并使其他列为NULL

I have table with multiple column. I want to write UPDATE query using PHP and MYSQL which shifts the column data if only Col1 data is NULL. For Example:I have table with multiple column. I want to wr