101.50.88.246:8021 / 127.0.0.1 / cafelahore / tbl_employees

`phpmyadmin`.`pma__pdf_pages`
`gul`.`tbl_admin`
`gul`.`cash_details`
`cafe`.`designation`
`mysql`.`time_zone`
`cafelahore`.`designation`
`mysql`.`help_category`
`cafelahore`.`customer_types`
`cafe`.`tbl_attendance`
`cafe`.`tbl_daily_cash`
`phpmyadmin`.`pma__tracking`
`mysql`.`tables_priv`
`mysql`.`db`
`mysql`.`user`
`gul`.`temp_approver`
`cafe`.`tbl_products`
`mysql`.`slow_log`
`mysql`.`general_log`
`chief`.`warehousestockout`
`chief`.`warehousepurchased`
`chief`.`warehouseproducts`
`chief`.`warehouseitems`
`chief`.`warehousesuppliers`
`chief`.`tmp_warehousesell`
`chief`.`warehousebranches`
 `mysql`.`time_zone_transition`
 `mysql`.`help_topic`
 `mysql`.`help_relation`
 `mysql`.`global_priv`
 `mysql`.`db`
 `mysql`.`roles_mapping`

  
New
cm9vdA==.YXNzZXRzcm9vdA==.YXNzZXRz0
assets
cm9vdA==.YXNzZXRzbGhycm9vdA==.YXNzZXRzbGhy0
assetslhr
cm9vdA==.YmlzdHJvcm9vdA==.YmlzdHJv0
bistro
cm9vdA==.Y2FmZQ==cm9vdA==.Y2FmZQ==0
cafe
cm9vdA==.Y2FmZWxhaG9yZQ==cm9vdA==.Y2FmZWxhaG9yZQ==0
cafelahore
cm9vdA==.Y2hpZWY=cm9vdA==.Y2hpZWY=0
chief
cm9vdA==.ZG9jcm9vdA==.ZG9j0
doc
cm9vdA==.Z3Vscm9vdA==.Z3Vs0
gul
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bGFob29ycm9vdA==.bGFob29y0
lahoor
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.b2xkcm9vdA==.b2xk0
old
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.cml2ZXJ2aWV3Y2FyZA==cm9vdA==.cml2ZXJ2aWV3Y2FyZA==0
riverviewcard
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test
cm9vdA==.dW1lcg==cm9vdA==.dW1lcg==0
umer
cm9vdA==.d2FyZWhvdXNlcm9vdA==.d2FyZWhvdXNl0
warehouse
cm9vdA==.d2FyZWhvdXNlbGhycm9vdA==.d2FyZWhvdXNlbGhy0
warehouselhr

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers

Servers display options.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »

Database: cafelahore »

Table: tbl_employees

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Browse mode

Customize browse mode.

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (272 total, Query took 0.0070 seconds.) [id_emp: 1... - 26...]

SELECT * FROM `tbl_employees` ORDER BY `id_emp` ASC

[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]

