Adding new record in MySQL with random values except ID

Is there a possibility in MySQL to fill specific number of columns in record by random values, except of ID (which should be auto-incremented)?

Something like that:

INSERT INTO 'table_name' ('ID', column1, column2, ...)
VALUES (<auto-increment> , random-value1, random-value2, ...);

I am testing something with database by removing few records, and after that i have to manually create few again. I'd like creating new records to be more automatic.