Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `fci_leg1_gfyip22f19cvwh` ORDER BY `type` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
district name id warehousetype type Ascending Descending 1 latitude longitude storage uniqueid active
Bangalore A 321 FCI Motorable 12.98758333 77.76775 1064880 WH_66ed4ab30288 1
Bangalore A 322 FCI Motorable 13.00197222 77.66772222 555100 WH_66ed4ab3036e 1
Kolar A 323 FCI Motorable 12.97508333 78.25697222 65600 WH_66ed4ab3046c 1
Kolar A 324 FCI Motorable 13.00195 78.17289 44000 WH_66ed4ab30568 1
Kolar A 325 FCI Motorable 12.99139 77.94859 250000 WH_66ed4ab30672 1
Kolar A 326 FCI Motorable 13.04288 78.1571 116800 WH_66ed4ab30760 1
Dharwad A 327 FCI Motorable 15.38320178 75.10874607 240000 WH_66ed4ab30851 1
Belagavi A 328 FCI Motorable 15.90813766 74.55327698 82500 WH_66ed4ab3094a 1
Belagavi A 329 FCI Motorable 15.7942296 74.4441486 250000 WH_66ed4ab30a49 1
Vijayapura A 330 FCI Motorable 16.83111593 75.73632516 120000 WH_66ed4ab30b45 1
Vijayapura A 331 FCI Motorable 16.8462902 75.7889266 240000 WH_66ed4ab30c35 1
Dharwad A 332 FCI Motorable 15.38435 75.10931 130000 WH_66ed4ab30d22 1
Dharwad A 333 FCI Motorable 15.34291 75.16974 360000 WH_66ed4ab30e11 1
Gadag A 334 FCI Motorable 15.45361111 75.68305556 314250 WH_66ed4ab30f14 1
Bagalkote A 335 FCI Motorable 16.15499028 75.67274778 327800 WH_66ed4ab31023 1
Bagalkote A 336 FCI Motorable 16.149352 75.672288 122320 WH_66ed4ab3112b 1
Haveri A 337 FCI Motorable 14.64801301 75.57391171 265000 WH_66ed4ab31234 1
Kodagu A 338 FCI Motorable 12.480859 75.945934 31320 WH_66ed4ab3133f 1
Mandya A 339 FCI Motorable 12.606992 77.043407 117160 WH_66ed4ab31437 1
Mandya A 340 FCI Motorable 12.606522 77.045892 58520 WH_66ed4ab31539 1
Mandya A 341 FCI Motorable 12.547525 76.933691 79280 WH_66ed4ab31634 1
Mandya A 342 FCI Motorable 12.49716 76.8139 80000 WH_66ed4ab31756 1
Mysuru A 343 FCI Motorable 12.446712 76.385263 125760 WH_66ed4ab3185a 1
Mysuru A 344 FCI Motorable 12.12917 76.678761 100200 WH_66ed4ab3196b 1
Mysuru A 345 FCI Motorable 12.343554 76.641256 157630 WH_66ed4ab31a7f 1
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query