Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: chief »Table: warehousepurchased
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.

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
Showing rows 0 - 24 (6999 total, Query took 0.0027 seconds.)
SELECT * FROM `warehousepurchased`
Full texts idinvoiceitems_amountgstdelivery_chargestotal_costreturn_costpayablepaidbalancedemand_supplier_idpurchased_supplier_idpayment_method_idLogopost_datepost_timebill_datepaid_date
1 1 11555 0 0.00 11555.00 0.00 11555 11555 0 65 65 2 [BLOB - 11 B] 2024-09-30 14:44:27 2024-09-29 2024-09-29
2 2 87713 0 0.00 87713.00 0.00 87713 87713 0 65 65 2 [BLOB - 11 B] 2024-09-30 16:24:48 2024-09-29 2024-09-29
3 3 48868 0 0.00 48868.00 0.00 48868 48868 0 65 65 2 [BLOB - 11 B] 2024-09-30 16:49:59 2024-09-29 2024-09-29
4 4 3400 0 0.00 3400.00 0.00 3400 3400 0 65 65 2 [BLOB - 11 B] 2024-09-30 16:54:30 2024-09-29 2024-09-29
5 5 181500 0 0.00 181500.00 0.00 181500 181500 0 4 4 2 [BLOB - 11 B] 2024-09-30 17:23:37 2024-09-29 2024-09-29
6 6 409637 73735 0.00 483372.00 0.00 483372 0 483372 72 72 4 [BLOB - 11 B] 2024-09-30 17:30:28 2024-09-29 2024-09-29
7 7 2540 0 0.00 2540.00 0.00 2540 2540 0 81 72 2 [BLOB - 11 B] 2024-09-30 18:19:56 2024-09-29 2024-09-29
8 8 43430 0 0.00 43430.00 0.00 43430 43430 0 55 22 2 [BLOB - 11 B] 2024-09-30 19:02:04 2024-09-29 2024-09-29
9 9 5915 0 0.00 5915.00 0.00 5915 5915 0 66 66 2 [BLOB - 11 B] 2024-09-30 19:03:35 2024-09-29 2024-09-29
10 10 9100 0 0.00 9100.00 0.00 9100 9100 0 61 61 2 [BLOB - 12 B] 2024-09-30 19:21:16 2024-09-29 2024-09-29
11 11 5830 0 0.00 5830.00 0.00 5830 5830 0 62 62 2 [BLOB - 12 B] 2024-09-30 19:22:23 2024-09-29 2024-09-29
12 12 2640 0 0.00 2640.00 0.00 2640 2640 0 62 62 2 [BLOB - 12 B] 2024-09-30 19:23:36 2024-09-29 2024-09-29
13 13 129300 0 0.00 129300.00 0.00 129300 129300 0 59 59 2 [BLOB - 12 B] 2024-09-30 19:24:36 2024-09-29 2024-09-29
14 14 10810 0 0.00 10810.00 0.00 10810 10810 0 60 60 2 [BLOB - 12 B] 2024-09-30 19:25:58 2024-09-29 2024-09-29
15 15 21000 0 0.00 21000.00 0.00 21000 21000 0 66 66 2 [BLOB - 12 B] 2024-09-30 19:27:34 2024-09-29 2024-09-29
16 16 34240 0 0.00 34240.00 0.00 34240 34240 0 56 56 2 [BLOB - 12 B] 2024-09-30 19:29:28 2024-09-29 2024-09-29
17 17 11517 0 0.00 11517.00 0.00 11517 11517 0 48 48 2 [BLOB - 12 B] 2024-09-30 19:30:47 2024-09-29 2024-09-29
18 18 2000 0 0.00 2000.00 0.00 2000 2000 0 66 66 2 [BLOB - 12 B] 2024-09-30 19:32:05 2024-09-29 2024-09-29
19 19 840 0 0.00 840.00 0.00 840 840 0 66 66 2 [BLOB - 12 B] 2024-09-30 19:33:14 2024-09-29 2024-09-29
20 20 6490 0 0.00 6490.00 0.00 6490 6490 0 58 58 2 [BLOB - 12 B] 2024-09-30 19:37:29 2024-09-29 2024-09-29
21 21 78900 0 0.00 78900.00 0.00 78900 78900 0 63 63 2 [BLOB - 12 B] 2024-09-30 19:40:05 2024-09-29 2024-09-29
22 22 24680 0 0.00 24680.00 0.00 24680 24680 0 52 52 2 [BLOB - 12 B] 2024-09-30 19:41:43 2024-09-29 2024-09-29
23 23 27012 0 0.00 27012.00 0.00 27012 27012 0 51 51 2 [BLOB - 12 B] 2024-09-30 19:46:41 2024-09-29 2024-09-29
24 24 68360 0 0.00 68360.00 0.00 68360 68360 0 92 92 2 [BLOB - 12 B] 2024-09-30 19:51:52 2024-09-29 2024-09-29
25 25 39600 0 0.00 39600.00 0.00 39600 39600 0 34 34 2 [BLOB - 12 B] 2024-09-30 19:53:55 2024-09-29 2024-09-29