Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: erp_data »Table: inventory_table
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 (8224 total, Query took 0.0006 seconds.) [DBProductName: [BLOB - 21 B]... - [BLOB - 42 B]...]
SELECT * FROM `inventory_table` ORDER BY `DBProductName`  ASC 
Full texts DBIDDBProductName Ascending Descending 1DBBarcodeDBSKUDBBrandDBCategoryDBUnitDBPrice1DBPrice2DBPrice3DBCostDBThresholdDBStatusDBOnlinePriceDBOnlineDiscountDBOnlineDescriptionDBDateDBQuantityDBBranchNumTSUTSUMECGJFFMAC
7385 ENVY APPLES PER PC L 1688955759 ENVYM US ENVY APPLE APPLE 1 85.00 85.00 85.00 85.00 1.00 ACTIVE 0.00 0.00 2023-07-10 -64.00 3
7462 KATANA JAPAN TECH INDUSTRIAL CIRCULAR SAW 7-1/4" ... 1691977873 KTNCS5806B KATANA POWER TOOLS 0 2800.00 1799.00 1799.00 0.00 0.00 ACTIVE 0.00 0.00 2023-08-14 -4.00 1 0.00 0.00 0.00 -4.00
7442 KATANA JAPAN TECH INDUSTRIAL REFLECTORIZED VEST N... 1690945742 KTNRVG KATANA HAND TOOLS 0 60.00 0.00 0.00 0.00 0.00 ACTIVE 0.00 0.00 2023-08-02 -16.00 1 -16.00
7422 NORDIC RED CHERRIES KG 1689820994 NORDICRED NORDIC CHERRIES 1 880.00 880.00 880.00 880.00 2.00 ACTIVE 0.00 0.00 2023-07-20 5.00 3
8094 TIKOY 1737609249 TIKOY PH FOOD 1 99.00 99.00 99.00 1.00 1.00 ACTIVE 0.00 0.00 2025-01-23 0.00 3
7982 WASHINGTON RED CHERRIES(500G) 1719370674 500GCHERRIES WASHINGTON CHERRIES 1 600.00 600.00 600.00 1.00 1.00 ACTIVE 0.00 0.00 2024-06-26 -66.50 3
6527 (HPK82001) CABLE STRIPPING KNIFE 6925582148947 HPK82001 INGCO HAND TOOLS 180.00 180.00 180.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-31 -3.00 1 0.00 0.00 0.00 0.00
6528 (HPK82101) CABLE STRIPPING KNIFE 6925582148886 HPK82101 INGCO HAND TOOLS 0 170.00 200.00 300.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-31 -1.00 1 0.00 0.00 0.00 -1.00
7353 1 BAGGER MIXER W/ 7.5HP ENGINE 1687241089 1BMW7.5L N/A POWER TOOLS 0 50000.00 60000.00 80000.00 0.00 1.00 ACTIVE 0.00 0.00 2023-06-20 0.00 1 -1.00
7806 1 BAGGER MIXER W/ LUSQI 5.0HP ENGINE 1705649307 1BMW5.0HP LUSQI POWER TOOLS 1 50000.00 45000.00 35000.00 0.00 0.00 ACTIVE 0.00 0.00 2024-01-19 0.00 1 -1.00
8079 1 BOX APPLE 1734391168 BXAPPLE CH APPLE 1 999.00 999.00 999.00 1.00 1.00 ACTIVE 0.00 0.00 2024-12-17 -1.00 3
7770 1 BOX PEAR 1703130007 PEAR PEAR PEAR PEAR 1000.00 1000.00 1000.00 1.00 1.00 ACTIVE 0.00 0.00 2023-12-21 -8.00 3
8082 1 BOX POMEGRANATE 1734678062 BOXPOME TUNISIAN POMEGRANATE 1 999.00 999.00 999.00 1.00 1.00 ACTIVE 0.00 0.00 2024-12-20 7.00 3
5652 10 PCS HEX KEY RING 1657613026000 10HKR N/A N/A 0.00 0.00 0.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-27 0.00 1 0 0 0 0
2388 10 PCS HEX KEY RING 1657613026000 10HKR N/A N/A 0.00 0.00 0.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-24 0.00 2 0 0 0 0
7842 105PCS MINI ELECTRIC DRILL GRINDER ROTARY TOOL GRI... 1709697373 105MEDGRTGPTA N/A ACCESORIES 0 350.00 200.00 0.00 112.00 0.00 ACTIVE 0.00 0.00 2024-03-06 -1.00 1 0.00 0.00 0.00 -1.00
6593 10M POWER SPRAYER HOSE WITH FITTINGS 10MPSHWP 1625277999000 10MPSHWP N/A N/A 500.00 500.00 500.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-31 0.00 1 0 0 0 0
5534 10M PRESSURE WASHER HOSE WITH FITTINGS 10MPWHWF 1647916281000 10MPWHWF N/A N/A 600.00 600.00 600.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-27 -12.00 1 0 0 0 -12.00
2270 10M PRESSURE WASHER HOSE WITH FITTINGS 10MPWHWF 1647916281000 10MPWHWF N/A N/A 600.00 600.00 600.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-24 0.00 2 0 0 0 0
7010 12 PCS TAP AND DIE SET METRIC HAND THREADING PLUGS... 1675838239 12PCSTADSMHTPSTWR N/A HAND TOOLS 450.00 450.00 450.00 280.00 4.00 ACTIVE 0.00 0.00 2023-02-08 -4.00 1 -5.00
6952 13 IN 1 RATCHET SCREWDRIVER SET 6925582122374 AKISD1208 INGCO SCREWDRIVER 260.00 260.00 260.00 100.00 100.00 ACTIVE 0.00 0.00 2022-12-13 95.00 2 0 0 0 0
7014 150KG RECHARGEABLE HIGH ACCURACY DIGITAL PLATFORM ... 1675841546 150RHADPSD N/A HAND TOOLS 2500.00 2500.00 2500.00 1498.50 4.00 ACTIVE 0.00 0.00 2023-02-08 -2.00 1 -3.00
6732 16 IN 1 POCKET TOOLS FOR MOTORCYCLE AND BICYCLE 16... 1627547026000 16IN1PT N/A N/A 0.00 0.00 0.00 0.00 0.00 ACTIVE 0.00 0.00 2022-10-31 -37.00 1 0 0 0 -24.00
6906 16 PC METAL CONCRETE WOOD DRILL BITS 6925582147353 AKDL11601 INGCO DRILL BITS 460.00 460.00 460.00 460.00 100.00 ACTIVE 0.00 0.00 2022-11-08 94.00 2 0 0 0 0
6941 16 PCS DRILL BITS AND SCREWDRIVER BITS SET 6928073713372 AKSDB9165 INGCO DRILL BITS 240.00 240.00 240.00 100.00 100.00 ACTIVE 0.00 0.00 2022-11-28 99.00 2 0 0 0 0