After entering the necessary data, hit Enter on your keyboard. Double-click under that newly created row and create another. Once you add all of your data, click Apply to execute the SQL Script.

Create a query expression to insert the data into the MySQL database. Use a prepared statement to properly escape data and avoid MySQL injection exploits.

MySQL 5.6 Reference Manual: Create Database Syntax MySQL 5.6 Reference Manual: Create Table Syntax MySQL 5.6 Reference Manual: Insert Syntax MySQL 5.6 Reference Manual: Select Syntax Advertisement ...

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.