Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: emp_leave_adjustment
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 (414 total, Query took 0.0723 seconds.)
SELECT * FROM `emp_leave_adjustment`

Full texts id location emp_id emp_leave_id leave_name old_leave adjustment_type adjustment status created_by created_date
1 AEH 2 1 Earn Leave 0.75 + 0.5 1 11 2018-07-10 09:48:02
2 AEH 2 599 Earn Leave 0.25 + 4.25 1 4 2018-10-09 06:41:31
3 AEH 7 23 Earn Leave -5.5 - 9.5 1 27 2018-10-10 11:26:40
4 AEH 5 128 Earn Leave 0 - 5.75 1 27 2018-10-10 11:27:37
5 AEH 8 21 Earn Leave 1.5 + 4.5 1 27 2018-10-10 11:29:00
6 AEH 9 20 Earn Leave 7.5 - 5 1 27 2018-10-10 11:29:00
7 AEH 11 65 Earn Leave 7.5 - 4.5 1 27 2018-10-10 11:30:49
8 AEH 12 432 Earn Leave 4 - 1 1 27 2018-10-10 11:30:49
9 AEH 13 384 Earn Leave 7.5 - 3 1 27 2018-10-10 11:32:14
10 AEH 24 5 Earn Leave 1.5 + 4.5 1 27 2018-10-10 11:32:14
11 AEH 34 32 Earn Leave 6.5 - 3 1 27 2018-10-10 11:38:24
12 AEH 41 217 Earn Leave 4 + 2.5 1 27 2018-10-10 11:38:24
13 AEH 127 176 Earn Leave 1.25 + 0.75 1 27 2018-10-10 11:38:24
14 AEH 133 95 Earn Leave 3.75 + 0.75 1 27 2018-10-10 11:38:24
15 AEH 137 99 Earn Leave 3.75 - 2.5 1 27 2018-10-10 11:38:24
16 VCT 43 436 Earn Leave 3.75 + 3.75 1 4 2018-10-12 05:20:19
17 AEH 30 3 Earn Leave 7.5 - 5 1 4 2018-10-12 05:22:04
18 AEH 31 4 Earn Leave 7.5 - 1 1 4 2018-10-12 05:22:04
19 AEH 62 6 Earn Leave 2 + 2.5 1 4 2018-10-12 05:23:25
20 AEH 63 7 Earn Leave 8 - 2.5 1 4 2018-10-12 05:23:25
21 AEH 109 9 Earn Leave 0 + 6.25 1 4 2018-10-12 05:24:49
22 AEH 56 12 Earn Leave 7.5 - 5 1 4 2018-10-12 05:37:31
23 AEH 57 14 Earn Leave 8.5 - 2.5 1 4 2018-10-12 05:37:31
24 AEH 58 13 Earn Leave 6.5 - 4 1 4 2018-10-12 05:37:31
25 AEH 102 15 Earn Leave 5.5 - 2 1 4 2018-10-12 05:39:14