Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: comprative
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (9848 total, Query took 0.0014 seconds.)
SELECT * FROM `comprative`

Full texts id site indentprno comparative_no comparative_date CompanyId compared_by status_active po_del_status mapid include_gst
1 APH 1 APH/17-18//0001 2017-07-11 3 9 0 0 NULL1
2 APH 5 APH/17-18//0002 2017-07-22 3 17 0 0 NULL1
3 APH 7 APH/17-18//0003 2017-07-22 3 9 1 0 NULL1
4 APH 13 APH/17-18//0004 2017-07-25 3 17 0 0 NULL1
5 APH 14 APH/17-18//0005 2017-07-26 3 12 0 0 NULL1
6 APH 15 APH/17-18//0006 2017-07-26 3 12 0 0 NULL1
7 APH 16 APH/17-18//0007 2017-07-26 3 12 0 0 NULL1
8 APH 11 APH/17-18//0008 2017-07-26 3 13 0 0 NULL1
9 APH 18 APH/17-18//0009 2017-07-27 3 12 0 1 NULL1
10 APH 19 APH/17-18//0010 2017-07-27 3 9 0 0 NULL1
11 APH 20 APH/17-18//0011 2017-07-28 3 23 0 0 NULL1
12 APH 26 APH/17-18//0012 2017-07-29 3 9 1 0 NULL1
13 APH 27 APH/17-18//0013 2017-07-29 3 9 0 1 NULL1
14 APH 28 APH/17-18//0014 2017-07-29 3 9 1 0 NULL1
15 APH 22 APH/17-18//0015 2017-07-31 3 12 0 0 NULL1
16 APH 23 APH/17-18//0016 2017-07-31 3 13 0 0 NULL1
18 APH 33 APH/17-18//0017 2017-08-03 3 17 0 0 NULL1
19 APH 34 APH/17-18//0018 2017-07-22 3 17 0 0 NULL1
20 APH 35 APH/17-18//0019 2017-08-05 3 12 0 0 NULL1
21 APH 36 APH/17-18//0020 2017-08-08 3 17 0 0 NULL1
22 APH 37 APH/17-18//0021 2017-08-08 3 17 1 0 NULL1
23 APH 38 APH/17-18//0022 2017-08-08 3 17 0 0 NULL1
24 APH 39 APH/17-18//0023 2017-08-09 3 17 0 0 NULL1
25 APH 40 APH/17-18//0024 2017-08-09 3 17 0 0 NULL1
26 APH 42 APH/17-18//0025 2017-08-11 3 12 0 0 NULL1