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`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts UpF_id Accno Accn Cat1 Cat2 Cat3 Bal1 Bal2 Bal3 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` = 1
1 2701020000009381 ASAMOAH BARBARA KORAMA 1850 2702700 0.86 0.86 0.86 YES NULL 20260127 938 9381 1020000009381 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 2
2 2701020000009421 ABOAGYE EMELIA 1850 2702700 7.02 7.02 7.02 YES NULL 20260127 942 9421 1020000009421 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 3
3 2701020000009451 ANNAN ERNEST KWABENA 1850 2702700 2.65 2.65 2.65 YES NULL 20260127 945 9451 1020000009451 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 4
4 2701020000009471 YAKUBU HAMIDU 1850 27011 25.29 25.29 25.29 YES NULL 20260127 947 9471 1020000009471 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 5
5 2701020000009511 ARTHUR STELLA 1850 2702700 0.23 0.23 0.23 YES NULL 20260127 951 9511 1020000009511 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 6
6 2701020000009541 OSAE COMFORT 1850 2702700 6.09 6.09 6.09 YES NULL 20260127 954 9541 1020000009541 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 7
7 2701020000009651 HALLO FELICIA 1850 27011 0.96 0.96 0.96 YES NULL 20260127 965 9651 1020000009651 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 8
8 2701020000154531 MPRAH FELICIA 1850 2702700 0.31 0.31 0.31 YES NULL 20260127 15453 154531 1020000154531 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 9
9 2701020000155811 WUNYO CHRISTIAN YAO 1850 2702700 2.14 2.14 2.14 YES NULL 20260127 15581 155811 1020000155811 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 10
10 2701020000168821 OWUSU DIANA DARKOA 1850 2702700 5.53 5.53 5.53 YES NULL 20260127 16882 168821 1020000168821 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 11
11 2701020000219541 WORMADEY ISHMAEL 1850 2702700 0.15 0.15 0.15 YES NULL 20260127 21954 219541 1020000219541 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 12
12 2701020000225001 ESSEL ESTHER 1850 2702700 4.77 4.77 4.77 YES NULL 20260127 22500 225001 1020000225001 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 13
13 2701020000227341 ZAKARIA RAMAT 1850 2702700 4.07 4.07 4.07 YES NULL 20260127 22734 227341 1020000227341 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 14
14 2701020000227381 KUMI EMMANUEL OSEI 1850 2702700 6.70 6.70 6.70 YES NULL 20260127 22738 227381 1020000227381 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 15
15 2701020000253381 ADDO DYAN AYISIBEA 1850 2702700 -7.94 -7.94 -7.94 YES NULL 20260127 25338 253381 1020000253381 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 16
16 2701020000253691 OWUBA LORD MANSFIELD 1850 2702700 0.50 0.50 0.50 YES NULL 20260127 25369 253691 1020000253691 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 17
17 2701020000257991 KORANKYE STEPHEN 1850 2702700 0.60 0.60 0.60 YES NULL 20260127 25799 257991 1020000257991 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 18
18 2701020000260131 OFFEI EBENEZER 1850 2702700 0.90 0.90 0.90 YES NULL 20260127 26013 260131 1020000260131 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 19
19 2701020000262961 GORDOR FELICIA 1850 2702700 3.15 3.15 3.15 YES NULL 20260127 26296 262961 1020000262961 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 20
20 2701020000265111 TETTEH RUTH 1850 2702700 10001.92 10001.92 10001.92 YES NULL 20260127 26511 265111 1020000265111 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 21
21 2701020000279341 ADU STEPHEN 1850 27011 1444.91 1444.91 1444.91 YES NULL 20260127 27934 279341 1020000279341 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 22
22 2701020000280881 AIDOO SAMUEL 1850 2702700 84.62 84.62 84.62 YES NULL 20260127 28088 280881 1020000280881 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 23
23 2701020000283381 SANVI KOFI 1850 2702700 11.86 11.86 11.86 YES NULL 20260127 28338 283381 1020000283381 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 24
24 2701020000285001 WOTORTSI GORDON KENNETH 1850 2702700 5.10 5.10 5.10 YES NULL 20260127 28500 285001 1020000285001 10 2 Head Office Current
Edit Edit Copy Copy Delete Delete
DELETE FROM uploadfileold WHERE `uploadfileold`.`UpF_id` = 25
25 2701020000285651 BAYO STEPHEN 1850 2702700 856.04 856.04 856.04 YES NULL 20260127 28565 285651 1020000285651 10 2 Head Office Current
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