Create mySQL datatabase & table – XAMPP

Credit to this website: https://www.android-examples.com/create-table-in-mysql-db-using-phpmyadmin-xampp-server/

Hi All,

I am going to show on how to create a mySQL database and its table.

Step 1: Create a database

To create a database, just simply click tab Databases, insert your any database named such as “cpu_temp”. Choose “utf8_general_ci” and click create.You will see the cpu_temp at directory project:

Step 2: Create a table

1. Enter Table Name , Number of columns you want to create in Table for example ( Id, temp, date, time…etc ).Then press GO button.

CREATE TABLE IF NOT EXISTS in MySQL db using phpmyadmin xampp server

2. Now enter Column name, Column data Type, Column Length/Values( 255 ) , If you are using id field then Tick A_I( auto increment ).( Click on image to see it into full size ).

creating tables

For example:

3. After completing all the submission click on Save button.

save table

4. Here you go now your table is successfully created.