Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: assetslhr »Table: inventory_breakage
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 (705 total, Query took 0.0036 seconds.) [id: 1... - 27...]
SELECT * FROM `inventory_breakage` ORDER BY `id` ASC 
Full texts id Ascending Descending 1item_namecategorypurposepurchased_frompurchase_linktotal_purchasedunit_price_aedprice_aedbefore_openingquantity_restauranttotal_breakagebalance_after_breakagestorage_place_restaurantbreakage_remarksquantity_dubaistorage_place_dubaiquantity_warehousestorage_place_warehousebranchimage_linkinvoice_linkpost_date
1 Steps Railing Civil Work NA NA NA 0 0.00 76.00 22 0 0 22 NA No remarks 0 NA 0 NA Lahore 1.jpg 1.jpg 2025-01-03 00:00:00
2 Display Chiller Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 2.jpg 2.jpg 2025-01-03 00:00:00
3 Reception Camera Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 3.jpg 3.jpg 2025-01-03 00:00:00
4 Fire Alarm Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 4.jpg 4.jpg 2025-01-03 00:00:00
5 Music Tab Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 5.jpg 5.jpg 2025-01-03 00:00:00
6 Punching Tab Electrical Appliances/Devices NA NA NA 0 0.00 76.00 2 0 0 2 NA No remarks 0 NA 0 NA Lahore 6.jpg 6.jpg 2025-01-03 00:00:00
7 Table Lamps Black Electrical Appliances/Devices NA NA NA 3 0.00 76.00 3 1 2 2 NA No remarks 0 NA 0 NA Lahore 7.jpg 7.jpg 2025-01-03 00:00:00
8 Ash tray Miscellaneous/Other Assets NA NA NA 0 0.00 76.00 4 0 0 4 0 NULL 0 0 0 0 Lahore 8.jpg 8.jpg 2025-01-03 00:00:00
9 Golden Lamp Electrical Appliances/Devices NA NA NA 0 0.00 76.00 10 8 2 16 0 NULL 0 0 2 0 Lahore 9.jpg 9.jpg 2025-01-03 00:00:00
10 Food Panda Machine Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 10.jpg 10.jpg 2025-01-03 00:00:00
11 Keenu Card Machine Electrical Appliances/Devices NA NA NA 0 0.00 76.00 3 0 0 3 NA No remarks 0 NA 0 NA Lahore 11.jpg 11.jpg 2025-01-03 00:00:00
12 Alfalah Card Machine Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 12.jpg 12.jpg 2025-01-03 00:00:00
13 Reception Lamp Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 13.jpg 13.jpg 2025-01-03 00:00:00
15 Official Mobile Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 15.jpg 15.jpg 2025-01-03 00:00:00
17 Breaker Board Office Electrical Appliances/Devices NA NA NA 0 0.00 76.00 2 0 0 2 NA No remarks 0 NA 0 NA Lahore 17.jpg 17.jpg 2025-01-03 00:00:00
18 Alarm Control Box Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 18.jpg 18.jpg 2025-01-03 00:00:00
19 Steel Ladder Miscellaneous/Other Assets NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 19.jpg 19.jpg 2025-01-03 00:00:00
20 Office Cameras Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 20.jpg 20.jpg 2025-01-03 00:00:00
21 Office Cabinet Furniture NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 21.jpg 21.jpg 2025-01-03 00:00:00
22 Kettle Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 22.jpg 22.jpg 2025-01-03 00:00:00
23 Water Dispenser Electrical Appliances/Devices NA NA NA 0 0.00 76.00 2 0 0 2 NA No remarks 0 NA 0 NA Lahore 23.jpg 23.jpg 2025-01-03 00:00:00
24 Office Chairs Furniture NA NA NA 0 0.00 76.00 4 0 0 4 NA No remarks 0 NA 0 NA Lahore 24.jpg 24.jpg 2025-01-03 00:00:00
25 System LCD Electrical Appliances/Devices NA NA NA 0 0.00 76.00 2 3 0 5 NA No remarks 0 NA 0 NA Lahore 25.jpg 25.jpg 2025-01-03 00:00:00
26 Stone LCD Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 26.jpg 26.jpg 2025-01-03 00:00:00
27 Camera Sceen Electrical Appliances/Devices NA NA NA 0 0.00 76.00 1 0 0 1 NA No remarks 0 NA 0 NA Lahore 27.jpg 27.jpg 2025-01-03 00:00:00

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)