How to delete data from database after select query excuted successfully

Question

My Question is that when data is select successfully then delete from MySQL db.When Select Query is fails due to large data then it can not delete data using shell script because in that case select data are also with image store in system then it can also move to another location and make it to tar file.