MySQLMan Help


Tool bar     HOME

Table List

Table List lists all the tables in the database selected. You can find the following links beside each table name. Each link works as follows:

Browse
Displays all records in the table.

Select
Search for specific record(s). It helps you constructing basic "SELECT... FROM... WHERE..." query.

Properties
Show the property of the table. The following information will be displayed along with each field name:

  • Type
  • Null
  • Key
  • Default
  • Extra
You will be able to perform the following actions in here:
  • Change column property
  • Drop column
  • Set primary key
  • Set index
  • Set unique
Insert
Insert a new record to the table.

Drop
Removes the table from the database.
(action will be confirmed)

Empty
Deletes all the records in the table.
(action will be confirmed)

Tool bar     HOME
Related topics: Browse , Select , Properties , Insert