annachakrakarnataka.in / 127.0.0.1 / karnataka / optimiseddata_ba4ewvhu9p5dtf

There are no favorite tables.

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

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - 24 (17781 total, Query took 0.1280 seconds.) [to_name: PQRS... - PQRS...]

SELECT * FROM `optimiseddata_ba4ewvhu9p5dtf` ORDER BY `to_name` DESC

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

Filter rows:

scenario	from	from_state	from_id	from_name	from_district	from_lat	from_long	to	to_state	to_id	to_name 1	to_district	to_lat	to_long	commodity	quantity	distance	approve_admin	approve_district	new_id_admin	new_id_district	new_name_admin	new_name_district	reason_admin	reason_district	new_distance_admin	new_distance_district	district_change_approve	status
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100002	PQRS	Ludhiana	30.7501586	75.9103311	Wheat	772.3909101	16.292	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100004	PQRS	Ludhiana	30.7812375	75.8879253	Wheat	1223.623752	17.464	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100005	PQRS	Ludhiana	30.7495716	75.8859484	Wheat	643.4672411	14.779	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100006	PQRS	Ludhiana	30.7641786	75.8820401	Wheat	1046.353707	14.283	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100007	PQRS	Ludhiana	30.7321781	75.9127321	Wheat	496.125905	15.513	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100011	PQRS	Ludhiana	30.7424018	75.8593731	Wheat	515.1191241	10.78	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100012	PQRS	Ludhiana	30.7409523	75.8612542	Wheat	387.9221114	10.764	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100013	PQRS	Ludhiana	30.776018	75.8727684	Wheat	475.9815817	16.09	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100014	PQRS	Ludhiana	30.7646688	75.8433125	Wheat	807.4995879	14.043	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100015	PQRS	Ludhiana	30.7613952	75.8214209	Wheat	652.6760746	15.043	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100018	PQRS	Ludhiana	30.7439268	75.8521699	Wheat	402.8864658	11.351	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100019	PQRS	Ludhiana	30.7398003	75.849167	Wheat	536.9901037	9.902	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100020	PQRS	Ludhiana	30.7394531	75.8479105	Wheat	431.6640705	10.123	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100021	PQRS	Ludhiana	30.7409853	75.8503802	Wheat	886.9257769	9.534	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100022	PQRS	Ludhiana	30.7321016	75.8345395	Wheat	561.1632917	8.286	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100023	PQRS	Ludhiana	30.7290952	75.8502677	Wheat	432.8151747	10.195	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100024	PQRS	Ludhiana	30.7035945	75.8462185	Wheat	797.1396502	6.111	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100029	PQRS	Ludhiana	30.7924726	75.874583	Wheat	2137.600477	18.853	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100030	PQRS	Ludhiana	30.6766844	75.8052239	Wheat	744.7644096	2.319	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100031	PQRS	Ludhiana	30.6729977	75.8036112	Wheat	739.0088887	2.87	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100033	PQRS	Ludhiana	30.7163635	75.8148893	Wheat	1404.922661	3.69	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100035	PQRS	Ludhiana	30.7235548	75.7907354	Wheat	421.8796849	5.792	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100036	PQRS	Ludhiana	30.7102611	75.7892903	Wheat	880.5947038	3.98	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100037	PQRS	Ludhiana	30.7424034	75.810352	Wheat	1617.876936	7.109	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Optimized	Depot	Punjab	1690	ABCD	Ludhiana	30.693601	75.808527	FPS	Punjab	104100100040	PQRS	Ludhiana	30.725878	75.868553	Wheat	328.6402457	10.01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view