119.148.37.236 / localhost / proxima_database_two / cleanup_fk_map

There are no favorite tables.

New
information_schema
mysql
performance_schema
phpmyadmin
proxima_database
- proxima_database
- proxima_database_two
sajola_mms
test

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

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 :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or 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.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
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.
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.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (130 total, Query took 0.0005 seconds.) [child_table: VISIT_PRODUCT_INFO... - PODETAIL...]

SELECT * FROM `cleanup_fk_map` ORDER BY `child_table` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	constraint_name	child_table 1	child_column	child_pk	parent_table	parent_column	parent_pk	preserve_all_child
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 129	129	visit_product_info_ibfk_1	visit_product_info	vcustid	vprodid	visit_customer_info	vcustid	vcustid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 130	130	visit_product_info_ibfk_2	visit_product_info	ihid	vprodid	iomhangerinfo	ihid	ihid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 127	127	visit_customer_info_ibfk_1	visit_customer_info	vevent_id	vcustid	visit_event_info	vevent_id	vevent_id	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 128	128	visit_customer_info_ibfk_2	visit_customer_info	userid	vcustid	usertable	userid	userid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 124	124	user_order_owner_ibfk_1	user_order_owner	uprivid	NULL	user_priv	uprivid	uprivid	1
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 125	125	user_order_owner_ibfk_2	user_order_owner	userid	NULL	usertable	userid	userid	1
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 126	126	user_order_owner_ibfk_3	user_order_owner	userid	NULL	usertable	userid	userid	1
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 115	115	tna_details_ibfk_1	tna_details	plmid	tnaid	planmaster	plmid	plmid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 116	116	tna_details_ibfk_2	tna_details	tnatempid	tnaid	tnaprocess_templates	tnatempid	tnatempid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 113	113	tna_comments_details_ibfk_1	tna_comments_details	tnaid	commdid	tna_details	tnaid	tnaid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 114	114	tna_comments_details_ibfk_2	tna_comments_details	commid	commdid	tna_comments_master	commid	commid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 121	121	tnaprocess_templates_ibfk_1	tnaprocess_templates	tnaprid	tnatempid	tnaprocess	tnaprid	tnaprid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 122	122	tnaprocess_templates_ibfk_2	tnaprocess_templates	prid	tnatempid	processmaster	prid	prid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 123	123	tnaprocess_templates_ibfk_3	tnaprocess_templates	userid	tnatempid	usertable	userid	userid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 117	117	tnaprocess_input_ibfk_1	tnaprocess_input	plmid	tnaprsid	planmaster	plmid	plmid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 118	118	tnaprocess_input_ibfk_2	tnaprocess_input	dyeuid	tnaprsid	tnadyeunit	dyeuid	dyeuid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 119	119	tnaprocess_input_ibfk_3	tnaprocess_input	prid	tnaprsid	processmaster	prid	prid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 120	120	tnaprocess_input_ibfk_4	tnaprocess_input	userid	tnaprsid	usertable	userid	userid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 111	111	tdinspectionrcv_master_ibfk_1	tdinspectionrcv_master	dyeuid	dinrmid	tnadyeunit	dyeuid	dyeuid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 112	112	tdinspectionrcv_master_ibfk_2	tdinspectionrcv_master	userid	dinrmid	usertable	userid	userid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 107	107	sub_buyer_brand_ibfk_1	sub_buyer_brand	sub_buyid	sub_brid	sub_buyerinfo	sub_buyid	sub_buyid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 108	108	sub_buyerinfo_ibfk_1	sub_buyerinfo	buyid	sub_buyid	buyerinfo	buyid	buyid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 109	109	sub_buyerinfo_ibfk_2	sub_buyerinfo	countid	sub_buyid	country	countid	countid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 110	110	sub_buyerinfo_ibfk_3	sub_buyerinfo	buyerid_sub	sub_buyid	buyerinfo	buyid	buyid	0
Edit	Copy	Delete DELETE FROM cleanup_fk_map WHERE `cleanup_fk_map`.`id` = 106	106	podetail_ibfk_1	podetail	acholder	ppid	usertable	userid	userid	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view