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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling 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 `tile`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts TileID AssociatedTile MaterialID TechnicalCharacteristicID PackingID ColorID ModelID FormatID GeometryID TypeID TextureID TariffGroupID Enabled CouldRotate Name ExternalCode Target DropShadow
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 23
23 NULL 1 32 892 47 1 94 1 2 3 26 -1 -1 Burgos GCS06001 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 25
25 NULL 1 31 892 91 1 94 1 2 3 26 -1 -1 Roncesvalles GCS06003 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 26
26 NULL 1 31 892 91 1 94 1 2 3 26 -1 -1 Leon GCS06004 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 28
28 NULL 1 31 892 66 1 94 1 2 3 26 -1 -1 Santiago GCS06005 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 31
31 NULL 1 6 892 91 1 94 1 2 3 24 -1 -1 Campiña Barro GCA0600C F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 32
32 NULL 1 7 892 91 1 94 1 2 3 24 -1 -1 Campiña Paja GCA0600B F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 33
33 NULL 1 7 892 91 1 94 1 2 3 24 -1 -1 Campiña Cotto GCA06008 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 38
38 NULL 1 30 892 91 1 94 1 2 3 24 -1 -1 Ferrara Ocre GFE06001 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 39
39 NULL 1 30 892 91 1 94 1 2 3 24 -1 -1 Ferrara Antico GFE06003 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 81
81 NULL 1 1 898 91 1 94 1 8 3 18 0 0 Peldaño P. Cotto GCT06023 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 82
82 NULL 1 33 892 91 1 94 1 2 3 24 0 -1 sds GCT06003 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 108
108 NULL 1 25 920 91 1 94 1 2 3 24 -1 -1 Toscana Ocre GTS06001 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 113
113 NULL 1 1 893 91 1 94 2 8 3 18 -1 0 Peldaño Roncesvalles GCSPA003 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 114
114 NULL 1 1 893 91 1 94 2 8 3 18 -1 0 Peldaño Leon GCSPA004 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 116
116 NULL 1 1 98 66 1 94 2 8 3 18 -1 0 Peldaño Santiago GCSPA005 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 122
122 NULL 1 1 894 91 1 94 1 8 3 21 -1 0 Peldaño Esquina Roncesvalles GCSPB003 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 123
123 NULL 1 1 894 91 1 94 1 8 3 21 -1 0 Peldaño Esquina Leon GCSPB004 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 125
125 NULL 1 1 82 66 1 94 1 8 3 21 -1 0 Peldaño Esquina Santiago GCSPB005 F 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 129
129 NULL 1 1 894 91 1 94 1 8 3 21 0 0 Peldaño Esquina Cotto GCT06033 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 149
149 NULL 1 3 833 41 1 99 1 2 3 22 -1 -1 Levante Cobalto GLV08005 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 150
150 NULL 1 3 833 91 1 99 1 2 3 22 -1 -1 Levante Terra GLV08007 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 164
164 NULL 1 3 833 41 1 99 1 2 3 22 -1 -1 Venice Azul GVC08003 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 165
165 NULL 1 4 833 53 1 99 1 2 3 22 -1 -1 Venice Gris GVC08002 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 166
166 NULL 1 3 833 64 1 99 1 2 3 22 -1 -1 Venice Rojo GVC08006 F -1
Edit Edit Copy Copy Delete Delete
DELETE FROM tile WHERE `tile`.`TileID` = 169
169 NULL 1 3 833 66 1 99 1 2 3 22 -1 -1 Venice Esmeralda GVC08005 F -1
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view