perfex.tail1f1784.ts.net / 127.0.0.1 / gms_local / tblclients

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

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

SELECT * FROM `tblclients`

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

Filter rows:

			userid	company	vat	phonenumber	country	city	zip	state	address	website	datecreated	active	leadid	billing_street	billing_city	billing_state	billing_zip	billing_country	shipping_street	shipping_city	shipping_state	shipping_zip	shipping_country	longitude	latitude	default_language	default_currency	show_primary_contact	stripe_id	registration_confirmed	addedfrom	internal_notes	id_odoo	tax_type	tax_pct	bank_account	bank_name	swift_bic	balance	exchange_rate	payment_terms	payment_days	billing_ftao	billing_phone	billing_street_addon	shipping_ftao	shipping_phone	shipping_street_addon	shipping_department	shipping_designation	classification	last_vat
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 1	1	PRODIEL	B91706499	+34 677 711 076	0	NULL	NULL	NULL	NULL	www.prodiel.com	2024-02-01 16:51:11	1	NULL	Leonardo Da Vinci, 2. Edificio Prodiel. Isla de La...	Sevilla		41092	0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	1	0			B91706499				Bid Department		inactive	B91706499
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 2	2	Test	NULL		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:11	0	NULL					0					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	0	0				0.000000	0.000000	5	0									inactive	NULL
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 3	3	VOLTALIA TACHKENT LLC	310089650		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:11	1	NULL	Number 376816 <br /> TIN: 310 089 650 <br /> Tas...				0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	1	0							Center of Expertise		inactive	310089650
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 4	4	STERLING & WILSON	B87945929	+91-93 19 592732	0	NULL	NULL	NULL	NULL		2024-02-01 16:51:11	1	NULL					0					0	NULL	NULL	NULL	0	0	NULL	1	3	No hemos trabajado para este cliente	NULL	0	0				0.000000	0.000000	1	0									inactive	B87945929
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 5	5	IGNIS ENERGIA	B87290805		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:11	1	NULL	ESB88269832<br /> Cardenal Marcelo Spínola 4<br />...				209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	1	0		+34 910 059 775							inactive	B87290805
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 6	6	IDEA ENERGÍA	B90099409	+34955186058	0	NULL	NULL	NULL	NULL		2024-02-01 16:51:11	1	NULL	C/ Balbino Marrón, 8<br /> Edif. Viapol, Pl. 6ª mo...	Sevilla		41018	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	1	0	Pablo García	+34955186058							inactive	B90099409
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 7	7	ACISA	B84203652	+34 91 381 92 20 EXT. 1420	0	NULL	NULL	NULL	NULL	http://www.aldesa.es/	2024-02-01 16:51:11	1	NULL	C. Bahía de Pollensa, 17	Madrid		28042	0					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	1	0		+34 91 381 92 20							inactive	B84203652
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 8	8	Voltalia SA (VOLTALIA)	FR458182448		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	84 Boulevard de Sébstopol<br /> 75003 París, Fran...				0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	1	0			VAT n° FR82485182448						inactive	FR458182448
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 9	9	Lightsource Renewable Energy Netherlands Holding B...	NL69841527		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Gustav Mahlerlaan 1212	Amsterdam		1081LA	155					0	NULL	NULL	NULL	3	0	NULL	1	3		NULL	NULL	0	43000109			4997.840000	1.124880	2	30									inactive	NL69841527
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 10	10	Dapsun - Investimentos e Consultoria, Unip. Lda	PT515083836		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Rua Júlio Dinis Nº 247-6º E-1, Ed. Mota Galiza	Porto		4050-324	177					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	2	30									inactive	PT515083836
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 11	11	Hanwha Q Cells GmbH (QCELLS)	W2765984F		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Gran Vía 4	Madrid		28013	0					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0	43000098			7157.150000	1.000000	2	30									inactive	W2765984F
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 12	12	Voltalia Portugal, SA (VOLTALIA)	PT507651120		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	PT-507651120 <br /> Zona Industrial - Apartado 36	Oliveira de Frades		3680-170	0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	2	30									inactive	PT507651120
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 13	13	Ortiz Construcciones y Proyectos SA (ORTIZ)	A190001205		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Avenida Ensanche de Vallecas 44	Madrid		28051	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0	43000102			1121.520000	1.000000	2	30									inactive	A190001205
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 14	14	Solarpack Ingeniería S.L.U.	B91748863		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Calle Astronomia Nº 1 Torre 1 9º Módulo 5	Sevilla		41015	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0	43000075			6050.000000	1.000000	2	30			B91748863						inactive	B91748863
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 15	15	Envatios Promocion SL (PRODIEL)	B90380098		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Calle Leonardo da Vinci 2	Sevilla		41092	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0	43000106			2057.000000	1.000000	2	30									inactive	B90380098
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 16	16	Solar Century Holdings Limited Sucursal en España ...	A40643975		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Paseo de la Alameda 4-1	Valencia		46010	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	2	30			A 40643975						inactive	A40643975
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 17	17	Guadalsolar Cuatro S.L.U (STATKRAFT)	B40546574		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Paseo Alameda 4-1	Valencia		46010	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	2	30									inactive	B40546574
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 18	18	Maragato Solar Uno SL. (STATKRAFT)	B40579567		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Paseo Alameda 4-1	Valencia		46010	209					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	2	30									inactive	B40579567
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 19	19	Geología MS Internacional SA de CV	NULL		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Av Viaducto Miguel Alemán Valdés nº189	Cuidad de México		11800	142					0	NULL	NULL	NULL	1	0	NULL	1	3		NULL	5	0	43000062			21726.400000	0.822810	1	30			Col Escandón I Sección, Alcaldía Miguel Hidalgo				México	FEDEX	inactive	NULL
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 20	20	EDF Renewables SA	FR379677636		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	Coeur Défense, Tour B, 100	Paris la Défense Cedex			76					0	NULL	NULL	NULL	2	0	NULL	1	3		NULL	NULL	0	43000087			6149.630000	1.000000	2	30			Esplanade du Général de Gaulle						inactive	FR379677636
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 21	21	GRS-Acciona-Ghella JV	100259616900003		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	DEWA III Solar Power Plant	Dubai			234					0	NULL	NULL	NULL	1	0	NULL	1	3		NULL	NULL	0				9157.620000	0.822810	2	30			Mohammed Bin Rashid Al-Maktoum Solar Park						inactive	100259616900003
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 22	22	Arenosas Solar SLU	B90337049		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	C/Pintor Sorolla 3, planta 10	Valencia		46003	0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	2	30									inactive	B90337049
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 23	23	Guita Solar Energy SLU	B40533754		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	C/Pintor Sorolla 3, planta 10. .	Valencia		46003	0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	2	30									inactive	B40533754
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 24	24	Malabrigo Solar SLU	B90337056		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	C/Pintor Sorolla 3. Planta 10	Valencia		46003	0					0	NULL	NULL	NULL	0	0	NULL	1	3		NULL	0	0				0.000000	0.000000	2	30									inactive	B90337056
Edit	Copy	Delete DELETE FROM tblclients WHERE `tblclients`.`userid` = 25	25	OPDE UK Ldt. [GBP] (OPDE)	GB312515346		0	NULL	NULL	NULL	NULL		2024-02-01 16:51:12	1	NULL	26-28 Hammersmith Grove	London		W6 7BA	235					0	NULL	NULL	NULL	3	0	NULL	1	3		NULL	NULL	0				0.000000	0.000000	2	30									inactive	GB312515346

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view