localhost:8080 / 127.0.0.1 / db_empower_migration / participant

There are no favorite tables.

New
db
empower_dev
information_schema
marketing_ops
- marketing_ops
- marketing_ops_testing
mysql
opencats
performance_schema
phpmyadmin
tamarisk
- tamarisk
- tamarisk_legal_advisors
test

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 (5523 total, Query took 0.0086 seconds.) [created_by: SEETHA... - MIGRATIONUSER...]

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

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

Filter rows:

Sort by key:

			participant_id	firstname	lastname	middlename	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 1	updated_date	updated_by	notes
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7977	7977	Gevin	Ruis		2009-12-03	M	4512	0545131322	gevin@gmail.com	6th Street	C16981	NJ	07055					NULL	0	0	0		NA		0	0	0.000	leonard	7779451208	Cousin	2025-12-05 13:55:39	Seetha	2025-12-05 13:55:39	Seetha
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7975	7975	Test	user one		2000-03-15	F	2315	8979465123	testuser@gmail.com	spotlight	C12923	CA	90001					NULL	0	0	0		NA		0	0	0.000	Henry	2315346469	Son	2025-11-24 12:48:07	Seetha	2025-11-24 13:30:28	Seetha
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7974	7974	Test	User two		1991-11-12	M	3465	4567890887	testmail@gmail.com	789 Mainland Ave	C16981	NJ	07055					NULL	0	0	0		NA		0	1	0.005	Robert	3456765434	Brother	2025-11-24 12:48:06	Regina	2025-11-24 13:46:21	Regina
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7973	7973	Russell	Hulsey		1900-01-01	U	xxxx	4092561473	rusty_hu@hotmail.com	16920 Co Rd 39	C19091	TX	77853						0	0	0	None	OH		0	1	NULL				2025-07-02 09:19:59	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7972	7972	Elliott	Davis		1900-01-01	U	xxxx	4193516037	elliottdavis3254@gmail.com	3254 Brigham St	C21941	OH	43608						0	0	0	None	OH		0	1	NULL				2025-07-02 09:10:11	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7971	7971	Terry	Mcvay		1900-01-01	U	xxxx	5673711419	mcvay0083@gmail.com	1730 Frail Rd	C12538	OH	45806						0	0	0	None	OH		0	1	NULL				2025-07-02 05:57:17	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7970	7970	James	Burns		1986-12-04	M	9733	7402256205	jburns259@gmail.com	5402 Sandy Acres Drive	C19659	OH	44870						0	0	0	Sp46573	Oh	1	12	1	NULL	Nicole	4193071418	Girl friends	2025-07-01 06:36:01	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7969	7969	Andrew	Meyer		1900-01-01	U	xxxx	4195742328	meyermowing@gmail.com	158 Wilkshire Dr	C23151	OH	43566						0	0	0	None	OH		0	1	NULL				2025-07-01 05:50:11	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7968	7968	Justin	Steptoe		1900-01-01	U	xxxx	2675161147	garranines2@gmail.com	5654 Blakemore St	C17302	PA	19138						0	0	0	None	OH		0	1	NULL				2025-07-01 03:58:43	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7967	7967	Jeromy	Burt		1999-05-27	M	3412	4199666625	Jeromy.burt@yahoo.com	211 Sheffield Ave	C15278	OH	43545	None	None	None	None		0	0	0	UK784271	OH	1	0	1	NULL	Maggie Burt	4199666625	Wife	2025-06-30 09:40:29	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7966	7966	Michael	Goodell Sr		1900-01-01	M	7620	4193670560	mikegoodellsr@gmail.com	13845 Waterville swanton rd	C21484	OH	43558						0	0	0	rg868655	OH		0	1	NULL	alissa goodell	4193513897	daughter	2025-06-27 06:05:35	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7965	7965	Amber	Fast		1900-01-01	U	xxxx	4195513983	Amberdfast@gmail.com	09363 County Road S	C17478	OH	43554						0	0	0	None	OH		0	1	NULL				2025-06-26 02:32:48	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7964	7964	Harold	Moss		1900-01-01	U	xxxx	4195149735	kinglouislll21@gmail.com	3414 Gladstone Ave.	C21941	OH	43608						0	0	0	None	OH		0	1	NULL				2025-06-25 03:15:28	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7963	7963	Tiffany	Hines		1900-01-01	U	xxxx	4193710161	tiffanyhines02@hotmail.com	3512 Weldon Drive	C12538	OH	45806						0	0	0	None	OH		0	1	NULL				2025-06-25 02:43:02	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7962	7962	Pablo	Pecina		1975-07-12	M	5195	5673950693	pablo_pecina@yahoo.com	1805 Brownstown Blvd	C21941	OH	43614	Irbesartan, Atorvastatin, Metropolol, Vitamin C, V...	na	na	na		0	0	0	RU518000	OH	1	4	1	NULL	Dora Pecina	4192504767	mother	2025-06-24 23:37:35	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7961	7961	Victoria	West		1995-06-02	F	5034	7402581219	vkwest@yahoo.com	405 Hankinson Ln	C15664	OH	43056	n/a	n/a	n/a	n/a	n/a	0	1	0	TZ450163	OH	1	0	1	NULL	Stacy Mowery	6784990061	Parent	2025-06-24 08:39:43	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7960	7960	Terrence	Brown		1900-01-01	U	xxxx	4195402476	Tebrown@gmail.com	256 Kohler	C21941	OH	43613						0	0	0	None	OH		0	1	NULL				2025-06-24 06:52:01	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7959	7959	Patrica	Hawkins		1900-01-01	U	xxxx	4192159985	Prettymepatty@gmail.com	1693 Miami Street	C21941	OH	43605						0	0	0	None	OH		0	1	NULL				2025-06-24 05:13:54	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7958	7958	Josean	Fleming		1900-01-01	U	xxxx	4193893144	josiah042093@gmail.com	3440 Chestnut St	C21941	OH	43608						0	0	0	None	OH		0	1	NULL				2025-06-24 05:00:39	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7957	7957	Madeline	Fletcher		2000-03-28	F	8179	7406240033	Madelinefletcher411@yahoo.com	168 Highland Dr	C15486	OH	43762						0	0	1	UY197482	OH	1	0	1	NULL	Angela Hinze	7406248286	Mother	2025-06-24 04:51:42	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7956	7956	Dontres	White		1900-01-01	U	xxxx	4193568811	dontreswhite30@gmail.com	26 E Central Ave	C21941	OH	43608						0	0	0	None	OH		0	1	NULL				2025-06-24 03:37:00	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7955	7955	Darian	Corso		1900-01-01	U	xxxx	4195729253	dariancorso.dc@gmail.com	3565 E. Manhatten Blvd. Apt. 14B	C21941	OH	43611						0	0	0	None	OH		0	1	NULL				2025-06-24 03:28:37	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7954	7954	Connor	Ernsberger		1900-01-01	U	xxxx	4193074138	teresae0322@hotmail.com	1819 Bark Lane Dr.	C08038	OH	43420						0	0	0	None	OH		0	1	NULL				2025-06-24 02:39:49	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7953	7953	Zafarjon	Akhmedov		1900-01-01	U	xxxx	5132241714	axmedovzafar21@gmail.com	960 E. 12th St. Apt. 6H	C02728	NY	11230						0	0	0	None	OH		0	1	NULL				2025-06-21 07:55:26	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 7952	7952	Delesha	Haywood		1900-01-01	U	xxxx	4192627741	deleshaallen@gmail.com	214 E Napoleon Rd. Apt. 74	C02369	OH	43402						0	0	0	None	OH		0	1	NULL				2025-06-21 07:09:32	MigrationUser	2025-11-17 05:02:48	MigrationUser

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view