Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

You should see the data listed (Figure A). Figure A Continue adding data to the table in the same fashion. And that’s all there is to creating a table and inserting data into it on MySQL.

If I create an identical non-temporary table the on-disk data file is ~100MB (engine=myisam). I have tmp_table_size for MySQL set to 256MB and max_heap_table_size set to 512MB.