Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: phpmyadmin
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
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
phpmyadmin.pma__bookmark
phpmyadmin.pma__central_columns
phpmyadmin.pma__column_info
phpmyadmin.pma__designer_settings
phpmyadmin.pma__export_templates
phpmyadmin.pma__favorite
phpmyadmin.pma__history
phpmyadmin.pma__navigationhiding
phpmyadmin.pma__pdf_pages
phpmyadmin.pma__recent
phpmyadmin.pma__relation
phpmyadmin.pma__savedsearches
phpmyadmin.pma__table_coords
phpmyadmin.pma__table_info
phpmyadmin.pma__table_uiprefs
phpmyadmin.pma__tracking
phpmyadmin.pma__userconfig
phpmyadmin.pma__usergroups
phpmyadmin.pma__users
Number of tables: 19
v phpmyadmin pma__bookmark
* id : int(11)
* dbase : varchar(255)
* user : varchar(255)
* label : varchar(255)
* query : text
v phpmyadmin 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 phpmyadmin 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 phpmyadmin pma__designer_settings
* username : varchar(64)
* settings_data : text
v phpmyadmin pma__export_templates
* id : int(5) unsigned
* username : varchar(64)
* export_type : varchar(10)
* template_name : varchar(64)
* template_data : text
v phpmyadmin pma__favorite
* username : varchar(64)
* tables : text
v phpmyadmin pma__history
* id : bigint(20) unsigned
* username : varchar(64)
* db : varchar(64)
* table : varchar(64)
* timevalue : timestamp
* sqlquery : text
v phpmyadmin pma__navigationhiding
* username : varchar(64)
* item_name : varchar(64)
* item_type : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
v phpmyadmin pma__pdf_pages
* db_name : varchar(64)
* page_nr : int(10) unsigned
* page_descr : varchar(50)
v phpmyadmin pma__recent
* username : varchar(64)
* tables : text
v phpmyadmin 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 phpmyadmin pma__savedsearches
* id : int(5) unsigned
* username : varchar(64)
* db_name : varchar(64)
* search_name : varchar(64)
* search_data : text
v phpmyadmin pma__table_coords
* db_name : varchar(64)
* table_name : varchar(64)
* pdf_page_number : int(11)
* x : float unsigned
* y : float unsigned
v phpmyadmin pma__table_info
* db_name : varchar(64)
* table_name : varchar(64)
* display_field : varchar(64)
v phpmyadmin pma__table_uiprefs
* username : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
* prefs : text
* last_update : timestamp
v phpmyadmin 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 phpmyadmin pma__userconfig
* username : varchar(64)
* timevalue : timestamp
* config_data : text
v phpmyadmin pma__usergroups
* usergroup : varchar(64)
* tab : varchar(64)
* allowed : enum('Y','N')
v phpmyadmin pma__users
* username : varchar(64)
* usergroup : varchar(64)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship