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
Customise 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 `base_map_polygons` ORDER BY `description_en` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id floor_id fid objectid name_room room_number door_code shape_length shape_area category category_en room_name geometry service code_route description description_en Ascending Descending 1
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 1
1 2 NULL NULL 400 1109 B 1109 33.39054440513725 60.01202723454183 غرف نوم bedroom 300 [GEOMETRY - 657 B] 1 10138 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 2
2 2 NULL NULL 400 1119 B 1119 33.39632461157351 60.31827338734297 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10139 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 3
3 2 NULL NULL 400 1117 B 1117 33.3966696566352 60.31995720973415 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10140 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 4
4 2 NULL NULL 400 1115 B 1115 33.396344700301576 60.318296077432166 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10141 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 5
5 2 NULL NULL 400 1111 B1111 33.39645516773009 60.31890945137196 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10142 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 6
6 2 NULL NULL 400 1107 B 1107 33.39059445954842 60.01207935683588 غرف نوم bedroom 300 [GEOMETRY - 657 B] 1 10143 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 7
7 2 NULL NULL 400 1105 B 1105 33.39668872486146 60.319966894713865 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10144 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 8
8 2 NULL NULL 400 1124 B 1124 33.39652043634973 60.31876947183068 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10145 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 9
9 2 NULL NULL 400 1122 B 1122 33.396671751941994 60.31995850534973 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10146 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 10
10 2 NULL NULL 400 1120 B 1120 33.39634402694642 60.31830897710935 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10147 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 11
11 2 NULL NULL 400 1118 B 1118 33.39654248586591 60.31949615546806 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10148 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 12
12 2 NULL NULL 400 1116 B 1116 33.396520436512574 60.31876946818594 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10149 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 13
13 2 NULL NULL 400 1112 B 1112 33.39640926114453 60.31887302134485 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10150 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 14
14 2 NULL NULL 400 1108 B 1108 33.39139223941258 60.0427489544625 غرف نوم bedroom 300 [GEOMETRY - 721 B] 1 10151 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 15
15 2 NULL NULL 400 1106 B 1106 33.39654964451793 60.31952563724404 غرف نوم bedroom 300 [GEOMETRY - 737 B] 1 10152 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 16
16 2 NULL NULL 400 1104 B 1104 33.39649296185602 60.31875587499615 غرف نوم bedroom 300 [GEOMETRY - 737 B] 1 10153 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 17
17 2 NULL NULL 400 1102 B 1102 33.396493934842056 60.31911541242151 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10154 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 18
18 2 NULL NULL 401 1227 A1227 49.357357966665305 150.70901804337822 جناح Suite 301 [GEOMETRY - 721 B] 1 10155 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 19
19 2 NULL NULL 401 1225 A1225 44.67781776958738 127.38161909536605 جناح Suite 301 [GEOMETRY - 705 B] 1 10156 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 20
20 2 NULL NULL 401 1223 A1223 44.67785565948444 127.38205749405466 جناح Suite 301 [GEOMETRY - 705 B] 1 10157 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 21
21 2 NULL NULL 401 1221 A1221 44.677765272179 127.38159229516573 جناح Suite 301 [GEOMETRY - 705 B] 1 10158 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 22
22 2 NULL NULL 400 1217 B1217 34.56355491801469 63.227930607478946 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10159 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 23
23 2 NULL NULL 400 1215 B 1215 34.56369297799769 63.22838467553295 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10160 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 24
24 2 NULL NULL 400 1209 B 1209 34.563555204752696 63.2279315311524 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10161 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM base_map_polygons WHERE `base_map_polygons`.`id` = 25
25 2 NULL NULL 400 1207 B1207 34.563514203799436 63.22791087008997 غرف نوم bedroom 300 [GEOMETRY - 705 B] 1 10162 NULL NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Visualise GIS data Visualise GIS data Create view Create view
Bookmark this SQL query Bookmark this SQL query