localhost:8080 / 127.0.0.1 / opencats / company

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

SELECT * FROM `company`

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

Filter rows:

Sort by key:

			company_id	site_id	billing_contact	name	address	city	state	zip	phone1	phone2	url	key_technologies	notes	entered_by	owner	date_created	date_modified	is_hot	fax_number	import_id	default_company
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 1	1	1	NULL	Internal Postings										0	0	2009-11-19 10:00:20	2009-11-19 10:00:20	0		NULL	1
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 9	9	1	-1	Capital Info Tech Inc	14801 MURDOCK STREET, SUITE 160	CHANTILLY	VA	20151	210-239-8339					1256	1256	2023-11-14 10:50:49	2023-11-15 07:26:09	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 10	10	1	NULL	DMinds Solutions Inc	joseph@dminds.com				571-217-2920					1255	1255	2023-11-15 15:55:53	2023-11-15 15:55:53	1		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 8	8	1	NULL	Max Eleven	116 Village Blvd. Suite 200	Princeton	NJ	08540	609-427-8155		http://www.maxeleven.com/	Project Manager, Devops .		1257	1257	2023-11-14 10:49:03	2023-11-14 10:49:03	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 6	6	1	-1	TCS	No-153, No W-73 / 3, 8th Street, North Main Road,	Chennai	TamilNadu					Main Frame		1255	1255	2023-11-14 09:26:47	2023-11-17 10:11:25	1		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 7	7	1	NULL	Texium Solutions, Inc.	1600 Golf Rd Suite 1200	Rolling Meadows	IL	60008	847-454-7706	612-940-9977	http://www.texiumsolutions.com/	Life Science		1255	1255	2023-11-14 10:30:27	2023-11-14 10:30:27	1		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 11	11	1	NULL	Pioneer Consulting Services LLC	3490 US Highway 1, Building 10	Princeton	NJ	08540	515-309-1743		http://www.pioneeritconsulting.com/			1256	1256	2023-11-16 18:49:53	2023-11-16 18:49:53	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 12	12	1	NULL	Netskope, Inc	2445 Augustine Dr. 3rd floor	Santa Clara	CA	95054	800-685-2098	+44 84-5528-0141	https://www.netskope.com/		We are the only security vendor that accelerates y...	1	1	2023-11-17 00:46:06	2023-11-17 00:46:06	1		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 13	13	1	NULL	Ehub Global	17304 Preston Road Suite 800	Dallas	TX	75252	214-495-1914		http://www.ehub.global/			1256	1256	2023-11-21 18:48:54	2023-11-21 18:48:54	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 14	14	1	-1	Denso	Noida-Dadri Rd, Tilapta Village, Tilpatta.	Karanwas	Uttar Pradesh	203207	0120 256 0140		https://www.denso.com/in/en/		Denso Corporation is a global automotive component...	1	1	2023-11-30 00:17:14	2023-11-30 00:17:34	1		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 15	15	1	-1	Trident Solutions	116 Cooper Center. 7905 Browning Rd	Washington	DC	20559	1809-347-123		http://www.tridentsolutions.com/		Call us today at 1-800-843-0460 (856-662-2070) or ...	1	1	2023-11-30 00:29:38	2023-12-01 00:23:34	1		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 19	19	1	-1	Kryptos solutions									'Integrity': We uphold the highest ethical standar...	1	1	2023-12-01 00:09:32	2023-12-01 00:09:38	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 20	20	1	-1	Tangen sis Inc	5600 Tennyson Pkwy, Suite 275, Plano, TX - 75024	Plano	TX	75024	469-639-0018 x 103		http://www.tangensisinc.com/			1257	1257	2023-12-05 12:22:17	2023-12-05 12:23:07	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 21	21	1	NULL	IMR Soft	4525 Rt 27, Princeton -New Jersey 08540	Princeton	NJ		732-781-0066		https://imrsoft.com/			1257	1257	2023-12-05 12:25:21	2023-12-05 12:25:21	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 23	23	1	NULL	Recursion Technologies	101 E Park Blvd Ste 600 Plano, TX 75074	Plano	TX		903-228-4352					1257	1257	2023-12-05 12:29:54	2023-12-05 12:29:54	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 24	24	1	NULL	Momento USA LLC	440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 0...	Bellmawr	NJ	08031	856-456-1805					1257	1257	2023-12-05 12:43:08	2023-12-05 12:43:08	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 25	25	1	NULL	Winsai LLC	5920 S Miami Blvd Ste 201 Morrisville, North Carol...	Morrisville	NC	27560	980-920-8364					1257	1257	2023-12-05 12:45:39	2023-12-05 12:45:39	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 26	26	1	NULL	Workcog	25663 Smotherman Rd, Suite 203, Frisco, TX 75033	Frisco	TX	75033	469-663-0195					1257	1257	2023-12-05 12:58:04	2023-12-05 12:58:04	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 27	27	1	-1	ProCorp Systems Inc	2222 W Spring Creek Pkwy, STE 202,Plano, TX 75023.	Plano	TX	75023	469-562-0596		https://procorpsystems.co/			1257	1257	2023-12-05 13:06:12	2023-12-06 09:40:53	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 28	28	1	NULL	Caliber IT	454 South Anderson Rd #310, Rock Hill, SC 2973...	Rock Hill	SC	29730	865-935-8182					1257	1257	2023-12-05 13:08:32	2023-12-05 13:08:32	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 29	29	1	NULL	Baanyan Software Services Inc	100 Metroplex Drive, Suite 100, Edison, NJ. 08817	Edison	NJ	08817	732-595-9006					1257	1257	2023-12-05 13:59:16	2023-12-05 13:59:16	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 30	30	1	NULL	Ikon Systems LLC	8765 Stockard Dr, Ste 701, Frisco, TX 75034	Frisco	TX	75034	469-567-9252					1257	1257	2023-12-05 14:04:39	2023-12-05 14:04:39	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 31	31	1	-1	iTvorks Inc	101 College Road E, 3rd Floor STE # 302, Princeton...	Princeton	NJ	08540	973-920-2522		http://www.itvorks.com/			1257	1257	2023-12-05 14:06:29	2023-12-06 09:33:12	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 32	32	1	NULL	KESH Tec INC		Irving	TX		956-707-4736		http://www.keshtec.com/			1257	1257	2023-12-05 14:08:25	2023-12-05 14:08:25	0		NULL	0
Edit	Copy	Delete DELETE FROM company WHERE `company`.`company_id` = 33	33	1	NULL	Advithri Technologies	7150 Holland Dr, Suite 102C, Frisco TX 75035	Frisco	TX	75035	214-736-5494		https://advithri.com/			1257	1257	2023-12-05 14:12:09	2023-12-05 14:12:09	0		NULL	0

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view