Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `tb_grupos`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id nomenclatura plantel ciclo periodo departamento plan seccion grado frecuencia grupo asignatura consecutivo organizacion local_org id_profesor id_coordinador horas_presupuestadas horas_consumidas hora_factor_grupo fecha_inicio centro_costos fecha_fin autorizado_escolar estatus_grupo enabled id_modeval promedio_grupo total_inscritos promedio_asistencia avance_califas duracion_sesion dias_clase hora_inicio id_salon id_plan_estudio id_nivel pvp
precio venta publico
clasif_poblacion link_clase tipo_grupo
regular, empresa, injuve
id_sponsor
FK tb_sponsors si tipo_grupo=empresa
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 1
1 CE.2024B01.ADAB01PR01.LJ07A CE 2024 B01 AD AB01 NULL NULL LJ07 A PR01 NULL IMN 00 11 55 30.00 22.00 1 2024-01-08 NULL 2024-02-22 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 1 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 2
2 CE.2024B01.ADAB4EL1.LJ07A CE 2024 B01 AD AB NULL 4 LJ07 A EL 1 IMN 00 0 NULL 30.00 0.00 1 2024-01-08 NULL 2024-02-22 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 1 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 3
3 CE.2024B01.ADAB05EL02.LJ07A CE 2024 B01 AD AB05 NULL NULL LJ07 A EL02 NULL IMN 00 72 55 30.00 26.00 1 2024-01-08 NULL 2024-02-22 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 5 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 4
4 CE.2024M01.ADAB1PR1.PERSZ CE 2024 M01 AD AB NULL 1 PERS Z PR 1 IMN 00 0 NULL 30.00 0.00 1 2024-01-08 NULL 2024-01-30 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 1 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 5
5 CE.2024M01.ADAB4EL1.PERSZ CE 2024 M01 AD AB NULL 4 PERS Z EL 1 IMN 00 0 NULL 30.00 0.00 1 2024-01-08 NULL 2024-01-30 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 1 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 6
6 LI.2024M01.SPTI01TI01.LJ19A LI 2024 M01 SP TI01 NULL NULL LJ19 A TI01 NULL IMN 00 32 NULL 30.00 0.00 1 2024-01-08 NULL 2024-01-30 1 NULL 0 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL NULL NULL 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 7
7 LI.2024M01.SPTI01TI01.LJ19Z LI 2024 M01 SP TI01 NULL NULL LJ19 Z TI01 NULL IMN 00 32 76 30.00 24.60 1 2024-01-08 NULL 2024-01-30 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL NULL NULL 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 8
8 CE.2024B01.ADAB01PR01.LM10A CE 2024 B01 AD AB01 NULL NULL LM10 A PR01 NULL IMN 00 11 55 30.00 20.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 1 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 9
9 CE.2024B01.ADAB01PR01.LM19A CE 2024 B01 AD AB01 NULL NULL LM19 A PR01 NULL IMN 00 82 55 30.00 24.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 1 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 10
10 CE.2024B01.ADAB02PR02.LM10A CE 2024 B01 AD AB02 NULL NULL LM10 A PR02 NULL IMN 00 72 55 30.00 29.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 2 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 11
11 CE.2024B01.ADAB02PR02.LM19A CE 2024 B01 AD AB02 NULL NULL LM19 A PR02 NULL IMN 00 11 55 30.00 20.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 2 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 12
12 CE.2024B01.ADULTOS4.LM19 CE 2024 B01 AD AB04 NULL NULL LM19 A EL01 NULL IMN 00 114 55 30.00 20.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 4 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 13
13 CE.2024B01.ADAB05EL02.LM10A CE 2024 B01 AD AB05 NULL NULL LM10 A EL02 NULL IMN 00 27 55 30.00 16.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 5 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 14
14 CE.2024B01.ADAB06EL03.LM10A CE 2024 B01 AD AB06 NULL NULL LM10 A EL03 NULL IMN 00 77 55 30.00 14.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 6 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 15
15 CE.2024B01.ADAB05EL02.LM19A CE 2024 B01 AD AB05 NULL NULL LM19 A EL02 NULL IMN 00 107 55 30.00 22.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 5 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 16
16 CE.2024B01.ADAB06EL03.LM19A CE 2024 B01 AD AB06 NULL NULL LM19 A EL03 NULL IMN 00 36 55 30.00 20.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 6 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 17
17 CE.2024B01.ADAI01PI01.LM10A CE 2024 B01 AD AI01 NULL NULL LM10 A PI01 NULL IMN 00 123 55 30.00 24.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 7 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 18
18 CE.2024B01.ADAI01PI01.LM19A CE 2024 B01 AD AI01 NULL NULL LM19 A PI01 NULL IMN 00 97 55 30.00 18.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 7 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 19
19 CE.2024B01.ADAI04IN01.LM10A CE 2024 B01 AD AI04 NULL NULL LM10 A IN01 NULL IMN 00 124 55 30.00 12.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 10 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 20
20 CE.2024B01.ADAI04IN01.LM19A CE 2024 B01 AD AI04 NULL NULL LM19 A IN01 NULL IMN 00 22 55 30.00 20.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 10 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 21
21 CE.2024B01.ADAI05IN02.LM10A CE 2024 B01 AD AI05 NULL NULL LM10 A IN02 NULL IMN 00 144 55 30.00 20.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 11 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 22
22 CE.2024B01.ADAI05IN02.LM19A CE 2024 B01 AD AI05 NULL NULL LM19 A IN02 NULL IMN 00 122 55 30.00 22.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 11 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 23
23 CE.2024B01.ADAI07IP01.LM19A CE 2024 B01 AD AI07 NULL NULL LM19 A IP01 NULL IMN 00 77 55 30.00 14.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 1 13 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 24
24 CE.2024B01.ADAA03IA03.LM19A CE 2024 B01 AD AA03 NULL NULL LM19 A IA03 NULL IMN 00 108 55 30.00 20.00 1.15 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL NULL 0 NULL 0.00 NULL NULL NULL NULL 1 18 0.00 NULL NULL regular NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_grupos WHERE `tb_grupos`.`id` = 25
25 CE.2024B01.KDKS01PR01.LM16A CE 2024 B01 KD KS01 NULL NULL LM16 A PR01 NULL IMN 00 100 41 30.00 2.00 1 2024-01-08 NULL 2024-03-21 1 NULL 1 NULL 0.00 0 NULL 0.00 NULL NULL NULL NULL 2 23 0.00 NULL NULL regular NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query