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

`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 :

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

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 seconds.)

SELECT * FROM `ot3`

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

				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

Query results operations

Create view