←

Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: chief
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 :
Error in processing request
Error code: 200
Error text: OK (rejected)
It seems that the connection to server has been lost. Please check your network connectivity and server status.

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
page_permissions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 16.0 KiB -
set_date   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_admin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 MyISAM latin1_swedish_ci 2.3 KiB -
tbl_daily_cash   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 16.0 KiB -
tmp_supplier_demand   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 106 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousepay   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousepurchased   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousepurchaserclosing   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousereceive   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousesell   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousestockin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousestockout   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 75 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousebank   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 24 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousebranches   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseitems   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 941 InnoDB utf8mb4_general_ci 112.0 KiB -
warehouseitemsunites   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousepaymentmethod   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseproducts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 24 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseproductscategories   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseproductsrecipe   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 220 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousepurchased   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,018 InnoDB utf8mb4_general_ci 1.5 MiB -
warehousepurchaserclosing   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousesell   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 759 InnoDB utf8mb4_general_ci 96.0 KiB -
warehousestockin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 12,924 InnoDB utf8mb4_general_ci 1.5 MiB -
warehousestockout   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 33,774 InnoDB utf8mb4_general_ci 3.5 MiB -
warehousesuppliers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 181 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousesupplierscategories   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 35 InnoDB utf8mb4_general_ci 16.0 KiB -
27 tables Sum 56,106 InnoDB utf8mb4_general_ci 7.1 MiB 0 B
With selected:

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns:
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')
.\libraries\classes\Menu.php#450: PhpMyAdmin\DatabaseInterface->isSuperuser()
.\libraries\classes\Menu.php#103: PhpMyAdmin\Menu->_getDbTabs()
.\libraries\classes\Menu.php#70: PhpMyAdmin\Menu->_getMenu()
.\libraries\classes\Header.php#450: PhpMyAdmin\Menu->getDisplay()
.\libraries\classes\Response.php#343: PhpMyAdmin\Header->getDisplay()
.\libraries\classes\Response.php#356: PhpMyAdmin\Response->_getDisplay()
.\libraries\classes\Response.php#514: PhpMyAdmin\Response->_htmlResponse()
PhpMyAdmin\Response->response()