Recent
`ugc_db`.`tamil`
`ugc_db`.`english1`
`ugc_db`.`malayalam`
`mysql`.`slow_log`
`mysql`.`table_stats`
`mysql`.`tables_priv`
`phpmyadmin`.`pma__central_columns`
`phpmyadmin`.`pma__pdf_pages`
`phpmyadmin`.`pma__relation`
`phpmyadmin`.`pma__table_coords`
Favorites
There are no favorite tables.
New
dat
information_schema
moodle
mysql
performance_schema
phpmyadmin
test
ugc_db
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Databases
SQL
Status
User accounts
Export
Import
Settings
(current)
Variables
Charsets
Engines
Plugins
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Manage your settings
Two-factor authentication
Features
SQL queries
Navigation panel
Main panel
Export
Import
Startup
Database structure
Table structure
Browse mode
Edit mode
Tabs
Display relational schema
Startup
Customize startup page.
Startup
Show create database form
Show statistics
Allow to display database and table statistics (e.g. space usage).
Show detailed MySQL server information
Database structure
Choose which details to show in the database structure (list of tables).
Database structure
Show table charset
Show or hide a column displaying the charset for all tables.
Show table comments
Show or hide a column displaying the comments for all tables.
Show creation timestamp
Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp
Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp
Show or hide a column displaying the Last check timestamp for all tables.
Table structure
Settings for the table structure (list of columns).
Table structure
Hide table structure actions
Whether the table structure actions should be hidden.
Show column comments
Whether column comments should be shown in table structure view
Default transformations
Default transformations for Hex
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
2
Default transformations for Substring
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 all …
Default transformations for Bool2Text
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
T F
Default transformations for External
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 local
Default transformations for Inline
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 100
Default transformations for TextImageLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 50
Default transformations for TextLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Browse mode
Customize browse mode.
Browse mode
Table navigation bar
Use only icons, only text or both.
Icons
Text
Both
How to display various action links
Use only icons, only text or both.
Icons
Text
Both
Allow to display all the rows
Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display
Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
25
50
100
250
500
Default sorting order
SMART
- i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
ASC
DESC
SMART
Highlight pointer
Highlight row pointed by the mouse cursor.
Row marker
Highlight selected rows.
Grid editing: trigger action
Click
Double click
Disabled
Grid editing: save all edited cells at once
Repeat headers
Repeat the headers every X cells,
0
deactivates this feature.
Limit column characters
Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links
These are Edit, Copy and Delete links.
Nowhere
Left
Right
Both
Show row links anyway
Whether to show row links even in the absence of a unique key.
Primary key default sort order
Default sort order for tables with a primary key.
None
Ascending
Descending
Remember table's sorting
When browsing tables, the sorting of each table is remembered.
Relational display
For display Options
key
display column
Edit mode
Customize edit mode.
Edit mode
Protect binary columns
Disallow BLOB and BINARY columns from editing.
No
blob
noblob
all
Show function fields
Display the function fields in edit/insert mode.
Show field types
Defines whether or not type fields should be initially displayed in edit/insert mode.
Number of inserted rows
How many rows can be inserted at one time.
Foreign key dropdown order
Sort order for items in a foreign-key dropdown box;
content
is the referenced data,
id
is the key value.
content-id id-content
Foreign key limit
A dropdown will be used if fewer items are present.
Tabs
Choose how you want tabs to work.
Tabs
How to display the menu tabs
Use only icons, only text or both.
Icons
Text
Both
Default server tab
Tab that is displayed when entering a server.
Welcome
Databases
Status
Variables
Privileges
Default database tab
Tab that is displayed when entering a database.
Structure
SQL
Search
Operations
Default table tab
Tab that is displayed when entering a table.
Structure
SQL
Search
Insert
Browse
Display relational schema
Display relational schema
Paper size
A3
A4
A5
letter
legal