Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: sik »Table: detailpesan
Page-related settingsClick 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - 24 (6344 total, Query took 0.0011 seconds.)
SELECT * FROM `detailpesan`
no_fakturkode_brngkode_satjumlahh_pesansubtotaldisbesardistotalno_batchjumlah2kadaluarsa
PB200106001 A000000158 - 30 17050 511500 0 0 511500 30 0000-00-00
PB200106001 A000000206 - 30 24750 742500 0 0 742500 30 0000-00-00
CPB191215435 A000000103 - 300 1430 429000 0 0 429000 300 0000-00-00
CPB191215435 A000000238 - 28 52525 1470700 0 0 1470700 28 0000-00-00
CPB191215435 A000000229 - 10 42075 420750 0 0 420750 10 0000-00-00
CPB191215435 A000000241 - 28 50875 1424500 0 0 1424500 28 0000-00-00
CPB191215435 A000000083 - 100 4180 418000 0 0 418000 100 0000-00-00
CPB191215435 A000000242 - 21 31900 669900 0 0 669900 21 0000-00-00
PB200108001 A000000600 - 20 74000 1480000 0 0 1480000 20 0000-00-00
PB200108002 A000000299 - 1 4850000 4850000 0 0 4850000 1 0000-00-00
PB200108003 A000000280 - 100 6600 660000 0 0 660000 100 0000-00-00
PB200108003 A000000586 - 2 393000 786000 0 0 786000 2 0000-00-00
PB200108003 A000000582 - 1 393000 393000 0 0 393000 1 0000-00-00
PB200108003 A000000588 - 1 393000 393000 0 0 393000 1 0000-00-00
PB200108003 A000000574 - 1 393000 393000 0 0 393000 1 0000-00-00
PB200108003 A000000578 - 1 393000 393000 0 0 393000 1 0000-00-00
PB200108003 A000000583 - 1 393000 393000 0 0 393000 1 0000-00-00
PB200108004 A000000082 - 100 3403 340300 0 0 340300 100 0000-00-00
PB200108004 A000000220 - 96 17818 1710528 0 0 1710528 96 0000-00-00
PB200108005 A000000082 - 100 3403 340300 0 0 340300 100 0000-00-00
PB200108005 A000000052 - 300 2363 708900 0 0 708900 300 0000-00-00
PB200108005 A000000134 - 300 2941 882300 0 0 882300 300 0000-00-00
PB200108005 A000000231 - 72 18329 1319688 0 0 1319688 72 0000-00-00
PB200109001 A000000241 - 22 50875 1119250 0 0 1119250 9TS1106 22 2022-05-00
PB200109001 A000000160 - 11 33687 370557 0 0 370557 9CN1112 11 2021-10-00