Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »Table: tbl_tmp_stock_items
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
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 (126 total, Query took 0.0003 seconds.)
SELECT * FROM `tbl_tmp_stock_items`
Full texts idproduct_idItemquantitydatestatus
1 3 Coffee Water (Bottle) 152.000 2023-09-30 1
2 5 IceCubes 18.000 2023-09-30 1
3 22 Aeropress Filters 0.600 2023-09-30 1
4 23 Chemix Filters 0.060 2023-09-30 1
38 32 Lemon Powder 2.000 2023-09-30 1
6 583 Glove 0.001 2023-09-30 1
7 581 Imported Beans 0.800 2023-09-30 1
8 580 Lindt Dark Chocolate 1.200 2023-09-30 1
9 579 Lindt Milk Chocolate 0.250 2023-09-30 1
10 573 Raspberry Frozen 0.500 2023-09-30 1
11 128 S&S Berg White Tea (Tin) 0.120 2023-09-30 1
12 421 S&S Berries Rooibos (Tin) 0.133 2023-09-30 1
13 489 S&S Black Mint Tea (Tin) 0.036 2023-09-30 1
14 422 S&S Berries Herbal (Tin) 0.088 2023-09-30 1
15 418 S&S Chamomile Herbal (Tin) 0.008 2023-09-30 1
16 417 S&S Ginger Lemon (Tin) 0.163 2023-09-30 1
17 503 S&S Green Tea Sencha (Tin) 0.004 2023-09-30 1
18 420 S&S Mango Passion (Tin) 0.003 2023-09-30 1
19 494 S&S Mediterranean (Tin) 0.008 2023-09-30 1
20 380 S&S Mint (Tin) 0.100 2023-09-30 1
21 295 S&S Pepperment Jasnine Tea (Tin) 0.182 2023-09-30 1
22 486 S&S Vanilla White Tea (Tin) 0.060 2023-09-30 1
23 29 V60 Filters 0.144 2023-09-30 1
24 42 Soda Gun Charger 0.800 2023-09-30 1
25 65 Whipped cream Chargers 0.190 2023-09-30 1