How to Create Database & Table | Insert, Update & Delete Data | Delete Table & Database | Xampp
Create Database:
1. On the phpMyAdmin screen, select the Databases tab. You can click on the new link in the left panel alternatively.
2. Under the Create database, enter a Database name
3. Click the Create button
Create Table:
1. On the phpMyAdmin screen, select the students database.
Select the Structure tab.
2. Under the Create table, enter a table name and the number of columns.
3. Click the Go button. This field will prompt you to enter the column information.
Insert Data:
1. On the phpMyAdmin screen, select the students database and select the entries table.
2. Select the Insert tab.
3. For each record of data to be inserted, enter the value for each column without id.
4. Click the Go button.
Update / Edit Data:
1. Use the tree on the left sidebar to identify the database table you want to modify.
2. The Database field is displayed on the right pane. Use the edit links in the list of each field to change an individual field.
Delete Data:
1. Use the delete links in the list of each field to delete an individual field.
Delete Table:
1. Select the database in which you want to delete/remove table.
2. After clicking on the database list of all tables inside the selected database will show.
3. Now click the Drop button to delete the specific table.
4. Click on the OK button to delete tables.
Delete Database:
1. On the phpMyAdmin screen select the Databases tab.
2. Mark checks the database you want to remove.
3. Click on the drop.
On this page of the site you can watch the video online How to Create Database & Table | Insert, Update & Delete Data | Delete Table & Database | Xampp with a duration of hours minute second in good quality, which was uploaded by the user Mehrab Patwary 22 April 2022, share the link with friends and acquaintances, this video has already been watched 1,520 times on youtube and it was liked by 17 viewers. Enjoy your viewing!
