How to Create a MySQL Database Tutorial
Tutorial On How to Make a New MySQL Database
Before you can do anything with your database, you should create a table and set the corresponding fields in it.
Creating a table in PHPMyAdmin is simple. Just type the name, select the number of fields and click the Go button. You will then be taken to a setup screen where you should create the fields for the database.
Alternatively, you can run a MySQL query, which will create the table. The format is:
CREATE TABLE tablename (Fields)
The fields are defined as follows:
fieldname type(length) extra info,
The fields are separated by comma.
For example, if you wish to create a table called Members with 3 fields in it - FirstName, LastName and Age, you should execute the following query:
CREATE TABLE Members(FirstName varchar(15),LastName varchar(15),Age int);