HOW TO CREATE DATABASE
To create database locally, firstly, you have to install a server on your device. e.g. Wamp server or xamp server.
Let’s install wamp server on our computer and follow the following steps to create a database;
- Open wamp server;
- Click on local host;
- Click on PhpMyAdmin;
- Insert ‘root’ as the username
- Leave password empty
- Click on login
- Click on Database and insert your preferred name
- Click on create
By following the steps above, you have created a Database successfully.
HOW TO CREATE TABLE ON DATABASE IN SQL
Follow the following steps to create table on Database;
- Click on the Database name
- Insert Table name
- Insert name
- Insert type
Type can be INT for integer (numbers), Varchar (Varchar can contain either numbers and letters) or BLOB for image
- Insert length
- Insert ‘NULL’ as Default
- Scroll to the right side and tick AI (auto increase)
Repeat the process to add more tables.
