Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »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.0060 seconds.) [id: 273... - 248...]
SELECT * FROM `tbl_employees` ORDER BY `id`  DESC 
Full texts id Descending Ascending 1id_empnamehousedesignationcellid_cardsalary_per_monthemergency_contactdate_of_birthgendermarital_statuscurrent_addresspointjoining_datebank_transfer_optiontitle_nameBeneficiaryBankCodeProductTypeCodebank_nameaccount_numberuniform_infostatusbranchpost_datehous
273 2000 Hassan Ghaznavi FOH Senior Admin Manager 350000.00 1988-02-12 Male Single Yes 2022-03-01 Yes Hassan Ghaznavi 5 IBFTS Bank Alfalah Limited 04031005787149 Active Islamabad 2025-03-12 FOH
272 187 Saif Ali Khan BOH-PASTRY Commis 3 +923554696655 7170203459417 28000.00 +92 1997-10-02 Male Single Saidpur Village Yes 2025-02-15 No 0 Active Islamabad 2025-03-01 BOH-PASTRY
271 186 Muhammad Hassan Ul Haq FOH Busser +923179028881 8230126222089 20000.00 +923129252256 2001-02-22 Male Single Saidpur accomodation Yes 2025-02-20 Yes Muhammad Hassan Ul Haq 22 IBFTS Meezan Bank Limited 00300109690603 Sweater, Shirt, Pant, apron, Cap Active Islamabad 2025-02-24 FOH
270 587 Shahzad Arif BOH-HOT Dishwasher Main Kitchen 3510331127061 25000.00 1990-01-01 Male Single Yes 2025-01-24 No 0 1 Shirt & 1 Apron Active Lahore 2025-02-17 BOH-HOT
269 588 Asmat Ullah BOH-HOT Dishwasher Main Kitchen 7120370811339 25000.00 2001-01-20 Male Married Yes 2025-02-05 No 0 1 Shirt & 1 Apron Active Lahore 2025-02-17 BOH-HOT
268 586 Shahid Maqbool BOH-HOT Dishwasher Main Kitchen 3520138962923 25000.00 1981-08-22 Male Married Yes 2025-02-05 No 0 1 Shirt & 1 Apron Active Lahore 2025-02-17 BOH-HOT
267 585 Hammad Manzoor FOH Busser 1310114193215 25000.00 2006-03-13 Male Single Yes 2025-02-09 No 0 1 Shirt, 1 Trouser & 1 Apron Active Lahore 2025-02-17 FOH
266 584 Muhammad Usman BOH-PASTRY Intern Pastry 3520209882373 10000.00 2003-01-25 Male Single Yes 2025-02-01 No 0 1 Shirt, 1 Trouser & 1 Apron Active Lahore 2025-02-17 BOH-PASTRY
265 185 Binyameen Yousaf FOH House Keeping +923476748171 6110166076693 20000.00 2004-01-17 Male Single F6 Islamabad Yes 2025-01-24 No 0 Active Islamabad 2025-01-30 FOH
264 184 Noman BOH-PASTRY Pastry Commis 3 +923489299771 1350354027293 28000.00 2005-04-10 Male Single Yes 2025-01-20 No 0 Active Islamabad 2025-01-30 BOH-PASTRY
263 583 Sadaqat Ullah BOH-HOT Dishwasher Main Kitchen +923554722419 7120327545455 25000.00 2003-10-20 Male Single Yes 2025-01-26 No 0 Active Lahore 2025-01-30 BOH-HOT
262 581 Irfan Hanif FOH House Keeping +923284365639 3520230763395 25000.00 1974-09-25 Male Married Yes 2025-01-22 No 0 1 Shirt & 1 Trouser Active Lahore 2025-01-29 FOH
261 579 Salar Nazir BOH-HOT Intern Main Kitchen +923484991126 3520176663517 20000.00 2003-03-26 Male Single Yes 2025-01-04 No 0 1 Shirt & 1 Trouser Active Lahore 2025-01-29 BOH-HOT
260 582 Azan Atif BOH-HOT Commis 2 +923174871736 3740533571187 30000.00 2004-02-16 Male Single Yes 2025-01-04 No 0 1 Shirt, 1 Trouser & 1 Apron Active Lahore 2025-01-29 BOH-HOT
259 580 Aziz Ullah BOH-HOT Commis 1 +923470658107 1610254145231 40000.00 2003-01-01 Male Single Yes 2025-01-14 No 0 1 Shirt, 1 Cap & 1 Trouser Active Lahore 2025-01-25 FOH
257 577 Ijaz Mehboob Khan Babar BOH-HOT Senior CDP +923062607055 3620294575349 65000.00 1996-05-03 Male Married Yes 2025-01-08 Yes Ijaz Mehboob Khan Babar 5 IBFTS Bank Alfalah Limited 04611007953164 Active Lahore 2025-01-18 FOH
256 578 Shafi Ullah BAR Intern Barista +923435925028 1540212860409 25000.00 2002-03-01 Male Single Yes 2025-01-03 No 0 1 Shirt & 1 Apron Active Lahore 2025-01-18 FOH
255 576 Ali Raza FOH Busser +923418172139 3530141120209 25000.00 2000-12-12 Male Single Yes 2024-12-26 No 0 1 Shirt, 1 Trouser & 1 Apron Active Lahore 2025-01-07 FOH
254 183 Anwar Ahmad FOH GRO +923454146992 3520282323077 35000.00 1984-07-17 Male Married Yes 2024-12-09 No 0 Active Lahore 2024-12-13 FOH
253 575 Saqib Tariq FOH Server +923065878482 1310126151537 25000.00 1999-05-13 Male Single Yes 2024-11-06 No 0 1 Shirt, 1 Trouser & 1 Apron Active Lahore 2024-12-13 FOH
252 182 Ahraz Ali BOH-PASTRY Pastry Commis 3 +923452851964 7170203449591 25000.00 2003-01-27 Male Single Saidpur Village Yes 2024-12-07 No 0 Active Islamabad 2024-12-08 BOH-PASTRY
251 181 Muhammad Saqib FOH Server +923125507178 8220142168435 28000.00 +923125507178 2004-12-20 Male Single Saidpur Village Yes 2024-11-07 No 0 Shirt 2 Pant 1 Active Islamabad 2024-11-19 FOH
250 574 Najeeb Ullah FOH Server +923555289191 3530198227659 30000.00 +923555289191 2024-10-22 Male Single Yes 2024-10-03 No 0 1 Shirt, 1 Trouser & 1 Apron Active Lahore 2024-11-02 FOH
249 573 Sohail Ahmad BOH-HOT Dishwasher Main Kitchen 25000.00 0000-00-00 Male Single Yes 2024-11-01 No 0 Active Lahore 2024-11-02 FOH
248 180 Ubaid Ullah BOH-PIZZA Helper Main Kitchen +923424044883 1520210596689 25000.00 +92 2005-04-09 Male Single Saidpur Village Yes 2024-10-21 No 0 Shirt Active Islamabad 2024-10-25 BOH-HOT