Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »Table: tbl_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
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 (890 total, Query took 0.0078 seconds.) [price: 0... - 0...]
SELECT * FROM `tbl_items` ORDER BY `price` ASC 
Full texts idcategory_idMiniMaxsuppliertitleupdated_Stockbrand_idunitprice Ascending Descending 1quantitypost_datepost_timelast_updatedstatus
85 9 2 4 Ibrahim Plastic Store Mask 0.00 1 6 0 0.00 2021-08-14 04:10:17 1628939417 1
115 13 1 1 Purchaser MRD Roll 1.00 3 3 0 0.00 2021-08-14 04:10:17 1628939417 1
60 14 0 0 Purchaser Parking Maintenance 0.00 9 4 0 0.00 2021-08-14 04:10:17 1628939417 1
38 9 1 2 Ibrahim Plastic Store Cling Film 0.00 2 3 0 0.00 2021-08-14 04:10:17 1628939417 1
18 9 3 5 Ibrahim Plastic Store Jali 9.00 1 3 0 0.00 2021-08-14 04:10:17 1628939417 1
114 13 1 2 Purchaser MRD Roll 10013.00 1 3 0 0.00 2021-08-14 04:10:17 1628939417 1
118 13 0 0 Purchaser Medicine 6.00 6 4 0 0.00 2021-08-14 04:10:17 1628939417 1
41 9 1 2 Ibrahim Plastic Store Fork 0.00 1 6 0 790.00 2021-08-14 04:10:17 1628939417 1
53 14 0 0 Purchaser Maintenance Main Section 107.00 9 4 0 0.00 2021-08-14 04:10:17 1628939417 1
28 9 50 100 Ibrahim Plastic Store Transparent glass 12oz 0.00 2 3 0 0.00 2021-08-14 04:10:17 1628939417 1
82 9 2 4 Ibrahim Plastic Store Sponge 8.00 1 3 0 0.00 2021-08-14 04:10:17 1628939417 1
25 9 50 100 Ibrahim Plastic Store Coffee Cups 8oz 0.00 2 3 0 0.00 2021-08-14 04:10:17 1628939417 1
101 5 0 0 Adil_Vegetables Vegetables 155.00 3 30 0 0.00 2021-08-14 04:10:17 1628939417 1
40 9 1 2 Ibrahim Plastic Store Spoon 0.00 1 6 0 0.00 2021-08-14 04:10:17 1628939417 1
108 12 0 0 Purchaser Crockery (Main Section) 18.00 9 4 0 0.00 2021-08-14 04:10:17 1628939417 1
111 13 0 0 Purchaser Body Spray 0.00 6 3 0 0.00 2021-08-14 04:10:17 1628939417 1
125 7 0 0 Wajid_Gas Gas Cylinder (Small) 150.00 1 3 0 0.00 2021-08-14 04:10:17 1628939417 1
72 5 0 0 Adil_Vegetables Vegetables 288.00 1 29 0 0.00 2021-08-14 04:10:17 1628939417 1
106 13 0 0 Purchaser POS Fee 8.00 9 4 0 0.00 2021-08-14 04:10:17 1628939417 1
8 9 0 0 Ibrahim Plastic Store Dishwash Liquid (Gallon) 49.00 1 3 0 20.00 2021-08-14 04:10:17 1628939417 1
34 9 1 2 Ibrahim Plastic Store Aluminium File 1.00 1 3 0 0.00 2021-08-14 04:10:17 1628939417 1
35 9 5 10 Shah Sawar(Tissu) Hygienic Tissue 565.00 6 6 0 0.00 2021-08-14 04:10:17 1628939417 1
11 9 5 15 LocalGrocery_Fasil Piping Bag (Large) 14.00 1 3 0 0.00 2021-08-14 04:10:17 1628939417 1
37 9 2 3 Shah Sawar(Tissu) Hygienic Tissue Pack 0.00 2 3 0 0.00 2021-08-14 04:10:17 1628939417 1
109 9 30 100 Danyal Printing Company Coffee Takeaway Box 0.00 2 3 0 0.00 2021-08-14 04:10:17 1628939417 1