Using PHPMyAdmin to create a database and SQL

Creating database in MySQL server by PhpMyAdmin

I name this database as supermarket.



the result is successfully done like this



We can use create table functionality from phpMyAdmin in order to create a new table in the database.

Creating GROUP CATEGORY Table and its data:

Using PHPMYADMIN to create 3 fields for group category table:



Group Category table with creating table SQL code and its result:



Insert data:








Data Dictionary




Creating CATEGORY table and its data.





Create "category" table by SQL query.



Table Result



Insert Data:












Data Dictionary: