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 `uploadfileold` ORDER BY `Bal3` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts UpF_id Accno Accn Cat1 Cat2 Cat3 Bal1 Bal2 Bal3 Descending Ascending 1 cat4 cat5 cat6 newk Balancedate Cusno Cusno1 cusno2 BranchCode AccountCode BranchName AccountType
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 8070
8070 2701120000170001 RAKELINA ENTERPRISE 1001 27011 697762.31 697762.31 697762.31 YES NULL 20260127 17000 170001 1120000170001 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 356
356 2701110000031621 ASANTE ATIEMO 6001 27011 2010010006122.N 453199.16 453199.16 453199.16 YES NULL 20260127 3162 31621 1110000031621 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 14249
14249 2701310000364751 DZIKUNU JOHN KWAKU 6001 2703 440027.09 440027.09 440027.09 YES NULL 20260127 36475 364751 1310000364751 13 1 Kotoku Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 8159
8159 2701120000210101 BLUE SKY PRODUCTS GH. LTD.2 1850 27011 321839.41 321839.41 321839.41 NULL 20260127 21010 210101 1120000210101 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 15170
15170 2701310000469701 PROSPER TORKPO 6001 2701 231108.59 231108.59 231108.59 YES NULL 20260127 46970 469701 1310000469701 13 1 Kotoku Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 8034
8034 2701120000163931 BOMARTS FARMS LTD 1850 27011 229370.77 229370.77 229370.77 NULL 20260127 16393 163931 1120000163931 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 8274
8274 2701120000229151 CITIZENS RURAL BANK LTD.- SUSPENSE 1000 27011 208794.55 208794.55 208794.55 NULL 20260127 22915 229151 1120000229151 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 15837
15837 2701410000385982 DUKE DUGBATEY 6550 270141 161935.48 161935.48 161935.48 YES NULL 20260127 38598 385982 1410000385982 14 1 Kuntunse Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 15051
15051 2701310000459981 ALHASSAN DOKONO UMAR FAROUCK AND MU 6001 2701 157107.81 157107.81 157107.81 YES NULL 20260127 45998 459981 1310000459981 13 1 Kotoku Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 17111
17111 2701410000476761 ARETHA OBENG TENKORANG 6001 270141 150718.73 150718.73 150718.73 YES NULL 20260127 47676 476761 1410000476761 14 1 Kuntunse Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 1993
1993 2701110000255921 BOTCHWAY EMMANUEL 6001 27011 135248.66 135248.66 135248.66 NULL 20260127 25592 255921 1110000255921 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 7790
7790 2701120000006561 AFFUM RAMSEYER 1001 27011 1001001003685.N 131953.59 131953.59 131953.59 YES NULL 20260127 656 6561 1120000006561 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 9964
9964 2701210000311511 ASILENU VINCENT 6001 27011 127873.33 127873.33 127873.33 YES NULL 20260127 31151 311511 1210000311511 12 1 Adeiso Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 8250
8250 2701120000225871 ODUROSE RICHARD KWARTENG 1002 27011 124659.99 124659.99 124659.99 YES NULL 20260127 22587 225871 1120000225871 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 3394
3394 2701110000343512 AFFUL ELIZABETH 6001 2702701 121430.76 121430.76 121430.76 YES NULL 20260127 34351 343512 1110000343512 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 895
895 2701110000145761 BORKETEY JOSEPH BORTEY 6001 27011 121212.39 121212.39 121212.39 YES NULL 20260127 14576 145761 1110000145761 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 3883
3883 2701110000367631 BROBBEY KWAME 6001 2701 108861.84 108861.84 108861.84 YES NULL 20260127 36763 367631 1110000367631 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 3441
3441 2701110000344891 AMPONSAH RUTH 6001 2702701 103366.17 103366.17 103366.17 NULL 20260127 34489 344891 1110000344891 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 3393
3393 2701110000343511 AFFUL ELIZABETH 6001 2702701 101779.08 101779.08 101779.08 NULL 20260127 34351 343511 1110000343511 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 9536
9536 2701120000472411 REDLIGHT BAR AND GRILL 1001 2701113 95678.00 95678.00 95678.00 YES NULL 20260127 47241 472411 1120000472411 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 1985
1985 2701110000254952 SOWODADEMU CSA SDD 6001 27011 92877.29 92877.29 92877.29 NO NULL 20260127 25495 254952 1110000254952 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 1757
1757 2701110000236791 AMANKWAH KWASI 6001 27011 91228.65 91228.65 91228.65 NULL 20260127 23679 236791 1110000236791 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 9115
9115 2701120000370471 BAMFO SETH KWADWO AMPONSAH 1001 2702701 88838.50 88838.50 88838.50 YES NULL 20260127 37047 370471 1120000370471 11 2 Nsawam Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 196
196 2701110000017351 AHWIRENG EMMANUEL AYISI 6001 27011 2010010006006.N 88080.17 88080.17 88080.17 YES NULL 20260127 1735 17351 1110000017351 11 1 Nsawam Savings
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 5386
5386 2701110000406621 SAMUEL DUKE ADU 6550 2701 86277.80 86277.80 86277.80 YES NULL 20260127 40662 406621 1110000406621 11 1 Nsawam Savings
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