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 `z_mobile_fee_transcations`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ofee_tid unique_id reference_id transactionId school_code amount dop tran_status agreegator fund_trans_status fund_trans_date_time fund_trans_by fee_desc update_status yr_id added_at added_by
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 1
1 AISKGL4649 ID991160BVzWPWP9d5WH ID991160BVzWPWP9d5WH AISKGL 1.00 2021-06-09 11:15:07 1 0 0 NULL NULL 0 15 2021-06-15 11:27:26 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 2
2 AISKGL4649 ID991160BKgJKfp8VyXk ID991160BKgJKfp8VyXk AISKGL 1.00 2021-06-09 11:17:40 1 0 0 NULL NULL 0 15 2021-06-15 11:27:23 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 3
3 AISKGL4649 ID991160BLzxpGmIk1tW ID991160BLzxpGmIk1tW AISKGL 1.00 2021-06-09 11:27:56 1 0 0 NULL NULL 0 15 2021-06-15 11:27:18 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 4
4 AISKGL4649 IC991161BUz6gYvMZ6Zs IC991161BUz6gYvMZ6Zs AISKGL 1.00 2021-06-10 07:47:44 1 0 0 NULL NULL 0 15 2021-06-15 11:27:17 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 5
5 AISKGL4649 AX011161000004164745 AX011161000004164745 AISKGL 1.00 2021-06-10 22:24:51 1 0 0 NULL NULL 0 15 2021-06-15 11:27:15 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 6
6 AISKGL1 AX011164000004177094 AX011164000004177094 AISKGL 2.00 2021-06-13 19:32:05 1 0 0 NULL NULL 0 15 2021-06-15 20:27:21 1
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 7
7 AISKGL1 SB991166BoKqaf6bkjeS SB991166BoKqaf6bkjeS AISKGL 1.00 2021-06-15 20:43:59 1 0 0 NULL NULL 0 15 2021-06-15 20:43:59 1
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 19
19 AISKGL432 ID991166Byai5hG1hLNM ID991166Byai5hG1hLNM AISKGL 500.00 2021-06-16 11:13:39 1 0 0 NULL NULL 0 15 2021-06-16 12:02:00 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 32
32 Aiskgl4649 ID991166Bh8fTRSKi0cy ID991166Bh8fTRSKi0cy Aiskgl 1.00 2021-06-16 05:35:27 1 0 0 NULL NULL 0 15 2021-06-16 05:35:27 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 90
90 Aiskgl2 IC991167Ba0xgNm0ET79 IC991167Ba0xgNm0ET79 Aiskgl 2.00 2021-06-16 15:00:11 1 0 0 NULL NULL 0 15 2021-06-16 15:00:11 2
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 111
111 Aiskgl1 IC991166BfaqkELYMBEI IC991166BfaqkELYMBEI Aiskgl 1.00 2021-06-16 17:36:04 1 0 0 NULL NULL 0 15 2021-06-16 17:36:04 1
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 137
137 Aiskgl1 IC991167BJ6HvBLuzMDj IC991167BJ6HvBLuzMDj Aiskgl 1.00 2021-06-16 23:18:47 1 0 0 NULL NULL 0 15 2021-06-16 23:18:47 1
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 138
138 Aiskgl1 IC991167B2mmNUEtMC4g IC991167B2mmNUEtMC4g Aiskgl 3.00 2021-06-17 00:19:25 1 0 0 NULL NULL 0 15 2021-06-17 00:19:25 1
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 139
139 AISKGL1 AX011167000004186232 AX011167000004186232 AISKGL 1.00 2021-06-17 01:20:42 1 0 0 NULL NULL 0 15 2021-06-17 01:20:42 1
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 140
140 Aiskgl4 IC991167Bc8pavSZjljT IC991167Bc8pavSZjljT Aiskgl 1.00 2021-06-17 03:15:34 1 0 0 NULL NULL 0 15 2021-06-17 03:15:34 4
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 141
141 AISKGL432 TID1623924546597 TID1623924546597 AISKGL 501.00 2021-06-17 00:06:00 1 3 0 NULL NULL test 0 15 2021-06-17 15:06:29 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 142
142 AISKGL432 TID1623924737846 TID1623924737846 AISKGL 51.00 2021-06-17 00:06:00 0 3 0 NULL NULL test 0 15 2021-06-17 15:06:00 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 143
143 Aiskgl4649 ID991168Br4iTVnrMEos ID991168Br4iTVnrMEos Aiskgl 5.00 2021-06-17 15:59:51 1 0 0 NULL NULL 0 15 2021-06-17 15:59:51 4649
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 144
144 AISKGL432 AX011168000004189204 AX011168000004189204 AISKGL 1.00 2021-06-17 20:11:58 1 0 0 NULL NULL 0 15 2021-06-17 20:11:58 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 145
145 AISKGL432 AX011168000004189216 AX011168000004189216 AISKGL 1.00 2021-06-17 20:12:01 1 0 0 NULL NULL 0 15 2021-06-17 20:12:01 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 146
146 AISKGL432 AX011168000004189238 AX011168000004189238 AISKGL 1.00 2021-06-17 20:27:34 1 0 0 NULL NULL 0 15 2021-06-17 20:27:34 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 147
147 AISKGL432 AX011168000004189224 AX011168000004189224 AISKGL 1.00 2021-06-17 20:29:53 1 0 0 NULL NULL 0 15 2021-06-17 20:29:53 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 148
148 Aiskgl5 IC991168BGGYwq9qPDPS IC991168BGGYwq9qPDPS Aiskgl 5.00 2021-06-17 22:07:54 1 0 0 NULL NULL 0 15 2021-06-17 22:07:54 5
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 149
149 AISKGL432 AX011168000004189247 AX011168000004189247 AISKGL 1.00 2021-06-17 22:23:24 1 0 0 NULL NULL 0 15 2021-06-17 22:23:24 432
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations WHERE `z_mobile_fee_transcations`.`ofee_tid` = 150
150 aiskgl1 AX011168000004188867 AX011168000004188867 aiskgl 1.00 2021-06-17 23:12:34 1 0 0 NULL NULL 0 15 2021-06-17 23:12:34 1
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