Create a Table
You should then be prompted to create a table in the database. We're going to create a table called books and enter 4 in the number of fields. Enter the following fields: ISBN, Author, Title and Price.
Next, set the data types and length/values as show below. The ISBN will serve as the primary key.
To set the primary key, choose the database and then the table and click on the primary icon as shown below.
Do you need help with MySQL? 



Leave a comment