desktop-pb00esf.tail37de6a.ts.net / 127.0.0.1 / egsystemit_acsuin / ot3

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
secuencial	int(11)
fecha	datetime
num_orden	int(11)
orden_trabajo	varchar(50)	utf8_general_ci
responsable	varchar(50)	utf8_general_ci
cliente	varchar(50)	utf8_general_ci
placa	varchar(50)	utf8_general_ci
aseguradora	varchar(50)	utf8_general_ci
marca	varchar(50)	utf8_general_ci
modelo	varchar(50)	utf8_general_ci
tamaño	varchar(50)	utf8_general_ci
npiezas	int(11)
porcentaje_daño	varchar(50)	utf8_general_ci
estado_orden	varchar(50)	utf8_general_ci
D1	varchar(50)	utf8_general_ci
PRESENT_D1	int(11)
COSTO_D1	float
PESO_D1	float
REND_D1	float
CUSADAL_D1	float
CUSADAG_D1	float
COSTOR_D1	float
MD	varchar(50)	utf8_general_ci
PRESENT_MD	varchar(50)	utf8_general_ci
COSTO_MD	float
PESO_MD	float
REND_MD	float
CUSADAL_MD	float
CUSADAG_MD	float
CATALIZACION_MD	int(11)
COSTOR_MD	float
CATMD	varchar(50)	utf8_general_ci
PRESENT_CATMD	varchar(50)	utf8_general_ci
COSTO_CATMD	float
PESO_CATMD	float
REND_CATMD	float
CUSADAL_CATMD	float
CUSADAG_CATMD	float
COSTOR_CATMD	float
FIPLAS	varchar(50)	utf8_general_ci
PESO_FIPLAS	float
PRESENT_FIPLAS	float
COSTO_FIPLAS	float
REND_FIPLAS	float
CUSADAL_FIPLAS	float
CUSADAG_FIPLAS	float
COSTOR_FIPLAS	float
FI	varchar(50)	utf8_general_ci
PESO_FI	float
PRESENT_FI	float
COSTO_FI	float
REND_FI	float
CUSADAL_FI	float
CUSADAG_FI	float
CATALIZACION_FI	varchar(3)	utf8_general_ci
PORCTHI_FI	int(11)
COSTOR_FI	float
CATFI	varchar(50)	utf8_general_ci
PESO_CATFI	float
PRESENT_CATFI	float
COSTO_CATFI	float
REND_CATFI	float
CUSADAL_CATFI	float
CUSADAG_CATFI	float
COSTOR_CATFI	float
THIFI	varchar(50)	utf8_general_ci
PESO_THIFI	float
PRESENT_THIFI	float
COSTO_THIFI	float
REND_THIFI	float
CUSADAL_THIFI	float
CUSADAG_THIFI	float
COSTOR_THIFI	float
FR	varchar(50)	utf8_general_ci
PESO_FR	float
PRESENT_FR	float
COSTO_FR	float
REND_FR	float
CUSADAL_FR	float
CUSADAG_FR	float
CATALIZACION_FR	varchar(3)	utf8_general_ci
PORCTHI_FIR	int(11)
COSTOR_FR	float
CATFR	varchar(50)	utf8_general_ci
PRESENT_CATFR	float
PESO_CATFR	float
COSTO_CATFR	float
REND_CATFR	float
CUSADAL_CATFR	float
CUSADAG_CATFR	float
COSTOR_CATFR	float
THIFR	varchar(50)	utf8_general_ci
PRESENT_THIFR	float
PESO_THIFR	float
COSTO_THIFR	float
REND_THIFR	float
CUSADAL_THIFR	float
CUSADAG_THIFR	float
COSTOR_THIFR	float
D2	varchar(50)	utf8_general_ci
PRESENT_D2	float
PESO_D2	float
COSTO_D2	float
REND_D2	float
CUSADAL_D2	float
CUSADAG_D2	float
COSTOR_D2	float
COLOR	varchar(50)	utf8_general_ci
PRESENT_COLOR	float
PESO_COLOR	float
COSTO_COLOR	float
REND_COLOR	float
CUSADAL_COLOR	float
CUSADAG_COLOR	float
COSTOR_COLOR	float
LINEA_COLOR	varchar(2)	utf8_general_ci
TIPO_COLOR	varchar(10)	utf8_general_ci
SUBTIPO_COLOR	varchar(50)	utf8_general_ci
CATALIZACION_COLOR	varchar(3)	utf8_general_ci
PORCTHI_COLOR	int(11)
CATCOLOR	varchar(50)	utf8_general_ci
PRESENT_CATCOLOR	float
PESO_CATCOLOR	float
COSTO_CATCOLOR	float
REND_CATCOLOR	float
CUSADAL_CATCOLOR	float
CUSADAG_CATCOLOR	float
COSTOR_CATCOLOR	float
THICOLOR	varchar(50)	utf8_general_ci
PRESENT_THICOLOR	float
PESO_THICOLOR	float
COSTO_THICOLOR	float
REND_THICOLOR	float
CUSADAL_THICOLOR	float
CUSADAG_THICOLOR	float
COSTOR_THICOLOR	float
BARNIZ	varchar(50)	utf8_general_ci
PRESENT_BARNIZ	float
PESO_BARNIZ	float
COSTO_BARNIZ	float
REND_BARNIZ	float
CUSADAL_BARNIZ	float
CUSADAG_BARNIZ	float
CATALIZACION_BARNIZ	varchar(3)	utf8_general_ci
PORCTHI_BARNIZ	int(11)
COSTOR_BARNIZ	float
CATBARNIZ	varchar(50)	utf8_general_ci
PRESENT_CATBARNIZ	float
PESO_CATBARNIZ	float
COSTO_CATBARNIZ	float
REND_CATBARNIZ	float
CUSADAL_CATBARNIZ	float
CUSADAG_CATBARNIZ	float
COSTOR_CATBARNIZ	float
THIBARNIZ	varchar(50)	utf8_general_ci
PRESENT_THIBARNIZ	float
PESO_THIBARNIZ	float
COSTO_THIBARNIZ	float
REND_THIBARNIZ	float
CUSADAL_THIBARNIZ	float
CUSADAG_THIBARNIZ	float
COSTOR_THIBARNIZ	float
PULIDO	varchar(50)	utf8_general_ci
PRESENT_PULIDO	float
PESO_PULIDO	float
COSTO_PULIDO	float
REND_PULIDO	float
CUSADAL_PULIDO	float
CUSADAG_PULIDO	float
COSTOR_PULIDO	float
ABRILL	varchar(50)	utf8_general_ci
PRESENT_ABRILL	float
PESO_ABRILL	float
COSTO_ABRILL	float
REND_ABRILL	float
CUSADAL_ABRILL	float
CUSADAG_ABRILL	float
COSTOR_ABRILL	float
PROTEC	varchar(50)	utf8_general_ci
PRESENT_PROTEC	float
PESO_PROTEC	float
COSTO_PROTEC	float
REND_PROTEC	float
CUSADAL_PROTEC	float
CUSADAG_PROTEC	float
COSTOR_PROTEC	float
total_costocomp	float
num_piezas	int(11)
area_total	float
horas_hombre	float
costo_hora_hombre	float
porc_depre_equipos	int(11)
observaciones	mediumtext	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

