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.
Sur cette page du site, vous pouvez voir la vidéo en ligne How to Create Database & Table | Insert, Update & Delete Data | Delete Table & Database | Xampp durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Mehrab Patwary 22 avril 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,520 fois et il a aimé 17 téléspectateurs. Bon visionnage!
