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? Gain advice from Builder AU forums

Leave a comment

You must read and type the 6 chars within 0..9 and A..F

* indicates mandatory fields.

Log in


Sign up | Forgot your password?

What's on?