secuencial
fecha
num_orden
orden_trabajo
responsable
cliente
placa
aseguradora
marca
modelo
tamaño
npiezas
porcentaje_daño
estado_orden
D1
PRESENT_D1
COSTO_D1
PESO_D1
REND_D1
CUSADAL_D1
CUSADAG_D1
COSTOR_D1
MD
PRESENT_MD
COSTO_MD
PESO_MD
REND_MD
CUSADAL_MD
CUSADAG_MD
CATALIZACION_MD
COSTOR_MD
CATMD
PRESENT_CATMD
COSTO_CATMD
PESO_CATMD
REND_CATMD
CUSADAL_CATMD
CUSADAG_CATMD
COSTOR_CATMD
FIPLAS
PESO_FIPLAS
PRESENT_FIPLAS
COSTO_FIPLAS
REND_FIPLAS
CUSADAL_FIPLAS
CUSADAG_FIPLAS
COSTOR_FIPLAS
FI
PESO_FI
PRESENT_FI
COSTO_FI
REND_FI
CUSADAL_FI
CUSADAG_FI
CATALIZACION_FI
PORCTHI_FI
COSTOR_FI
CATFI
PESO_CATFI
PRESENT_CATFI
COSTO_CATFI
REND_CATFI
CUSADAL_CATFI
CUSADAG_CATFI
COSTOR_CATFI
THIFI
PESO_THIFI
PRESENT_THIFI
COSTO_THIFI
REND_THIFI
CUSADAL_THIFI
CUSADAG_THIFI
COSTOR_THIFI
FR
PESO_FR
PRESENT_FR
COSTO_FR
REND_FR
CUSADAL_FR
CUSADAG_FR
CATALIZACION_FR
PORCTHI_FIR
COSTOR_FR
CATFR
PRESENT_CATFR
PESO_CATFR
COSTO_CATFR
REND_CATFR
CUSADAL_CATFR
CUSADAG_CATFR
COSTOR_CATFR
THIFR
PRESENT_THIFR
PESO_THIFR
COSTO_THIFR
REND_THIFR
CUSADAL_THIFR
CUSADAG_THIFR
COSTOR_THIFR
D2
PRESENT_D2
PESO_D2
COSTO_D2
REND_D2
CUSADAL_D2
CUSADAG_D2
COSTOR_D2
COLOR
PRESENT_COLOR
PESO_COLOR
COSTO_COLOR
REND_COLOR
CUSADAL_COLOR
CUSADAG_COLOR
COSTOR_COLOR
LINEA_COLOR
TIPO_COLOR
SUBTIPO_COLOR
CATALIZACION_COLOR
PORCTHI_COLOR
CATCOLOR
PRESENT_CATCOLOR
PESO_CATCOLOR
COSTO_CATCOLOR
REND_CATCOLOR
CUSADAL_CATCOLOR
CUSADAG_CATCOLOR
COSTOR_CATCOLOR
THICOLOR
PRESENT_THICOLOR
PESO_THICOLOR
COSTO_THICOLOR
REND_THICOLOR
CUSADAL_THICOLOR
CUSADAG_THICOLOR
COSTOR_THICOLOR
BARNIZ
PRESENT_BARNIZ
PESO_BARNIZ
COSTO_BARNIZ
REND_BARNIZ
CUSADAL_BARNIZ
CUSADAG_BARNIZ
CATALIZACION_BARNIZ
PORCTHI_BARNIZ
COSTOR_BARNIZ
CATBARNIZ
PRESENT_CATBARNIZ
PESO_CATBARNIZ
COSTO_CATBARNIZ
REND_CATBARNIZ
CUSADAL_CATBARNIZ
CUSADAG_CATBARNIZ
COSTOR_CATBARNIZ
THIBARNIZ
PRESENT_THIBARNIZ
PESO_THIBARNIZ
COSTO_THIBARNIZ
REND_THIBARNIZ
CUSADAL_THIBARNIZ
CUSADAG_THIBARNIZ
COSTOR_THIBARNIZ
PULIDO
PRESENT_PULIDO
PESO_PULIDO
COSTO_PULIDO
REND_PULIDO
CUSADAL_PULIDO
CUSADAG_PULIDO
COSTOR_PULIDO
ABRILL
PRESENT_ABRILL
PESO_ABRILL
COSTO_ABRILL
REND_ABRILL
CUSADAL_ABRILL
CUSADAG_ABRILL
COSTOR_ABRILL
PROTEC
PRESENT_PROTEC
PESO_PROTEC
COSTO_PROTEC
REND_PROTEC
CUSADAL_PROTEC
CUSADAG_PROTEC
COSTOR_PROTEC
total_costocomp
num_piezas
area_total
horas_hombre
costo_hora_hombre
porc_depre_equipos
observaciones