How to create temporary tables to test the sqoop export command in mysql db

How to create temporary tables to test the sqoop export command in mysql db. As under retail database or hr database does not allow to create a temporary tables for sqoop export command to practice. Please help.

@Joydeep_Sen You can follow the below link for MySQL access