Learn PHP online : PHP Day-20

PHP MY ADMIN

PHP MY ADMIN

This is an environment to work with the mysql database. To open the url address is http://localhost/phpmyadmin/ .

Options of PHP My Admin:

Browse: By using this option we can fetch the records from the table.

Structure: By using this option we can change the table structure and we can add new field and new column. We can also remove the columns edit the column etc..

Insert: To insert the records in a table.

SQL: This option is providing a text box to write the sql statements.

Ex: insert users

Empty:  By using this option we can delete all records of a table.

Drop: By using this option we can delete the entire table along with the structure.

Operations: By using this option we can change the table name, data base engine etc..

Export: By using this option we can export the database objects as an SQL file.

Import: To import the cri file into another data base.