Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: warehouselhr
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
page_permissions 22 InnoDB utf8mb4_general_ci 16.0 KiB -
set_date 1 InnoDB utf8mb4_general_ci 16.0 KiB -
tbl_admin 4 MyISAM latin1_swedish_ci 2.4 KiB -
tbl_daily_cash 1 InnoDB latin1_swedish_ci 16.0 KiB -
tmp_supplier_demand 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousepay 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousepurchased 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousepurchaserclosing 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousereceive 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousesell 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousestockin 0 InnoDB utf8mb4_general_ci 16.0 KiB -
tmp_warehousestockout 0 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousebank 23 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousebranches 3 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseitems 113 InnoDB utf8mb4_general_ci 64.0 KiB -
warehouseitemsunites 4 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousepaymentmethod 4 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseproducts 1 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseproductscategories 1 InnoDB utf8mb4_general_ci 16.0 KiB -
warehouseproductsrecipe 0 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousepurchased 6 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousepurchaserclosing 0 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousesell 12 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousestockin 60 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousestockout 85 InnoDB utf8mb4_general_ci 16.0 KiB -
warehousesuppliers 24 InnoDB utf8mb4_general_ci 48.0 KiB -
warehousesupplierscategories 16 InnoDB utf8mb4_general_ci 16.0 KiB -
27 tables Sum 380 InnoDB utf8mb4_general_ci 498.4 KiB 0 B

Create table
Name:
Number of columns: