The MySQL Workbench main window. How to create tables and add data to MySQL database with MySQL Workbench Your email has been sent The MySQL Workbench GUI is cross-platform, open source, and ...

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.

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.

However, if you have already created a database and want to export the statements that populated its tables with data, you can use MySQL's "mysqldump" function to create a file containing the ...