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_online_fixed_fee_new`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts fixedfee_id std_id sfee_id pac_id sub_fee is_mandatory fixed_fee due_amount paid concession total_paid yr_id order_by delete_status added_by added_at modified_by modify_at
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8192
8192 100 Fee1 0 ACADEMIC FEE 0 8500 0 8500 51000 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8193
8193 100 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8194
8194 100 Transport 0 TRANSPORT FEE 0 7250 0 14000 6750 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8195
8195 102 Fee1 0 ACADEMIC FEE 0 59500 0 59500 0 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8196
8196 102 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8197
8197 102 Transport 0 TRANSPORT FEE 0 18000 0 18000 0 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8198
8198 103 Transport 0 TRANSPORT FEE 0 0 0 0 0 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8199
8199 104 Fee1 0 ACADEMIC FEE 0 59500 0 59500 0 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8200
8200 104 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8201
8201 104 Transport 0 TRANSPORT FEE 0 16800 0 16800 0 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8202
8202 105 Fee1 0 ACADEMIC FEE 0 56500 0 56500 3000 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8203
8203 105 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8204
8204 105 Transport 0 TRANSPORT FEE 0 18000 0 18000 0 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8205
8205 106 Fee1 0 ACADEMIC FEE 0 29800 0 29800 0 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8206
8206 106 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8207
8207 107 Fee1 0 ACADEMIC FEE 0 59500 0 59500 0 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8208
8208 107 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8209
8209 107 Transport 0 TRANSPORT FEE 0 14000 0 14000 0 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8210
8210 109 Fee1 0 ACADEMIC FEE 0 29800 0 29800 0 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8211
8211 109 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8212
8212 11 Fee1 0 ACADEMIC FEE 0 59000 0 59000 0 0 16 50 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8213
8213 11 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 54 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8214
8214 11 Transport 0 TRANSPORT FEE 0 6000 0 12000 6000 0 16 31 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8215
8215 110 Fee1 0 ACADEMIC FEE 0 29800 0 29800 0 0 16 57 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_online_fixed_fee_new WHERE `z_mobile_online_fixed_fee_new`.`fixedfee_id` = 8216
8216 110 Fee5 0 MISCELLANEOUS FEE 0 3000 0 3000 0 0 16 61 0 0 2024-02-23 17:48:02 0 2024-02-23 17:48:02
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