[Solved] Creating a database table (MySQL)

by


You should take a look at the mysql manual to learn about creating databases/tables:

Create Table Syntax

there are also examples of how to create tables.

Edit:
you can do either:

INSERT INTO recipe (name, category) VALUES ('Recipename', 'Categoryname');

since you only specify the columns where you want to add data

or 

INSERT INTO recipe VALUES (0, 'Recipename', 'CategoryName');

because you have to give ALL data for all columns if you don’t specify the columns.

1

solved Creating a database table (MySQL)