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.

In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." ...

Once the schema is created, close the SQL Script window. You’re ready to create a table. Creating a table I’ve created a database called SERVERS, that will be listed in the SCHEMAS pane.