Recent
`performance_schema`.`setup_actors`
`performance_schema`.`setup_timers`
`information_schema`.`SQL_FUNCTIONS`
`performance_schema`.`host_cache`
`performance_schema`.`setup_consumers`
`information_schema`.`PROCESSLIST`
`mysql`.`plugin`
`performance_schema`.`socket_instances`
`mysql`.`proc`
`performance_schema`.`users`
Favorites
There are no favorite tables.
New
2025
a1distri
articulos
articulos2
ejose
factelhomo
factuc9j
factzt2
hat
history
information_schema
mysql
ot2
performance_schema
phpmyadmin
proquifar
sisupieras
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: a1distri
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
articuloId
articulodesc
linea
marca
proveedor
usuario
fecha_carga
desactivado
informacion
*
idprecio
articuloid
cont
3c
6c
8c
10c
12c
Fecha
usuario
*
imagenId
articuloId
archivo
descripcion
principal
fecha_alta
usuario_alta
fecha_modificacion
usuario_modificacion
*
Deposito
DepositoD
activo
*
Destino
DestinoD
activo
*
movimientoId
unidadId
articuloId
tipo
deposito_origen
deposito_destino
destino_baja
fecha
usuario
observaciones
*
unidadId
articuloId
numero_serie
origen
deposito
estado
destino_baja
fecha_alta
usuario_alta
*
Linea
LineaD
*
Marca
MarcaD
*
id_prov
razon
contacto
tel
domicilio
cp
localidad
pcia
wp
mail
web
*
id_banco
codigo
nombre
*
id_cheque
num_cheque
banco_emisor
titular_cuit
titular_nombre
endosante_cuit
endosante_nombre
fecha_emision
fecha_cobro
importe
estado
observaciones
fecha_recepcion
*
id_cliente
mension
nom_cliente
referencia
tel_cliente
tel2_cliente
sexo
dni
cuit
domicilio
entrec
localidad
cp
emailc
razon
domi_fis
cfai
notac
saldo_inicial
*
id_compra
fechac
fact_num
tipo_fact
id_prov
sub_total
iva
per_iva
iibb
total
estado
notafc
id_user
fc_link
fc_pag
*
id_compras_det
id_compra
codigo
id_prod
descrip
pre_uni
id_costo
cant
kgs
alic_iva
descuento
importe
id_lote
*
id_concept
concepto
*
id_costo
id_prod
id_prov
costo
utilidad
fecha
id_user
*
id_cost_hist
id_prod
id_prov
costo
utilidad
fecha
id_user
*
id_familia
familia
*
id_gal
id_prod
imagen
*
id_imputacion
id_pago
id_venta
importe
automatica
fecha
id_user
*
id_marca
marca
*
id_moneda
moneda
*
id_pago
id_cliente
id_venta
importe
id_tpago
id_concept
id_moneda
tcambio
pago
saldo
acuenta
fechaP
id_user
id_cheque
nota_pago
*
id_borrado
id_pago
id_cliente
nom_cliente
id_venta
importe
fechaP
id_tpago
tpago
id_concept
concepto
id_moneda
tcambio
nota_pago
imputaciones_json
motivo
id_user_borra
nom_user_borra
fecha_borrado
*
id_rol
modulo
ver
crear
editar
eliminar
*
id_prod
codigo
id_prov
id_familia
id_marca
imagen
detalle
notapr
user
*
id_prov
nom_prov
domicilio
entrec
localidad
telefono
wp
contacto
emailp
fech_prov
cuit
web
datobco
notap
*
id_tpago
tpago
*
id_rol
nombre
es_admin
activo
fecha_creacion
*
id_stock
id_prod
cant_stock
*
id_stock_det
id_stock
id_prod
stock_actual
cant_stock_det
id_fact
tipo_f
comprobante
fecha_det
id_user
esta
nota_stk
*
id_user
nom_user
pass
nivel_us
fecha_cre
*
id_usuario
username
password
id_rol
nombre_completo
activo
fecha_creacion
*
id_venta
fechav
fact_num
id_cliente
detallev
total
saldov
estado
notav
id_user
pago_est
saldo_inicial_sumado
printed
*
id_ventas_det
id_venta
id_cliente
id_prov
id_familia
id_prod
cant
descrip
costo
precio
importe
fecha_det
chek
notavtapr
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
art-articulos
art-precio2
art_imagenes
inv_depositos
inv_destinos_baja
inv_movimientos
inv_unidades
mlineas
mmarcas
m_prov
tb_bcos
tb_cheques_terceros
tb_clientes
tb_compras
tb_compras_det
tb_concept_pago
tb_costos
tb_cost_hist
tb_familia
tb_galeria
tb_imputaciones
tb_marcas
tb_moneda
tb_pagos
tb_pagos_borrados
tb_permisos
tb_prod
tb_prov
tb_refpago
tb_roles
tb_stock
tb_stock_det
tb_user
tb_usuarios
tb_ventas
tb_ventas_det
.
select column