Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: test
Page-related settingsClick on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time
1
test
{"j_tabs":{"test.pma__bookmark":1,"test.pma__central_columns":1,"test.pma__column_info":1,"test.pma__designer_settings":1,"test.pma__export_templates":1,"test.pma__favorite":1,"test.pma__history":1,"test.pma__navigationhiding":1,"test.pma__pdf_pages":1,"test.pma__recent":1,"test.pma__relation":1,"test.pma__savedsearches":1,"test.pma__table_coords":1,"test.pma__table_info":1,"test.pma__table_uiprefs":1,"test.pma__tracking":1,"test.pma__userconfig":1,"test.pma__usergroups":1,"test.pma__users":1},"h_tabs":{"test.pma__bookmark":1,"test.pma__central_columns":1,"test.pma__column_info":1,"test.pma__designer_settings":1,"test.pma__export_templates":1,"test.pma__favorite":1,"test.pma__history":1,"test.pma__navigationhiding":1,"test.pma__pdf_pages":1,"test.pma__recent":1,"test.pma__relation":1,"test.pma__savedsearches":1,"test.pma__table_coords":1,"test.pma__table_info":1,"test.pma__table_uiprefs":1,"test.pma__tracking":1,"test.pma__userconfig":1,"test.pma__usergroups":1,"test.pma__users":1}}
[]
{"pma__bookmark":"dbase","pma__central_columns":"db_name","pma__column_info":"db_name","pma__designer_settings":"username","pma__export_templates":"username","pma__favorite":"username","pma__history":"username","pma__navigationhiding":"username","pma__pdf_pages":"db_name","pma__recent":"username","pma__relation":"master_db","pma__savedsearches":"username","pma__table_coords":"db_name","pma__table_info":"db_name","pma__table_uiprefs":"username","pma__tracking":"db_name","pma__userconfig":"username","pma__usergroups":"usergroup","pma__users":"username"}
-1
1
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
test.pma__bookmark
test.pma__central_columns
test.pma__column_info
test.pma__designer_settings
test.pma__export_templates
test.pma__favorite
test.pma__history
test.pma__navigationhiding
test.pma__pdf_pages
test.pma__recent
test.pma__relation
test.pma__savedsearches
test.pma__table_coords
test.pma__table_info
test.pma__table_uiprefs
test.pma__tracking
test.pma__userconfig
test.pma__usergroups
test.pma__users
Number of tables: 19
v test pma__bookmark
* id : int(10) unsigned
* dbase : varchar(255)
* user : varchar(255)
* label : varchar(255)
* query : text
v test pma__central_columns
* db_name : varchar(64)
* col_name : varchar(64)
* col_type : varchar(64)
* col_length : text
* col_collation : varchar(64)
* col_isNull : tinyint(1)
* col_extra : varchar(255)
* col_default : text
v test pma__column_info
* id : int(5) unsigned
* db_name : varchar(64)
* table_name : varchar(64)
* column_name : varchar(64)
* comment : varchar(255)
* mimetype : varchar(255)
* transformation : varchar(255)
* transformation_options : varchar(255)
* input_transformation : varchar(255)
* input_transformation_options : varchar(255)
v test pma__designer_settings
* username : varchar(64)
* settings_data : text
v test pma__export_templates
* id : int(5) unsigned
* username : varchar(64)
* export_type : varchar(10)
* template_name : varchar(64)
* template_data : text
v test pma__favorite
* username : varchar(64)
* tables : text
v test pma__history
* id : bigint(20) unsigned
* username : varchar(64)
* db : varchar(64)
* table : varchar(64)
* timevalue : timestamp
* sqlquery : text
v test pma__navigationhiding
* username : varchar(64)
* item_name : varchar(64)
* item_type : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
v test pma__pdf_pages
* db_name : varchar(64)
* page_nr : int(10) unsigned
* page_descr : varchar(50)
v test pma__recent
* username : varchar(64)
* tables : text
v test pma__relation
* master_db : varchar(64)
* master_table : varchar(64)
* master_field : varchar(64)
* foreign_db : varchar(64)
* foreign_table : varchar(64)
* foreign_field : varchar(64)
v test pma__savedsearches
* id : int(5) unsigned
* username : varchar(64)
* db_name : varchar(64)
* search_name : varchar(64)
* search_data : text
v test pma__table_coords
* db_name : varchar(64)
* table_name : varchar(64)
* pdf_page_number : int(11)
* x : float unsigned
* y : float unsigned
v test pma__table_info
* db_name : varchar(64)
* table_name : varchar(64)
* display_field : varchar(64)
v test pma__table_uiprefs
* username : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
* prefs : text
* last_update : timestamp
v test pma__tracking
* db_name : varchar(64)
* table_name : varchar(64)
* version : int(10) unsigned
* date_created : datetime
* date_updated : datetime
* schema_snapshot : text
* schema_sql : text
* data_sql : longtext
* tracking : set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')
* tracking_active : int(1) unsigned
v test pma__userconfig
* username : varchar(64)
* timevalue : timestamp
* config_data : text
v test pma__usergroups
* usergroup : varchar(64)
* tab : varchar(64)
* allowed : enum('Y','N')
v test pma__users
* username : varchar(64)
* usergroup : varchar(64)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship