desktop-pb00esf.tail37de6a.ts.net / 127.0.0.1 / recargas / gcc

`recargas`.`gcc`

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 :

Do a "query by example" (wildcard: "%")

Column	Type	Collation
codigo	char(5)	utf8_general_ci
nombre	char(50)	utf8_general_ci
codcon	char(20)	utf8_general_ci
cedula	char(15)	utf8_general_ci
apel_pater	char(15)	utf8_general_ci
apel_mater	char(15)	utf8_general_ci
nombres	char(20)	utf8_general_ci
razon	char(50)	utf8_general_ci
ruc	char(15)	utf8_general_ci
sexo	bit(1)
estado	char(10)	utf8_general_ci
empresa	char(35)	utf8_general_ci
pais	char(10)	utf8_general_ci
ocupacion	char(15)	utf8_general_ci
conyuge	char(36)	utf8_general_ci
cedula_con	char(15)	utf8_general_ci
ciudad	char(20)	utf8_general_ci
zona	char(5)	utf8_general_ci
direcc	char(36)	utf8_general_ci
direcc2	char(36)	utf8_general_ci
telefono	char(20)	utf8_general_ci
fax	char(10)	utf8_general_ci
observ	char(60)	utf8_general_ci
observ2	char(60)	utf8_general_ci
limite	double(8,5)
plazo	double(8,5)
forma_pago	char(12)	utf8_general_ci
saldo	double(8,5)
activo	bit(1)
chepro	double(8,5)
tipo	char(1)	utf8_general_ci
cargo	char(15)	utf8_general_ci
direcc_emp	char(35)	utf8_general_ci
telefo_emp	char(10)	utf8_general_ci
fecha_insc	date
tarifa	double(8,5)
afiliado	bit(1)
tarjeta	char(10)	utf8_general_ci
integrado	bit(1)
enviado	bit(1)
gafsa	bit(1)
notinfpro	double(8,5)
clinica	bit(1)
pordesadi	double(8,5)
fecha_ingr	date
circuito	double(8,5)
cupo	double(8,5)
casa	date
transporte	bit(1)
genero	char(1)	utf8_general_ci
fecha_naci	date
nombre_par	char(36)	utf8_general_ci
pariente	char(15)	utf8_general_ci
direcc_par	char(36)	utf8_general_ci
telefo_par	char(15)	utf8_general_ci
iess	char(15)	utf8_general_ci
consultas	double(8,5)
emplidjef	char(10)	utf8_general_ci
jefe	char(5)	utf8_general_ci
lide	char(5)	utf8_general_ci
refe	char(5)	utf8_general_ci
des_lide	double(8,5)
des_jefe	double(8,5)
des_refe	double(8,5)
celular	char(9)	utf8_general_ci
email	char(245)	utf8_general_ci
contacto	char(36)	utf8_general_ci
plazo_real	double(8,5)
direcc3	char(50)	utf8_general_ci
direcc4	char(50)	utf8_general_ci
direcc5	char(50)	utf8_general_ci
matricula	double(8,5)
fecha_nac	date
transp	bit(1)
lejano	bit(1)
con_vive	char(36)	utf8_general_ci
pad_viajan	bit(1)
env_sino	bit(1)
opera	char(5)	utf8_general_ci
digitado	date
lugar_nac	char(15)	utf8_general_ci
barrio	char(15)	utf8_general_ci
religion	char(15)	utf8_general_ci
par_vive	char(10)	utf8_general_ci
per_financ	char(36)	utf8_general_ci
cua_tiempo	double(8,5)
cuanto	double(8,5)
siglas	char(15)	utf8_general_ci
vendedor	char(5)	utf8_general_ci
mens_pen_c	char(15)	utf8_general_ci
mens_tra_c	char(15)	utf8_general_ci
mens_ali_c	char(15)	utf8_general_ci
mens_var_c	char(15)	utf8_general_ci
mens_pen_p	double(8,5)
mens_tra_p	double(8,5)
mens_ali_p	double(8,5)
mens_var_p	double(8,5)
mens_pen_d	double(8,5)
mens_tra_d	double(8,5)
mens_ali_d	double(8,5)
mens_var_d	double(8,5)
tarc_num	double(8,5)
tarc_fec	char(6)	utf8_general_ci
tarc_emi	char(15)	utf8_general_ci
tarc_cod	double(8,5)
cecorcli	char(60)	utf8_general_ci
pag1cod	char(13)	utf8_general_ci
pag1por	double(8,5)
pag2cod	char(13)	utf8_general_ci
pag2por	double(8,5)
ret1_ced	char(10)	utf8_general_ci
ret1_nom	char(45)	utf8_general_ci
ret2_ced	char(10)	utf8_general_ci
ret2_nom	char(45)	utf8_general_ci
ret3_ced	char(10)	utf8_general_ci
ret3_nom	char(45)	utf8_general_ci
ret4_ced	char(10)	utf8_general_ci
ret4_nom	char(45)	utf8_general_ci
ret5_ced	char(10)	utf8_general_ci
ret5_nom	char(45)	utf8_general_ci

Select columns (at least one):

DISTINCT

Or Add search conditions (body of the "where" clause):

Number of rows per page

Order by:

Ascending

Descending

codigo
nombre
codcon
cedula
apel_pater
apel_mater
nombres
razon
ruc
sexo
estado
empresa
pais
ocupacion
conyuge
cedula_con
ciudad
zona
direcc
direcc2
telefono
fax
observ
observ2
limite
plazo
forma_pago
saldo
activo
chepro
tipo
cargo
direcc_emp
telefo_emp
fecha_insc
tarifa
afiliado
tarjeta
integrado
enviado
gafsa
notinfpro
clinica
pordesadi
fecha_ingr
circuito
cupo
casa
transporte
genero
fecha_naci
nombre_par
pariente
direcc_par
telefo_par
iess
consultas
emplidjef
jefe
lide
refe
des_lide
des_jefe
des_refe
celular
email
contacto
plazo_real
direcc3
direcc4
direcc5
matricula
fecha_nac
transp
lejano
con_vive
pad_viajan
env_sino
opera
digitado
lugar_nac
barrio
religion
par_vive
per_financ
cua_tiempo
cuanto
siglas
vendedor
mens_pen_c
mens_tra_c
mens_ali_c
mens_var_c
mens_pen_p
mens_tra_p
mens_ali_p
mens_var_p
mens_pen_d
mens_tra_d
mens_ali_d
mens_var_d
tarc_num
tarc_fec
tarc_emi
tarc_cod
cecorcli
pag1cod
pag1por
pag2cod
pag2por
ret1_ced
ret1_nom
ret2_ced
ret2_nom
ret3_ced
ret3_nom
ret4_ced
ret4_nom
ret5_ced
ret5_nom