Generate Random Names For MySQL Database

I need to generate in the region of 2,000 random names to be inserted into a MySQL table in three fields: FirstName, LastName, Gender (as per ISO 5218). To help in this I have lists of 50 male first names, 50 female first names and 100 surnames. These could become temporary database tables if necessary. I could write some code in Python (after a modicum of research) but feel that doing it in MySQL is maybe the more sensible step. However I do not know how to code the SQL to achieve this. Is this possible?

Thank you...