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 `sclientesdetalle`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts _recno FCH_CLIENTE FCH_TIPO FCH_AUTOINCREMENT FCH_ORIGEN FCH_DOCUMENTO FCH_NOTADEBITO FCH_MONTO FCH_FECHA FCH_FECHAPAGO FCH_DETALLE FCH_MAXVENTA FCH_MAXCREDITO FCH_MONTOPAGO FCH_DOCPAGO
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 1
1 E822811763 1 108 NULL 00005203 NULL 37831.85 2023-10-02 00:00:00 2023-12-13 00:00:00 NULL 37831.85 37831.85 37831.85 00000030
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 2
2 G200121807 1 131 NULL 00005818 NULL 2350080 2024-04-01 00:00:00 2023-10-11 00:00:00 NULL 2350080 2350080 2099647 00000009
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 3
3 J293889537 1 117 NULL 00005788 NULL 11910.79 2024-03-05 00:00:00 2024-01-27 00:00:00 NULL 36622.7 36622.7 18227.85 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 4
4 J294734677 1 15 NULL 00005404 NULL 3755.58 2023-11-16 00:00:00 NULL NULL 3755.58 3605.09 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 5
5 J295111347 1 128 NULL 00005212 NULL 15473.6 2023-12-06 00:00:00 2023-10-02 00:00:00 NULL 15473.6 15473.6 15473.6 00000001
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 6
6 J295449097 1 90 NULL 00005227 NULL 9972.95 2023-12-11 00:00:00 2024-01-19 00:00:00 NULL 354837.56 354837.56 8512.99 00000195
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 7
7 J297246010 1 32 NULL 00005428 NULL 4379.86 2023-11-16 00:00:00 NULL NULL 4379.86 4329.58 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 8
8 J297323031 1 69 NULL 00005681 NULL 92451.78 2024-02-07 00:00:00 2024-02-07 00:00:00 NULL 99914.15 98935.16 98847.54 00000350
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 9
9 J297518975 1 8 NULL 00005688 NULL 43847.38 2024-02-08 00:00:00 2024-01-27 00:00:00 NULL 49703.19 49703.19 25735.45 00000331
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 10
10 J297615415 1 47 NULL 00002299 NULL 63678.38 2024-04-09 00:00:00 2024-01-29 00:00:00 NULL 111670.97 111670.97 43863.63 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 11
11 J298365170 1 18 NULL 00005411 NULL 1380.99 2023-11-16 00:00:00 NULL NULL 1380.99 1380.99 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 12
12 J298469897 1 61 NULL 00002246 NULL 28420.4 2024-04-08 00:00:00 2024-01-22 00:00:00 NULL 62699.65 62699.65 50272.66 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 13
13 J298509793 1 102 NULL 00005563 NULL 64124.64 2023-12-12 00:00:00 2024-01-23 00:00:00 NULL 105093.16 105093.16 73496.34 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 14
14 J298553480 1 126 NULL 00002201 NULL 2179 2024-03-19 00:00:00 2024-01-22 00:00:00 NULL 18359.28 18359.28 18359.28 00000238
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 15
15 J299371661 1 113 NULL 00005784 NULL 15881.05 2024-03-05 00:00:00 2024-01-22 00:00:00 NULL 50945.44 50945.44 16257.14 00000244
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 16
16 J299452190 1 45 NULL 00005445 NULL 94243.2 2023-11-21 00:00:00 NULL NULL 94243.2 94243.2 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 17
17 J299892750 1 130 NULL 00005276 NULL 78499.63 2023-12-11 00:00:00 2023-12-13 00:00:00 NULL 78499.63 78499.63 78499.63 00000041
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 18
18 J303429181 1 39 NULL 00002258 NULL 14400 2024-04-08 00:00:00 2024-01-29 00:00:00 NULL 1093696.2 1093696.2 335000 00000342
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 19
19 J305429600 1 64 NULL 00005792 NULL 278214.86 2024-03-06 00:00:00 2024-01-27 00:00:00 NULL 458922.88 458922.88 434697.03 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 20
20 J305920699 1 74 NULL 00002254 NULL 76802.09 2024-04-08 00:00:00 2024-01-27 00:00:00 NULL 102865.32 102865.32 102865.32 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 21
21 J306282440 1 75 NULL 00001911 NULL 12644.88 2023-12-18 00:00:00 2024-02-15 00:00:00 NULL 52740.82 52238.56 34033.22 00000364
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 22
22 J306456597 1 44 NULL 00002280 NULL 9226.13 2024-04-09 00:00:00 2024-01-26 00:00:00 NULL 36266.48 36266.48 29797.2 00000316
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 23
23 J306928634 1 20 NULL 00002080 NULL 9265.63 2024-02-19 00:00:00 2024-01-19 00:00:00 NULL 9265.63 9265.63 5165.61 00000212
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 24
24 J307067217 1 7 NULL 00001986 NULL 3248.91 2024-02-02 00:00:00 2024-01-18 00:00:00 NULL 3895.1 3895.1 3895.1 00000178
Edit Edit Copy Copy Delete Delete
DELETE FROM sclientesdetalle WHERE `sclientesdetalle`.`_recno` = 25
25 J308683639 1 104 NULL 00005663 NULL 50729.28 2024-02-02 00:00:00 2024-01-16 00:00:00 NULL 57019.01 57019.01 25332.45 00000154
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