Drop files here

SQL upload ( 0 ) x -

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

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (272 total, Query took 0.0029 seconds.) [id_emp: 1... - 26...]
SELECT * FROM `tbl_employees` ORDER BY `id_emp` ASC 
Full texts idid_emp Ascending Descending 1namehousedesignationcellid_cardsalary_per_monthemergency_contactdate_of_birthgendermarital_statuscurrent_addresspointjoining_datebank_transfer_optiontitle_nameBeneficiaryBankCodeProductTypeCodebank_nameaccount_numberuniform_infostatusbranchpost_datehous
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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