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

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