Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafelahore
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 :

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
customer_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 48.0 KiB -
designation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
purchaser_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 16.0 KiB -
stock_dairy_types   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_unicode_ci 1.0 KiB -
tbl_admin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 MyISAM latin1_swedish_ci 1.4 KiB -
tbl_attendance   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~101,524 InnoDB utf8mb4_general_ci 20.1 MiB -
tbl_brands   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 MyISAM latin1_swedish_ci 5.4 KiB 32 B
tbl_calculations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,128 InnoDB utf8mb4_general_ci 544.0 KiB -
tbl_cashdetails   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 48.0 KiB -
tbl_cities   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB latin1_swedish_ci 64.0 KiB -
tbl_customers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 96.0 KiB -
tbl_cus_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 520 InnoDB latin1_swedish_ci 112.0 KiB -
tbl_daily_cash   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,049 InnoDB latin1_swedish_ci 288.0 KiB -
tbl_daily_closing   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
tbl_demand_record   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13,341 InnoDB latin1_swedish_ci 2.2 MiB -
tbl_employees   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 272 InnoDB utf8mb4_general_ci 128.0 KiB -
tbl_emp_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_expenses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 197 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_exp_categories   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 964 InnoDB latin1_swedish_ci 336.0 KiB -
tbl_items_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 MyISAM latin1_swedish_ci 5.6 KiB -
tbl_leaves_use   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.0 KiB -
tbl_notes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
tbl_points   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 257 InnoDB utf8mb4_general_ci 32.0 KiB -
tbl_products   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB latin1_swedish_ci 48.0 KiB -
tbl_products_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 MyISAM latin1_swedish_ci 2.1 KiB -
tbl_purchaser_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_purchases   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,248 MyISAM latin1_swedish_ci 777.9 KiB -
tbl_pur_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11,635 InnoDB latin1_swedish_ci 1.9 MiB -
tbl_recipe   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,916 InnoDB latin1_swedish_ci 192.0 KiB -
tbl_reward_points   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8_unicode_ci 16.0 KiB -
tbl_sales   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 205 InnoDB latin1_swedish_ci 64.0 KiB -
tbl_sales_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 205 InnoDB latin1_swedish_ci 80.0 KiB -
tbl_sale_services   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM latin1_swedish_ci 3.0 KiB -
tbl_section_sale   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_services   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_services_calculations   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_staff_leaves   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 419 InnoDB utf8mb4_general_ci 64.0 KiB -
tbl_stock_dairy   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11,697 MyISAM latin1_swedish_ci 1.5 MiB -
tbl_suppliers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 109 InnoDB latin1_swedish_ci 80.0 KiB -
tbl_sup_cat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB latin1_swedish_ci 16.0 KiB -
tbl_sup_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14,628 InnoDB latin1_swedish_ci 3.1 MiB -
tbl_tmp_purchases   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM latin1_swedish_ci 2.1 KiB -
tbl_tmp_pur_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 3.7 KiB 1.7 KiB
tbl_tmp_stock_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
tbl_units   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 53 MyISAM latin1_swedish_ci 4.0 KiB -
46 tables Sum ~169,444 InnoDB utf8mb4_general_ci 32.0 MiB 1.7 KiB
With selected: / Check tables having overhead

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()