Recent
`db_bar`.`produccion_insumos_consumidos`
`asociacion_cge`.`asientos_contables_bkp_0708_232726`
`db_restaurante`.`ordenes_produccion`
`asociacion_cge`.`depositos_bancarios`
`db_panaderia`.`insumos_por_unidad`
`asociacion_cge`.`plan_cuentas`
`asociacion_cge`.`auditoria_sistema`
`db_qa_test`.`produccion_insumos_consumidos`
`asociacion_cge`.`cartera_proveedores`
`db_bar`.`insumos_por_unidad`
Favorites
There are no favorite tables.
New
acsuin
acsuin
acsuin_v2
almuerzos_kepler
asociacion_cge
central_remates
consulta
creador_agentes
db
db_bar
db_panaderia
db_puente_bodega
db_qa_test
db_restaurante
egsystem
egsystemit_acsuin
eva_sistema
information_schema
mediacion_db
mysql
performance_schema
petshop
phpmyadmin
prestashop
recargas
seeddms
sistema_escolar_ia
sms
test
videoforge
wp
wp_mediacion
wp_medicacion
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: db_bar
Table: produccion_insumos_consumidos
Browse
Structure
SQL
Search
(current)
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
Table search
Zoom search
Find and replace
Do a "query by example" (wildcard: "%")
Column
Type
Collation
Operator
Value
id
bigint(20)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
orden_produccion_id
bigint(20)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Browse foreign values
insumo_id
int(10)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
ab001 - 3
ab002 - 4
ab003 - 5
ab004 - 6
ab005 - 7
ab006 - 8
ab007 - 9
ab008 - 10
ab009 - 11
ab010 - 12
ab011 - 13
ab012 - 14
ab013 - 15
ab014 - 16
ab015 - 17
ab016 - 18
ab017 - 19
ab018 - 20
ab019 - 21
ab020 - 22
ab021 - 23
be001 - 24
be002 - 25
be003 - 26
be004 - 27
be005 - 28
be006 - 29
be007 - 30
be008 - 31
be009 - 32
be010 - 33
be011 - 34
be012 - 35
be013 - 36
be014 - 37
be015 - 38
be016 - 39
be017 - 40
be018 - 41
be019 - 42
ca001 - 43
ca002 - 44
em001 - 45
em002 - 46
em003 - 47
la001 - 48
la002 - 49
la003 - 50
la004 - 51
la005 - 52
pa001 - 53
pa002 - 54
pa003 - 55
sn001 - 56
sn002 - 57
sn003 - 58
sn004 - 59
sn005 - 60
sn006 - 61
sn007 - 62
sn008 - 63
sn009 - 64
sn010 - 65
sn011 - 66
sn012 - 67
sn013 - 68
sn014 - 69
ve001 - 70
ve002 - 71
ve003 - 72
ve004 - 73
ve005 - 74
ve006 - 75
ve007 - 76
ve008 - 77
ve009 - 78
ve010 - 79
ve011 - 80
ve012 - 81
ve013 - 82
ve014 - 83
ve015 - 84
ve016 - 85
ve017 - 86
ve018 - 87
ve019 - 88
ve020 - 89
ve021 - 90
3 - ab001
4 - ab002
5 - ab003
6 - ab004
7 - ab005
8 - ab006
9 - ab007
10 - ab008
11 - ab009
12 - ab010
13 - ab011
14 - ab012
15 - ab013
16 - ab014
17 - ab015
18 - ab016
19 - ab017
20 - ab018
21 - ab019
22 - ab020
23 - ab021
24 - be001
25 - be002
26 - be003
27 - be004
28 - be005
29 - be006
30 - be007
31 - be008
32 - be009
33 - be010
34 - be011
35 - be012
36 - be013
37 - be014
38 - be015
39 - be016
40 - be017
41 - be018
42 - be019
43 - ca001
44 - ca002
45 - em001
46 - em002
47 - em003
48 - la001
49 - la002
50 - la003
51 - la004
52 - la005
53 - pa001
54 - pa002
55 - pa003
56 - sn001
57 - sn002
58 - sn003
59 - sn004
60 - sn005
61 - sn006
62 - sn007
63 - sn008
64 - sn009
65 - sn010
66 - sn011
67 - sn012
68 - sn013
69 - sn014
70 - ve001
71 - ve002
72 - ve003
73 - ve004
74 - ve005
75 - ve006
76 - ve007
77 - ve008
78 - ve009
79 - ve010
80 - ve011
81 - ve012
82 - ve013
83 - ve014
84 - ve015
85 - ve016
86 - ve017
87 - ve018
88 - ve019
89 - ve020
90 - ve021
cantidad_teorica_receta
decimal(14,4)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
cantidad_real_utilizada
decimal(14,4)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
costo_unitario_aplicado
decimal(16,6)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
costo_total
decimal(14,4)
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Extra options
Select columns (at least one):
id
orden_produccion_id
insumo_id
cantidad_teorica_receta
cantidad_real_utilizada
costo_unitario_aplicado
costo_total
DISTINCT
Or
Add search conditions (body of the "where" clause):
Number of rows per page
Display order:
Order by:
id
orden_produccion_id
insumo_id
cantidad_teorica_receta
cantidad_real_utilizada
costo_unitario_aplicado
costo_total
Ascending
Descending
Range search
Minimum value:
Maximum value: