Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: warehouse »Table: warehouseitems
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 (251 total, Query took 0.0045 seconds.) [image_path: [BLOB - 0 B]... - [BLOB - 8 B]...]
SELECT * FROM `warehouseitems` ORDER BY `image_path` ASC 
Full texts idtitleunit_idmininew_orderopening_stockbalance_stockunit_costsupplier_idsuppliers_cat_idpost_dateRemarkimage_path Ascending Descending 1
2 Callebaut 823 10 Kg 4 0 0 0.000 0.000 55575.000 24 2 2024-08-14 00:07:00 non
6 Frozen Passion Fruit Purees 1kg 4 2 5 3.000 3.000 3563.000 3 2 2024-08-14 00:12:00 NA
7 Frozen Mandarin Puree 1Kg 4 1 2 1.000 1.000 2100.000 3 2 2024-08-14 00:13:00 NA
12 Parmesan Cheese 5Kg 4 0 0 0.000 0.000 41850.000 3 2 2024-08-14 00:18:00 NA
14 Frozen Pineapple 1Kg 4 1 3 0.000 0.000 1500.000 3 2 2024-08-14 00:20:00 NA
30 Agar Agar 100 Gram 4 2 5 1.000 1.000 2400.000 9 2 2024-08-14 00:38:00 isb
31 Gelatin Sheets 1Kg 4 1 3 1.000 1.000 9975.000 12 2 2024-08-14 00:40:00 ISB
32 Coconut Flakes 396 Gram 4 1 4 1.000 1.000 1650.000 13 2 2024-08-14 00:41:00 isb
35 Liquid Smoke 118 Ml 4 3 5 1.000 1.000 850.000 13 2 2024-08-14 00:44:00 isb
37 Saffron 10 Gram 4 1 1 2.000 2.000 14625.000 16 2 2024-08-14 00:46:00 isb
38 Spanish Smoke Paprika 53 Gram 4 0 0 0.000 0.000 1875.000 17 2 2024-08-14 00:48:00 isb
41 Arborio Rice 1Kg 4 6 12 7.000 7.000 1300.000 5 2 2024-08-14 00:51:00 isb
42 Rigatoni Pasta 475 Gram 4 0 0 0.000 0.000 375.000 22 2 2024-08-14 00:52:00 isb
585 Gracie China Gold Porcelain Teapot 4 0 0 4.000 4.000 0.000 24 12 2025-02-13 11:04:37 [BLOB - 8 B]
586 586 4 0 0 1.000 1.000 760.000 24 12 2025-02-13 11:04:37 [BLOB - 8 B]
595 595 4 0 0 6.000 6.000 608.000 24 12 2025-02-13 11:04:37 [BLOB - 8 B]
596 596 4 0 0 6.000 6.000 0.000 24 12 2025-02-13 11:04:37 [BLOB - 8 B]
605 605 4 0 0 2.000 2.000 0.000 24 12 2025-02-13 11:04:37 [BLOB - 8 B]
635 635 4 0 0 15.000 15.000 0.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]
646 646 4 0 0 14.000 14.000 0.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]
647 647 4 0 0 24.000 24.000 3420.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]
648 648 4 0 0 4.000 4.000 0.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]
649 649 4 0 0 4.000 4.000 0.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]
654 654 4 0 0 2.000 2.000 1672.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]
666 666 4 0 0 3.000 3.000 0.000 24 12 2025-02-13 11:04:38 [BLOB - 8 B]

Warning in .\libraries\classes\Dbi\DbiMysqli.php#199
mysqli::query(): (HY000/1034): Index for table 'global_priv' is corrupt; try to repair it

Backtrace

.\libraries\classes\Dbi\DbiMysqli.php#199: mysqli->query(
string 'SELECT 1 FROM mysql.user LIMIT 1',
integer 0,
)
.\libraries\classes\DatabaseInterface.php#316: PhpMyAdmin\Dbi\DbiMysqli->realQuery(
string 'SELECT 1 FROM mysql.user LIMIT 1',
,
integer 1,
)
.\libraries\classes\DatabaseInterface.php#2396: PhpMyAdmin\DatabaseInterface->tryQuery(
string 'SELECT 1 FROM mysql.user LIMIT 1',
integer 256,
integer 1,
)
.\libraries\classes\DatabaseInterface.php#2338: PhpMyAdmin\DatabaseInterface->isUserType(string 'super')
.\sql.php#182: PhpMyAdmin\DatabaseInterface->isSuperuser()
.\tbl_recent_favorite.php#24: require(.\sql.php)