phpMyAdmin navigation bar: Structure

3.4.1. phpMyAdmin navigation bar: Structure

"Structure" presents a list of the available tables in the database, with the follwing accompanying options:

  • Browse: shows the content of the table.

  • Select: is used to make SQL queries to the table.

  • Insert: is used to insert new data into the table.

  • Properties: displays the structure of the table, ie. its fields, their type, length etc.

  • Drop: deletes the table (be careful!).

  • Empty: empties the content of the table, but does not delete the table itself, it leaves it empty (be careful again!).

The most frequently asked questions in this context are:

How do I delete a single record of the table?

Select the table, click on "Browse" and select "Delete" for the record in question.

If the password is stored encrypted with MD5, how do I change it?

Select the table, click on "Browse", then on "Edit" and enter, in clear text, the desired password. Select from the drop-down "Function" menu besides the field the desired function, in our case "MD5" (see Figure 3-9). See also Section 3.9.17.

Figure 3-9. phpMyAdmin: field functions.

phpMyAdmin: field functions.


 

Site Info v2.2.2

Last SeenLast Seen
Server TrafficServer Traffic
  • Total: 339,264,976
  • Today: 60,603
Server InfoServer Info
  • Oct 22, 2017
  • 04:09 pm PDT
 
 

Daily Inspiration