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.

Click the "Execute Command" option. A window opens where you create your "insert" SQL statement, which is the statement that inserts new data into tables. Type your insert statement.

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.