Filter rows:

			id	id_emp 1	name	house	designation	cell	id_card	salary_per_month	emergency_contact	date_of_birth	gender	marital_status	current_address	point	joining_date	bank_transfer_option	title_name	BeneficiaryBankCode	ProductTypeCode	bank_name	account_number	uniform_info	status	branch	post_date	hous
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 1	1	1	Shahid Noor	FOH	Busser	+923363950225	2160295377393	23000.00	0334-9677976	2005-03-01	Male	Single	Orakzai	Yes	2022-09-25	No	Shahid Noor	1	FTS	Bank AL Habib Limited	55980081000428014		Inactive	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 2	2	2	Rashid Farooq	FOH	Shift Manager	+923224748655	8270103587343	50000.00	+923453419834	2001-03-15	Male	Single	F7 France colony	Yes	2022-03-01	Yes	Muhammad Rashid Farooq	5	IBFTS	Bank Alfalah Limited	04041009565374	1 coat 1pant 2 shirts	Active	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 3	3	3	Irfan Ali	BOH-HOT	Commis 2	+923077563127	8110241876059	35000.00	+923077753127	1997-06-01	Male	Single	Bhimber AJK	Yes	2022-04-08	No	Irfan Ali	27	IBFTS	MCB Bank Limited	1032372661009943		Inactive	Lahore	2022-06-01	BOH-Pizza
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 4	4	4	Muhammad Abrar	FOH	Shift Manager	+923485582601	8220385250281	50000.00	+923458914205	1995-08-10	Male	Married	street no#11,house no#04,raja town new shkriyal Ra...	Yes	2022-03-02	Yes	Muhammad Abrar	5	IBFTS	Bank Alfalah Limited	04041008865823	1 kot,1pent,2shirts	Active	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 5	5	5	Abdul Wajid	FOH	Shift Manager	+923135031203	6110122214523	40000.00		1989-07-10	Male	Married		Yes	2022-03-05	No		0					Inactive	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 6	6	7	Usman Arshad	Office	Purchaser	+923444100439	1310174519555	25000.00		2001-10-01	Male	Single		Yes	2022-08-30	No		0					Inactive	Islamabad	2022-06-01	Office
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 7	7	8	Karamat Rasool	FOH	Senior Order Taker	+923190856896	8270103672383	38000.00		2001-02-05	Male	Single		Yes	2022-03-06	Yes	Karamt Rasool	5	IBFTS	Bank Alfalah Limited	04041009709784		Active	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 8	8	9	Raja Adil	FOH	Senior Order Taker	+923485025893	8270103685751	33000.00	+923403550046	1995-08-10	Male	Single	F7 jinah super	Yes	2022-04-01	No		0				2 shirts 1 appron	Inactive	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 9	9	10	Sher Ali	BOH-HOT	Dishwasher Main Kitchen	+923185577653	6110133652383	22000.00		1999-03-02	Male	Single		Yes	2022-04-17	No		0					Inactive	Islamabad	2022-06-01	BOH-HOT
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 10	10	11	Muhammad Naveed	FOH	Order Taker	+923435599390	1350409453647	25000.00		1997-05-01	Male	Married		Yes	2022-05-02	No	M Naveed	1	FTS	Bank AL Habib Limited	55980081000427013		Inactive	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 11	11	12	Muhammad Umer	BOH-PASTRY	Helper Pastry	+923089052550	3520076546425	50000.00		1998-08-12	Male	Single		Yes	2022-04-09	No		0					Inactive	Islamabad	2022-06-01	BOH-PASTRY
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 12	12	13	Zainab Bukhari	BOH-PASTRY	Head Patissier	+923499404496	6110181402464	227500.00	+923458503375	1998-07-13	Female	Single	Syed Khawar Abbas Bukhari F-11/4, street 61, hous...	No	2022-02-15	Yes	Zainab	15	IBFTS	Silkbank Limited	00372010069141	2 chef jackets 2 pants 2 aprons	Active	Islamabad	2022-06-01	BOH-PASTRY
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 13	13	14	Najeeb Ullah	BAR	Barista	+923405592203	6110187878863	30000.00	+92005512043	2000-12-08	Male	Single	Saidpur Village	Yes	2022-07-25	No		0				2 pant 2 shart 1 cap 1 appran	Inactive	Islamabad	2022-06-01	BAR
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 14	14	15	Kashif Javed Alvi	FOH	Order Taker	+923450055590	8210182144745	25000.00	0311-5598163	1996-11-11	Male	Married	Hostel city park road islamabad	Yes	2022-10-05	No		0					Inactive	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 15	15	16	Mustansar Arshad	BOH-HOT	Demi	+923495018105	3410117483151	40000.00	+923171008937	1997-02-05	Male	Married	E9 Islamabad	Yes	2022-03-20	No		0				1 Chef Coat	Inactive	Islamabad	2022-06-01	BOH-HOT
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 16	16	17	Faakhir Hassan	FOH	Assistant Manager	+923344803971	4210183488603	85000.00	+923364666771	2003-08-21	Male	Single	Bahria enclave, sector c1 street 13 c house 17	Yes	2022-06-15	Yes	FAAKHIR HASSAN	1	FTS	Bank AL Habib Limited	55980081000432010		Active	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 17	17	18	Vanessa Alam	BOH-HOT	CDP	+923218880432	3520152086306	130000.00		1994-11-29	Female	Single		No	2022-02-01	No		0					Inactive	Islamabad	2022-06-01	BOH-HOT
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 18	18	19	Nadeem Hashmi	BOH-PASTRY	Pastry Commis 2	+923485734929	1350368832509	31000.00	0348-0481119	2001-03-10	Male	Single	Manshera	Yes	2022-10-05	No		0				1 shart 1 appran 1 pant	Inactive	Islamabad	2022-06-01	BOH-PASTRY
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 19	19	20	Muahmmad Nazeem Khan	BOH-HOT	Sous Chef	+923118090735	7150403982959	80000.00	+923482660424	1994-12-19	Male	Single	Islamabad	Yes	2022-03-08	Yes	Nazeem Khan	27	IBFTS	MCB Bank Limited	1533103081005353	2 kitchen shirt	Active	Islamabad	2022-06-01	BOH-HOT
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 20	20	21	Syed Alam	BOH-HOT	Commis 3	+923185694580	1000265453	33000.00		2006-09-05	Male	Single	Phathan chowk golra sharif E-11 Islamabad	Yes	2022-10-05	No		0					Inactive	Islamabad	2022-06-01	BOH-HOT
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 21	21	22	Muhammad Hanif Khan	BOH-HOT	Senior Demi	+923480481119	1350380960473	50000.00	+923440323697	1999-09-04	Male	Married		Yes	2022-03-18	No	Hanif Khan	1	FTS	Bank AL Habib Limited	55980081000433011		Active	Islamabad	2022-06-01	BOH-HOT
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 22	22	23	Imran Anwar	FOH	House Keeping	+923255460273	6110126782889	17000.00		1995-01-09	Male	Single	Islamabad	Yes	2022-10-04	No		0					Inactive	Islamabad	2022-06-01	FOH
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 23	23	24	Abdullah Anwer	BOH-PASTRY	Helper Pastry	+923360079316	3330360504471	30000.00	0345-0345826	1999-11-20	Male	Single	The Galleria sector H Bahria Enclave	Yes	2022-10-07	No		0					Inactive	Islamabad	2022-06-01	BOH-PASTRY
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 24	24	25	Haider Gul	Office	Senior Finance Manager	+923431892604	6110173975789	120000.00	+923008000602	1993-08-07	Male	Married	Islamabad	Yes	2022-03-01	Yes	Haider Gul	22	IBFTS	Meezan Bank Limited	03170106919825	2 Shirt	Active	Islamabad	2022-06-01	Office
Edit	Copy	Delete DELETE FROM `tbl_employees` WHERE `tbl_employees`.`id` = 25	25	26	Muhammad Nadeem	BOH-PASTRY	Pastry Commis 1	+923485734929	1350368832509	40000.00		2002-02-03	Male	Single		Yes	2022-10-04	No	Nadeem	1	FTS	Bank AL Habib Limited	5598081000434012		Active	Lahore	2022-06-01	BOH-PASTRY

Check all With selected:

Filter rows:

Query results operations