Databáze řešení

Becoming familiar with databases and phpMyAdmin  Tisknout tento článek



Becoming familiar with databases and phpMyAdmin

This video assumes you've already logged in to phpMyAdmin.

Now let's familiarize ourselves with databases and phpMyAdmin.

phpMyAdmin allows us to have complete access to the MySQL databases in our account.

The databases are listed here in the left pane.

Databases consist of one or more tables, and it is within these tables that database information (or data) is stored.

This particular database has one table, and it's called details.

When we click on a database name in the left pane, we can see more information about the tables within the database in the right pane.

We can browse a table to see the individual records...

... we can see the structure of a table and perform certain actions...

... we can search through a table for specific keywords...

... we can insert new rows (or fields) into a table...

... we can delete the contents of a table...

... or we can delete (or drop) an entire table altogether.

We can alternatively click the Structure tab to view the database structure...

... click the SQL tab if we want to enter direct queries to the database...

... click the Search tab to perform a search...

... Import or export databases or tables...

... and several other operations.

Now let's take a closer look at the details table. Click the table name in the left pane, then click the Structure tab.

The structure of a table lists all teh table's fields, along with the type of fields and other information.

We can also see which field within the table is the Primary Key field.

If you ever need additional help, you can access either phpMyAdmin or MySQL documention by clicking the appropriate help icon here.

Click the Home icon to return to the home page of your phpMyAdmin.

This is the end of the tutorial. You should now be more familiar with databases, and how to use phpMyAdmin to access them.

Byla tato odpověď nápomocná?

Související články

Renaming database tables with phpMyAdmin
Renaming database tables with phpMyAdmin This video assumes you've already logged in to...
Deleting a table from a database with phpMyAdmin
Deleting a table from a database with phpMyAdmin This video assumes you've already logged in to...
Exporting databases and tables with phpMyAdmin
Exporting databases and tables with phpMyAdmin This video assumes you've already logged in to...
Importing databases and tables with phpMyAdmin
Importing databases and tables with phpMyAdmin This video assumes you've already logged in to...
Running SQL queries on a database with phpMyAdmin
Running SQL queries on a database with phpMyAdmin This video assumes you've already logged in to...