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 `stranscuentas`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts _recno FE_CODE FE_CODECUENTA FE_BANCOORIGEN FE_TIPOOPERACION FE_TIPOTRANSACCION FE_ORIGEN FE_VISIBLE FE_OPERACIONAUTOINC FE_VENTAAUTOINCREMENT FE_POSARRAYVENTA FE_DOCUMENTO FE_MONTO FE_MONTOIMPUESTO FE_MONTOCOMISION FE_FECHA FE_FECHAMOVIMIENTO FE_STATUS FE_DIFERIDO FE_CODECLIENTE FE_NOLINEA BASE_AUTOINCREMENT FE_AUXILIAR FE_CTOCOSTO FE_MTOBASE FE_DESCRIPCIONCOMPROBANTE FE_MTOEFECTIVO FE_ESDEBITOBANCARIO FE_ESNOTA FE_DETALLEMOV FE_CODEPAGO
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 1
1 1 1101020003 0191-0106-1921-0002-0338 1 0 NULL 1 8 NULL NULL 00000002 -61.97 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 1 NULL NULL NULL TM - PEDRO LOPEZ VIATICOS CCS 61.97 NULL 1 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 2
2 2 7101010010 0191-0106-1921-0002-0338 1 0 NULL 1 8 NULL NULL 00000002 61.97 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 2 NULL NULL NULL TM - PEDRO LOPEZ VIATICOS CCS 61.97 NULL 1 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 3
3 3 1101020003 0191-0106-1921-0002-0338 1 0 NULL 1 7 NULL NULL 021002 -3098.7 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 3 NULL NULL 0 TM - PEDRO LOPEZ VIATICOS CCS 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 4
4 4 7101010010 0191-0106-1921-0002-0338 1 0 NULL 1 7 NULL NULL 021002 61.97 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 4 NULL NULL 0 TM - PEDRO LOPEZ VIATICOS CCS 0 1 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 5
5 5 1102030003 0191-0106-1921-0002-0338 1 0 NULL 1 7 NULL NULL 021002 3098.7 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 2 5 NULL NULL 0 TM - PEDRO LOPEZ VIATICOS CCS 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 6
6 6 1101020003 0191-0106-1921-0002-0338 1 0 NULL 1 7 NULL NULL 021002 -61.97 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 3 6 NULL NULL 0 IGTF 021002 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 7
7 7 1101020003 0191-0106-1921-0002-0338 1 0 NULL 1 13 NULL NULL 00000004 -2065.8 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 7 NULL NULL NULL XOUBA CONTRATISTA 2065.8 NULL 1 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 8
8 8 7101010010 0191-0106-1921-0002-0338 1 0 NULL 1 13 NULL NULL 00000004 2065.8 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 8 NULL NULL NULL XOUBA CONTRATISTA 2065.8 NULL 1 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 9
9 9 1101020003 0191-0106-1921-0002-0338 1 0 NULL 1 12 NULL NULL 102355 -103290 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 9 NULL NULL 0 XOUBA CONTRATISTA 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 10
10 10 7101010010 0191-0106-1921-0002-0338 1 0 NULL 1 12 NULL NULL 102355 2065.8 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 10 NULL NULL 0 XOUBA CONTRATISTA 0 1 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 11
11 11 1102020002 0191-0106-1921-0002-0338 1 0 NULL 1 12 NULL NULL 102355 103290 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 2 11 NULL 01001 0 XOUBA CONTRATISTA 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 12
12 12 1101020003 0191-0106-1921-0002-0338 1 0 NULL 1 12 NULL NULL 102355 -2065.8 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 3 12 NULL 01001 0 IGTF 102355 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 13
13 13 NULL 0191-0106-1921-0002-0338 0 1 0 0 21 0 0 152027 15473.6 0 0 1899-12-30 2023-10-02 0 0 J295111347 0 13 NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 14
14 14 1101020003 0191-0106-1921-0002-0338 2 0 NULL 0 21 NULL NULL 152027 15473.6 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 14 NULL NULL 0 VIVERES EL FUTURO, C.A FAC:00005212 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 15
15 15 1102010001 0191-0106-1921-0002-0338 2 0 NULL 0 21 NULL NULL 152027 -15473.6 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 15 295111347 NULL 0 VIVERES EL FUTURO, C.A FAC:00005212 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 16
16 16 1101020003 0191-0106-1921-0002-0338 2 0 NULL 1 22 NULL NULL 152027 15491.43 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 16 NULL NULL 0 VIVERES EL FUTURO, C.A FAC:00005212 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 17
17 17 1102010001 0191-0106-1921-0002-0338 2 0 NULL 1 22 NULL NULL 152027 -15473.4 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 17 295111347 NULL 0 VIVERES EL FUTURO, C.A FAC:00005212 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 18
18 18 7101010001 0191-0106-1921-0002-0338 2 0 NULL 1 22 NULL NULL 152027 -18.03 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 2 18 NULL NULL 0 VIVERES EL FUTURO, C.A FAC:00005212 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 19
19 19 NULL 0191-0106-1921-0002-0338 0 1 0 1 22 0 0 152027 15491.43 0 0 1899-12-30 2023-10-02 0 0 J295111347 0 19 NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 20
20 20 NULL 0191-0106-1921-0002-0338 0 1 0 0 23 0 0 545668 37184.4 0 0 1899-12-30 2023-10-02 0 0 J403729948 0 20 NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 21
21 21 1101020003 0191-0106-1921-0002-0338 2 0 NULL 0 23 NULL NULL 545668 37184.4 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 21 NULL NULL 0 SUN MARKET, C.A PAGO FAC:00005185 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 22
22 22 1102010001 0191-0106-1921-0002-0338 2 0 NULL 0 23 NULL NULL 545668 -37184.4 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 22 403729948 NULL 0 SUN MARKET, C.A PAGO FAC:00005185 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 23
23 23 1101020003 0191-0106-1921-0002-0338 2 0 NULL 1 24 NULL NULL 545668 37179.43 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 0 23 NULL NULL 0 SUN MARKET, C.A PAGO FAC:00005185 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 24
24 24 1102010001 0191-0106-1921-0002-0338 2 0 NULL 1 24 NULL NULL 545668 -37184.4 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 1 24 403729948 NULL 0 SUN MARKET, C.A PAGO FAC:00005185 0 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stranscuentas WHERE `stranscuentas`.`_recno` = 25
25 25 7101010001 0191-0106-1921-0002-0338 2 0 NULL 1 24 NULL NULL 545668 4.97 NULL NULL 2023-10-02 2023-10-02 0 0 NULL 2 25 NULL NULL 0 SUN MARKET, C.A PAGO FAC:00005185 0 0 NULL NULL NULL
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