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.
Nesta página do site você pode assistir ao vídeo on-line How to Create Database & Table | Insert, Update & Delete Data | Delete Table & Database | Xampp duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Mehrab Patwary 22 Abril 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,520 vezes e gostou 17 espectadores. Boa visualização!
