How to Create Database & Table | Insert, Update & Delete Data | Delete Table & Database | Xampp

Publicado el: 22 abril 2022
en el canal de: Mehrab Patwary
1,520
17

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.


En esta página del sitio puede ver el video en línea How to Create Database & Table | Insert, Update & Delete Data | Delete Table & Database | Xampp de Duración hora minuto segunda en buena calidad , que subió el usuario Mehrab Patwary 22 abril 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,520 veces y le gustó 17 a los espectadores. Disfruta viendo!