Recent
`acsuin`.`ot3`
`information_schema`.`SESSION_VARIABLES`
`prestashop`.`q2duq_hook_alias`
`creador_agentes`.`bloqueos_ip`
`egsystemit_acsuin`.`dtproperties`
`information_schema`.`INNODB_FT_CONFIG`
`acsuin`.`responsable`
`information_schema`.`COLLATIONS`
`acsuin`.`dtproperties`
`egsystemit_acsuin`.`principal`
Favorites
There are no favorite tables.
New
acsuin
almuerzos_kepler
asociacion_cge
central_remates
creador_agentes
egsystemit_acsuin
eva_sistema
information_schema
mysql
performance_schema
phpmyadmin
prestashop
recargas
seeddms
sistema_escolar_ia
sms
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: acsuin
Table: ot3
Browse
Structure
SQL
(current)
Search
Insert
Export
Import
Privileges
Operations
Triggers
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
SQL queries
SQL Query box
SQL queries
SQL queries settings.
SQL queries
Show SQL queries
Defines whether SQL queries generated by phpMyAdmin should be displayed.
Confirm DROP queries
Whether a warning ("Are your really sure…") should be displayed when you're about to lose data.
Query history length
How many queries are kept in history.
Ignore multiple statement errors
If enabled, phpMyAdmin continues computing multiple-statement queries even if one of the queries failed.
Maximum displayed SQL length
Maximum number of characters used when a SQL query is displayed.
Retain query box
Defines whether the query box should stay on-screen after its submission.
Enable CodeMirror
Use user-friendly editor for editing SQL queries (CodeMirror) with syntax highlighting and line numbers.
Enable linter
Find any errors in the query before executing it. Requires CodeMirror to be enabled.
Enable autocomplete for table and column names
Autocomplete of the table and column names in the SQL queries.
Foreign key checks
Default value for foreign key checks checkbox for some queries.
Server default
Enable
Disable
SQL Query box
Customize links shown in SQL Query boxes.
SQL Query box
Edit
Explain SQL
Create PHP code
Refresh
Run SQL query/queries on table
acsuin.ot3
:
SELECT * FROM `ot3` WHERE 1
Bind parameters
Columns
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
Simulate query