localhost:8080 / 127.0.0.1 / db_empower_dev / participant

There are no favorite tables.

Customize appearance of the navigation panel.

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.

Customize the navigation tree.

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 display options.

Servers

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 display options.

Databases

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

Tables display options.

Tables

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 -

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

Customize browse mode.

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 (6037 total, Query took 0.0875 seconds.) [middlename: R.R... - ERNAN...]

SELECT * FROM `participant` ORDER BY `middlename` DESC

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

Filter rows:

Sort by key:

			participant_id	firstname	lastname	middlename 1	dob	gender	ssn_lastfourdigits	phonenumber	email	address	city_id	state_id	zipcode	medications	special_diet	allergies	medical_needs	medical_needs_details	pregnancy	smoker	prior_treatment_drugalcohol	dl_number	dl_issued_state	dl_suspended	dl_points	court_order	blood_alcohol_content	emergencycontact_name	emergencycontact_phoneNumber	emergencycontact_relationship	created_date	created_by	updated_date	updated_by	notes	active
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8485	8485	gilberto	deluna jr	R.R	2003-07-13	M	5691	4194965704	gilbertodeluna27@gmail.com	819 Dearborn Ave	C21941	OH	43605	0	0	0	0	NULL	0	0	0	OH	OH	1	0	0	0.000	yolanda	4196938824	deluna	2026-02-03 01:31:52	System	2026-02-03 01:31:52	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8467	8467	Justin	Allen	R	1986-09-23	M	8293	4193249725	sogoosy@gmail.com	665 Collins st	C21941	OH	43610					NULL	0	0	0	SQ355516	OH	1	0	0	0.000	Angela Allen	5678687103	Mother	2026-01-28 12:23:40	System	2026-01-28 12:23:40	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8378	8378	Marion	Bryan	R	1995-01-18	M	0793	4193097186	mbryan2121@gmail.com	137 W Plumer St	C21941	OH	43605	N/A	N/A	N/A	N/A	NULL	0	0	0	KJH5913	OH	1	4	0	0.000	Carol Bryan	4193563017	Mother	2025-12-23 10:25:38	System	2025-12-23 10:25:38	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8440	8440	tammy	tressler	r	1973-05-24	F	7974	4192615937	tresslertammy1@gmail.com	4401 Foxglove rd	C21941	OH	43623			red dyes		NULL	0	0	0	RU541499	OH	1	0	0	0.000	tori whitenburg	4192055292	daughter	2026-01-20 15:54:13	System	2026-01-20 15:54:13	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8368	8368	Nolan	Ray	Parker	2002-02-04	M	2230	4195097117	nolanray16@gmail.com	621 n Adrian st	C13157	OH	43533					NULL	0	0	0	UU212279	OH	1	4	0	0.090	Larry ray	4193493914	Father	2025-12-17 19:23:02	System	2025-12-17 19:23:02	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8413	8413	Ashley	Timmons	Nicole	1995-08-23	F	4446	4193773538	a.n.timmons18@gmail.com	28439 Oak St	C14394	OH	43447	Lexapro	None	None	None	NULL	0	0	0	OHIO	OH	1	6	0	0.000	Sidney Gillig	4196356495	Partner	2026-01-08 16:38:10	System	2026-01-08 16:38:10	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8418	8418	Alayna	Johnson	Nicole	2001-03-08	F	7807	4193892309	alaynajohnson419@icloud.com	607 Pine Valley Lane	C21941	OH	43615					NULL	0	0	0	UX419553	OH	1	0	0	0.000	Regina Collins	4193679510	Step-Mother	2026-01-12 17:18:54	System	2026-01-12 17:18:54	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8454	8454	Catherine	Bidic	May	1988-09-04	F	9931	6097746728	catherinebidicmb14@gmail.com	357 stow creek road	C02572	NJ	08302					NULL	0	0	0	B41321147459884	NJ	2	0	0	1.000	Loretta hitchner	8563644491	Mother	2026-01-22 23:43:45	System	2026-01-22 23:43:45	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8424	8424	Justin	Marino	Mathew	1980-12-27	M	9434	8137480913	justmarino80@yahoo.com	1568 Horseshoe Bend Dr	C17231	OH	43551	N/A	N/A	N/A	N/A	NULL	0	0	0	SA039687	OH	2	0	0	0.000	Vickie Marino	4192970980	Morher	2026-01-13 13:56:30	System	2026-01-13 13:56:30	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8416	8416	Kathryn	Heckman	Margaret	2000-11-06	F	4980	5679706093	kathrynnheckman4@gmail.com	4223 Jackman Rd	C21941	OH	43612					NULL	0	0	0	UZ251928	OH	1	6	0	0.192	Kelly Dazey	4199020070	Mother	2026-01-10 23:01:09	System	2026-01-10 23:01:09	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8338	8338	Trisheena	Grant	Mae	1979-10-05	F	2260	9049106494	Trisheenajg@yahoo.com	1720 shawnee rd apartment 102	C12538	OH	45805			Seafood and ceclor		NULL	0	0	0	RS549991	OH	1	6	0	0.000	Jessica msrkd	4199799954	Sister	2025-12-06 16:25:04	System	2025-12-06 16:25:04	System		1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8476	8476	Ty	Carrizales	Macario	2004-06-28	M	7546	4199664258	tymack0628@icloud.com	503 W Rice St	C04818	OH	45831					NULL	0	0	0		NA		0	0	0.000	Brandy Carrizales	4194384927	Mother	2026-01-30 12:31:21	System	2026-01-30 12:31:21	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8458	8458	Abbey	Johnston	Lynne	1988-10-29	F	3238	4199660197	abbeyjohnston87@gmail.com	135 Northcrest Dr Apt 9C	C15278	OH	43545	N/A	N/A	N/A	N/A	NULL	0	0	0		NA	1	0	0	0.000	Pam Johnston	4199660198	Parent	2026-01-25 21:55:59	System	2026-01-25 21:55:59	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8457	8457	Luella	Travis	Lorene	1972-09-05	F	1314	4199061359	lorishaw44@yahoo.com	12329 Co Rd L	C15278	OH	43545					NULL	0	0	0	RS566165	OH	1	6	0	0.000	Randy Dickman	4199067166	Boyfriend	2026-01-25 17:57:54	System	2026-01-25 17:57:54	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8396	8396	Luella	Travis	Lorene	1972-09-05	F	1314	4199061359	lorishaw44@yahoo.com	12329 Co Rd L	C15278	OH	43545					NULL	0	0	0	RS566165	OH	1	6	0	0.000	Randy Dickman	4199067166	Boyfriend	2026-01-06 11:53:47	System	2026-01-06 11:53:47	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8426	8426	James	Smith	Lee	1995-01-29	M	8015	5673174439	jsmith012921@gmail.com	5517 Douglas rd #6	C21941	OH	43613	N/a	N/a	N/a	N/a	NULL	0	0	0	UE359749	OH	1	0	0	0.000	Jerry Palacio	4195098684	Mother	2026-01-13 18:51:44	System	2026-01-13 18:51:44	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8452	8452	Charles	Riseborough	L	1970-03-18	M	7624	4195916584	lukerise@yahoo.com	303 jahns road	C15278	OH	43545	Amlodipine 5mg/day, umeclidinium and vilanterol po...	Carnivore diet			NULL	0	0	0	OH	OH	1	0	0	0.196	Jena Riseborough	4195919741	Wife	2026-01-22 14:35:43	System	2026-01-22 14:35:43	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8425	8425	Robert	mangas	kyle	1957-12-12	M	4397	4198908596	rmangas57@icloud.com	750 E Sugar St	C12338	OH	45856	lisinopril, amlodipine, metoprol, simvastatin, xar...	none	none	CPAP machine	NULL	0	0	0	RG809722	OH	1	0	0	1.000	Kathy Mangas	4192046200	spouse	2026-01-13 14:35:03	System	2026-01-13 14:35:03	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8463	8463	Samuel	Barrick	Joseph	1984-09-25	M	2404	4195994901	barrick.samuel2@gmail.com	3721 Schneider rd	C21941	OH	43614					NULL	0	0	0	B230-844-21-800-0	FL	1	0	0	0.000	Karen Barrick	4197871088	Mother	2026-01-27 08:43:12	System	2026-01-27 08:43:12	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8385	8385	Pamela	Hill	Jo	1955-04-28	F	4424	4194600691	pam.hill1955@bex.net	7354 Deer Trail Ct	C21941	OH	43623	Citalopram 40 MG / Atorvastatin 40MG				NULL	0	0	0		NA	1	0	0	0.000	Lyndsey Mulherin	4192505624	Daughter	2025-12-30 09:42:14	System	2025-12-30 09:42:14	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8395	8395	Mathew	Huston	J	1985-09-08	M	9185	4196096451	tssgutters419@gmail.com	1179 Westgate Road	C21941	OH	43615	Symbicort inhaler Albuterol inhaler over-the-count...				NULL	0	0	0	OH	OH	1	0	0	0.000	Beverly Filipiak	4199136686	Sister	2026-01-05 15:14:03	System	2026-01-05 15:14:03	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8453	8453	Jack	Doyle	H	2000-05-18	M	8571	4195145209	jackdoy111@gmail.com	5362 Monroe St, Apt 7	C21941	OH	43623	N/A	N/A	N/A	N/A	NULL	0	0	0	OH	OH	1	6	0	0.208	Shannon Doyle	4195081752	Mother	2026-01-22 15:29:09	System	2026-01-28 14:34:35	Mekyaila		1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8490	8490	Reise	Saum	H	2005-07-17	F	4871	4193025539	reise20saum@gmail.com	1032 Vincent street	C07495	OH	45840	Citalopram 10mg	No	No	No	NULL	0	0	0	OH	OH	1	0	0	0.000	Sandy Thomas	4197222441	Grandmother	2026-02-05 10:07:56	System	2026-02-05 10:07:56	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8415	8415	Daniel	Mirocke	Gennaro	1995-08-25	M	4547	9134854346	hoss.mirocke@gmail.com	650 6th St, Apt 11	C02369	OH	43402					NULL	0	0	0	VY119427	OH	2	6	0	0.000	Johnny Carver	9139561211	Friend	2026-01-09 11:34:39	System	2026-01-09 11:34:39	System	NULL	1
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 8408	8408	Edgar	Chavez	Ernan	1994-11-05	M	4219	8327570639	ernannchavezz@gmail.com	2037 N Veron Street	C05621	MI	48128					NULL	0	0	0	VY963462	OH	1	0	0	0.000	Wallie Ana	8134434447	Friend	2026-01-08 11:51:09	Mekyaila	2026-01-08 11:57:26	Mekyaila		1

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view