perfex.tail1f1784.ts.net / 127.0.0.1 / gms_dev_local / tblsuppliers_old

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

SELECT * FROM `tblsuppliers_old`

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

Filter rows:

			id	hash	datecreated	addedfrom	quality	name	company	firstname	lastname	email	website	phone	mobilephone	department	vatnumber	vattype	paymentmethod	currency	paymentterms	billingaddress	city	province	country	postalcode	shippingphone	shippingaddress	shippingcity	shippingprovince	shippingcountry	shippingpostalcode	invoice_phone
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 2	2	afba954c898b4ae66193af6e173a4526	2024-04-02 09:38:14	3	4	FERRETERIA INDUSTRIAL MATARO-92, S.L.	FERRETERIA INDUSTRIAL MATARO-92, S.L.								B60195534	IVA normal compras	0	EUR	Pagadero a la recepción	Carrasco y Formiguera, 23	Mataro	España	España	08302
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 3	3	f97ed2e77fe8bf66a46b99f3f100f578	2024-04-02 09:38:14	3	4	Asociación de Empresas de Energías Renovables (APP...	Asociación de Empresas de Energías Renovables			appa@appa.es					G58459322	IVA normal compras	30	EUR	Neto 30	Muntaner 248 1-1	Barcelona		España	08021							932419363
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 4	4	dfe5651d6a50a573880d8fcd74d3cefb	2024-04-02 09:38:14	3	4	Bavera Soluciones SL.	Bavera Soluciones SL.	Pablo	Bavera				+ 34 629 360 504		B66129438	IVA normal compras	30	EUR	Neto 30	Av. Meridiana 328 7-3	Barcelona		España	08027
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 5	5	9ea34fec2629943daa536137ccb004be	2024-04-02 09:38:14	3	4	Gabinet Soler i Associats SL	Gabinet Soler i Associats SL			gabinetsoler@gabinetsoler.com		+34 93 459 15 84			B58134115	IVA normal compras	30	EUR	Neto 30	C/Mallorca nr 272 4º 7ª	Barcelona		España	08037							+ 34 93 459 15 84
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 6	6	8aae272d11fcb13a922d8014870bc410	2024-04-02 09:38:14	3	4	Geosonda bvba	Geosonda bvba			info@geosonda.be					BE0452403644	IVA intracomunitario compras	30	EUR	Neto 30	Derbystaat 299	Sint-Denijs-Westrem		Belice	B-9051							+32 2 479 32 41
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 7	7	cb3593b4f1b43b6208b9d66a98a5b459	2024-04-02 09:38:14	3	4	Geotecnia i Control de Qualitat SA. (GCQ)	Geotecnia i Control de Qualitat SA.	Nuria	Codina	n.codina@gcq.es					A64067648	IVA normal compras	30	EUR	Neto 30	Berguedà 15 Bloc B Nau 11	Santa Perpètua de la Mogoda		España	08130
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 8	8	715d83615a2c9c1485fdaa286703cc92	2024-04-02 09:38:14	3	4	Internet Construdata21 SA	Internet Construdata21 SA								A36878205	IVA normal compras	30	EUR	Neto 30	López de Neura 3	Vigo		España	36202
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 9	9	59a49b725e6d06372b96002c3a2e3219	2024-04-02 09:38:14	3	4	Ramon Roger Riera Escat	Ramon Roger Riera Escat								46137298B	IVA normal compras	30	EUR	Neto 30	Francoli 53 2-2	Barcelona		España	08006
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 10	10	a169ae9f7dc0f6bf13d7df28382111b2	2024-04-02 09:38:14	3	4	Associació d'Enginyers Industrials de Catalunya	Associació d'Enginyers Industrials de Catalunya								G08398562	IVA normal compras	0	EUR	Pagadero a la recepción	Via Laietana, 39	Barcelona		España	08003
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 11	11	2d25d643d686e8f23e17b9e302e7abb5	2024-04-02 09:38:14	3	4	SISTAC ILS, S.L.	SISTAC ILS, S.L.								B53166419		0	EUR	Pagadero a la recepción	Roger de Flor, 138	Barcelona		España	08013
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 12	12	f1d304192e5cc8bb988a8b18ca5abddc	2024-04-02 09:38:14	3	4	MARCIL, S.A.	MARCIL, S.A.								A08510364	IVA normal compras	0	EUR	Pagadero a la recepción	Johann Sebastian Bach, 12	Barcelona		España	08021
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 13	13	e8bc6538b1e6729dba00d496c22bc311	2024-04-02 09:38:14	3	0	PROMOTORA INMOBILIARIA CALICAR, S.L.U.	PROMOTORA INMOBILIARIA CALICAR, S.L.U.						+ 34 608 39 39 88		B58318320	IVA normal compras	0	EUR	Pagadero a la recepción	Lepant, 364, Ent-2a	Barcelona		España	08025
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 14	14	b7773a3d03968bdb0e2169415b9e5cf0	2024-04-02 09:38:14	3	4	SECURITAS DIRECT ESPAÑA, SAU	SECURITAS DIRECT ESPAÑA, SAU								A26106013	IVA normal clientes	0	EUR	Pagadero a la recepción	Priégola, 2	Pozuelo de Alarcón	Madrid	España	28224
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 15	15	1ff7da6613ec89b1eb52440b4af33340	2024-04-02 09:38:14	3	4	JUAN PABLO SINGER	JUAN PABLO SINGER	JUAN PABLO	SINGER	jpsinger@gmsinternacional.com		+34629762763			44006449C		0	EUR	Pagadero a la recepción		Barcelona	Barcelona	España	08030			Barcelona	Barcelona	España	08030
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 16	16	944b74000d8fa7d859e1ad038dd9a9cb	2024-04-02 09:38:14	3	4	JUAN MANUEL GARCIA RIVAS	JUAN MANUEL GARCIA RIVAS								31698777Q		0	EUR	Pagadero a la recepción
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 17	17	a4eb0f289e317a5cb144ba4555dfa733	2024-04-02 09:38:14	3	4	Banco de Sabadell, S.A.	Banco de Sabadell, S.A.								A08000143		0	EUR	Pagadero a la recepción	Óscar Esplá, 37	Alicante	Alicante	España	03007
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 18	18	5774519e6083b3a5d7d97e11ad249be3	2024-04-02 09:38:14	3	4	Vodafone Servicios, S.L.U.	Vodafone Servicios, S.L.U.								B87539284		0	EUR	Pagadero a la recepción	Av. America, 15	Madrid	Madrid	España	28042
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 19	19	98cf419b7a760de6c6dcdcec5b50865c	2024-04-02 09:38:14	3	4	Radio Carrera, S.A.	Radio Carrera, S.A.								A08827735		0	EUR	Pagadero a la recepción	Canigó, 20	Manlleu	Barcelona	España	08560
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 20	20	ee3e40a30e738a1d0673dff5b8876155	2024-04-02 09:38:14	3	4	Hotel Brasa - Empreedim Turisticos, LDA	Hotel Brasa - Empreedim Turisticos, LDA								PT502197382		0	EUR	Pagadero a la recepción	Av. do Dia Portugal, 80	Elvas	Portugal	Portugal	7350-229
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 21	21	267ecc48ea829206df60d9a85ad10c77	2024-04-02 09:38:14	3	4	Centauro Rent a Car, S.L.U.	Centauro Rent a Car, S.L.U.								B03965506		0	EUR	Pagadero a la recepción	Av. País Valencià, 9	Finestrat	Alicante	España	03509
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 22	22	aa55c7b8525b6f7598c62ac9da5f666a	2024-04-02 09:38:14	3	4	Repsol Comercial de Productos Petroliferos, S.A.	Repsol Comercial de Productos Petroliferos, S.A.								A80298839		0	EUR	Pagadero a la recepción	Méndez Alvaro, 44	Madrid	Madrid	España	28045
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 23	23	4b4a4ff80897bc76e6bd5562c01ab9de	2024-04-02 09:38:14	3	4	Antonio Aguilar Rios, S.A.	Antonio Aguilar Rios, S.A.								A14026884		0	EUR	Pagadero a la recepción	Reyes Católicos, 3, 3º	Cordoba		España	14001
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 24	24	09a4ba044a4f4750974828450a084615	2024-04-02 09:38:14	3	4	Cia. Española Dist Petroleos, S.A	Cia. Española Dist Petroleos, S.A								A28354520		0	EUR	Pagadero a la recepción	Paseo de la Castellana, 259	Madrid		España	28046
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 25	25	6867d0beeb5e455824c33a38c270685f	2024-04-02 09:38:14	3	4	TOTENCOM CATALUNYA, S.L.U.	TOTENCOM CATALUNYA, S.L.U.	Andrea	González	admin@totencom.com		+34 902 11 21 32	+34 93 570 34 66		B17733866		0	EUR	Pagadero a la recepción	Can Pantiquet, 83, 1er	Mollet del Vallès	Barcelona	España	08100
Edit	Copy	Delete DELETE FROM tblsuppliers_old WHERE `tblsuppliers_old`.`id` = 26	26	6ab3a264e17c26aef0a131d30552531e	2024-04-02 09:38:14	3	4	SIS Prevenció	SIS Prevenció								B63607501		0	EUR	Pagadero a la recepción	Sant Ponç, 2, local 1	Les Franqueses del Vallès	Barcelona	España	08520

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view