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 `apartments`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id name type label citizenid
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 4
4 apartment31298 apartment3 Integrity Way 1298 GLV09234
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 5
5 apartment33250 apartment3 Integrity Way 3250 KSB30478
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 6
6 apartment48683 apartment5 Fantastic Plaza TAG42688
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 7
7 apartment53919 apartment5 Fantastic Plaza 3919 NAG67505
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 8
8 apartment54085 apartment5 Fantastic Plaza 4085 NJT90383
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 9
9 apartment32824 apartment3 Integrity Way 2824 QJC76955
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 10
10 apartment13341 apartment1 South Rockford Drive 3341 PWZ39287
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 11
11 apartment41796 apartment5 Fantastic Plaza IVM70188
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 12
12 apartment34785 apartment3 Integrity Way 4785 QPY67501
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 13
13 apartment56332 apartment5 Fantastic Plaza 6332 IUI12521
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 14
14 apartment54199 apartment5 Fantastic Plaza 4199 BGZ89512
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 15
15 apartment28785 apartment5 Fantastic Plaza HMV60695
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 16
16 apartment59354 apartment5 Fantastic Plaza 9354 ZSU73755
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 17
17 apartment51848 apartment5 Fantastic Plaza 1848 GLD05971
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 18
18 apartment15670 apartment1 South Rockford Drive 5670 IFL88892
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 19
19 apartment55011 apartment5 Fantastic Plaza 5011 WNA72165
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 20
20 apartment45564 apartment4 Tinsel Towers 5564 FTV53535
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 21
21 apartment21618 apartment2 Morningwood Blvd 1618 MWG05510
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 22
22 apartment52133 apartment5 Fantastic Plaza 2133 VHE90291
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 23
23 apartment52184 apartment5 Fantastic Plaza 2184 DOY76610
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 24
24 apartment49946 apartment4 Tinsel Towers 9946 PFB19170
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 25
25 apartment22043 apartment2 Morningwood Blvd 2043 LBB77428
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 26
26 apartment44007 apartment4 Tinsel Towers 4007 JBG78807
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 27
27 apartment33528 apartment3 Integrity Way 3528 STO78957
Edit Edit Copy Copy Delete Delete
DELETE FROM apartments WHERE `apartments`.`id` = 28
28 apartment1132 apartment1 South Rockford Drive 132 HJD02750
With selected: With selected:
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