server.tail019542.ts.net / 127.0.0.1 / shahiderp / leave_application

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

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: shahiderp »

Table: leave_application

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

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 (347 total, Query took 0.0013 seconds.)

SELECT * FROM `leave_application`

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

Filter rows:

			leave_id	uid	tl_uid	leave_apply_date	from_date	to_date	type_of_leave	leave_reason	address_on_leave	phone_on_leave	web_mail_access	tl_leave_app	tl_adv_notice	tl_is_bcp_resource_ide	hr_approve_status	hr_elg_leave	hr_earned_leave	hr_unpaid_leave	hr_balance_leave	hr_Comments	hr_uid	manager_app_status	task_assign	tl_rejectioncomments	leave_usertype	Status	main_leave_status
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 1	1	21	0	2019-04-30	2019-05-01	2019-05-04	Personal Leave	sddddsdssd	gurgaon manesar	4000040000	No				Yes	1	Yes	No	7	testing	106		136		User	Disable	Yes
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 2	2	21	1	2019-04-30	2019-04-30	2019-04-30	Sick Leave	for checkup	gurgaon	5454054540	No		Yes	Yes	Yes	1	Yes	No	7	testing	106	Yes	153		User	Enable	Yes
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 3	3	21	1	2019-04-30	2019-05-12	2019-05-14	Sick Leave	Bed rest	gurgaon	7027091097	No		No	No	Yes						0		84	No	User	Disable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 4	4	2	0	2019-05-17	2019-05-17	2019-05-17	Sick Leave	sick	abc	98963426171	Yes				Yes	1	Yes	No	7	approved	106		83		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 5	5	148	84	2019-07-10	2019-10-06	2019-10-10	Personal Leave	Durga Puja	agartala, tripura	9612360437	Yes	Yes	Yes	Yes	Yes	1	Yes	No	10	Approved/Work Handover to shahnewaz sir confirmed ...	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 6	6	146	0	2019-07-10	2019-08-17	2019-08-18	Personal Leave	I have to go home because there is work of docume...	Balaji Pg Guragaw	9078802114	Yes				Yes					app	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 7	7	153	83	2019-07-11	2019-10-03	2019-07-11	Personal Leave	Durga puja rituals at my home.Have to attend.Its a...	Samta apartment,238,GLT Road,kolkata-36	7044656296	No	Yes	Yes	Yes	Yes	1	Yes	No	10	Approved /hand over to Ashish and work handover to...	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 8	8	140	0	2019-07-11	2019-10-06	2019-10-17	Personal Leave	ItÃ¢â‚¬â„¢s been so long after joining this compan...	H21, Aaron Ville, Sector-48 , Gurugram	8759151241	Yes				No					Not approve	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 9	9	117	0	2019-07-15	2019-07-28	2019-07-29	Personal Leave	Grand Mom Funeral Ceremony ( Barsi)	Kamleshwar Nagar , Sahastradhara Road , Dehradoon	9810740511	Yes				No					not active members	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 10	10	144	0	2019-07-22	2019-08-11	2019-08-11	Personal Leave	Need to meet parents and go for a tour	OYO Life 18930, vipul world block - A, sector 48, ...	8250383632	Yes				No	1	0	0	0	Not approved	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 11	11	115	0	2019-07-24	2019-08-13	2019-08-14	Personal Leave	EID	787, Mohammed Zai, Shahjahanpur, 242001	9044505755	No				No					old one	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 12	12	119	83	2019-07-25	2019-07-25	2019-07-25	Half Day PL	I have to drop my younger brother bus station , as...	g3/82 sai enclave mohan garden uttam nager ,delhi	8447001096	Yes				No					not active employee	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 13	13	21	0	2019-07-26	2019-07-26	2019-07-26	Half Day SL	Bed rest	gurgaon	702709	Yes				Yes						0		0		User	Disable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 14	14	21	155	2019-07-26	2019-07-26	2019-07-26	Sick Leave	Bed rest	gurgaon	702709	Yes				Yes						0		0		User	Disable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 15	15	135	84	2019-07-28	2019-08-13	2019-08-14	Personal Leave	Eid	professor colony mahmand jalal nagar, shahjahanpur...	9696238815	No				No					not active employee	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 16	16	136	83	2019-07-30	2019-08-17	2019-08-17	Personal Leave	Raksha Bandhan	Balaji Pg	9874328108	Yes				No					Not active employee	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 17	17	135	84	2019-08-01	2019-08-01	2019-08-01	Half Day SL	because I have to attend the function of one of my...	transformer street neb sarai saket	9696238815	No				No					Not active employee	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 18	18	144	83	2019-08-01	2019-08-03	2019-08-03	Sick Leave	Need to go for a check up in Delhi with my relativ...	Vipul World , block - A , sector 48 , Gurgaon - 12...	8250383632	Yes				Yes						0		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 19	19	129	155	2019-08-01	2019-08-04	2019-08-04	Personal Leave	family function	Dwarka, Delhi	8076066321	No				Yes						0		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 20	20	108	155	2019-08-03	2019-08-03	2019-08-03	Half Day PL	Cousin Engagement Ceremony	Sec - 8 , Pratapnagar	9354120889	No				Yes	1	Yes	No	0	Half Day Leave Approved	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 21	21	108	155	2019-08-04	2019-08-07	2019-08-07	Personal Leave	Cousin Marriage Ceremony	Sec - 8 , Pratapnagar	9354120889	No				No					old leave category	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 22	22	121	84	2019-08-04	2019-08-11	2019-08-14	Mandatory Leave	I have to attend My Cousins marraige	Hno 120 VPO Palra TEH Beri DIST Jhajjar HARYANA	9639143858	No				Yes	0	Casual Leave	Yes	0	Approved	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 23	23	137	83	2019-08-05	2019-08-05	2019-08-05	Half Day SL	cold and vommiting	Shree durga pg , Sarpanch gali no 3. Room No -205	9079343113	No				No					Old leave .Already calculated manually	106		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 24	24	116	83	2019-08-07	2019-08-14	2019-08-14	Half Day SL	I have to go some where for some personal work.	New Delhi	8377969597	No				Yes						0		0		User	Enable
Edit	Copy	Delete DELETE FROM `leave_application` WHERE `leave_application`.`leave_id` = 25	25	83	0	2019-08-10	2019-08-10	2019-08-10	Half Day SL	To get my friend home safely as he is feeling sick...	Pataudi	9810740511	No				No	0	Yes	No	0	Apply from your own ERP Login ID	106		0		TL	Enable

Check all With selected:

Filter rows:

Query results operations