central.tail4f76da.ts.net / localhost / imnrc_sphere_dev / tb_usuarios_copy1

There are no favorite tables.

New
alfa_asistencia
fby_app_dev
imnrc
- imnrc_sphere_dev
- imnrc_website_dev
information_schema
mysql
performance_schema
phpmyadmin
seasonal_stocks
test
wolverine_final

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 :

No bookmarks

Label: Target database: Share this bookmark

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 Bookmark 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

Showing rows 0 - 24 (148 total, Query took 0.0016 seconds.) [tipo_perfil: ... - ...]

SELECT * FROM `tb_usuarios_copy1` ORDER BY `tipo_perfil` DESC

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

Filter rows:

			id	matricula matricula o número de empleado	nombres	apellidos	genero	fecha_nacimiento	foto	email	pwd	celular	curp	fecha_alta	fecha_baja	tipo_perfil 1 si es público o interno	rol_general si es alumno, tutor o sponsor, profesor o admin	id_organizacion id de la organización en caso de que sea un sponso…	enabled
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 1	1	CE585962	Antonio	Dávila	M	NULL	NULL	antonio.davila@gmail.com	d080bee5205ea800214f435b24a6289c2aac558c	8181197810	DAGA780711HNLVRN08	2023-05-03	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 2	2	NULL	JESUS RODRIGO	SALINAS MARTINEZ	M	NULL	NULL	jsalinas@relacionesculturales.edu.mx	NULL	8115448405	SAMJ631026HCLLRS02	1991-04-08	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 3	3	NULL	SANDRA	DOMINGO HELLMUND	F	NULL	NULL	sdomingoh@relacionesculturales.edu.mx	NULL	8115448404	DOHS650919MTSMLN02	2000-10-16	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 4	4	NULL	MARTHA TERESA	MARTINEZ CASTRUITA	F	NULL	NULL	mtmartinez@relacionesculturales.edu.mx	NULL	8117907835	MACM731226MNLRSR04	2007-02-16	NULL	NULL	NULL	NULL	0
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 5	5	NULL	JUDITH	CASTAÑEDA DE LA PEÑA	F	NULL	NULL	judith@relacionesculturales.edu.mx	NULL	8124391722	CAPJ910516MNLSXD02	2009-10-15	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 6	6	NULL	TANIA ELIZABETH	OLVERA RINCON	F	NULL	NULL	tolvera@relacionesculturales.edu.mx	NULL	8110800810	OERT840404MNLLNN01	2007-02-16	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 7	7	NULL	MARIA DEL PILAR	MORA PEREZ	F	NULL	NULL	pilarm@relacionesculturales.edu.mx	NULL	8115448412	MOPP821103MNLRRL07	2007-04-16	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 8	8	NULL	KORINA LISETH	PINTOR HERNANDEZ	F	NULL	NULL	kpintor@relacionesculturales.edu.mx	NULL	8182768701	PIHK871208MNLNRR01	2007-09-16	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 9	9	NULL	RAUL MILAGRO	PEREZ ALANIS	M	NULL	NULL	raul_perez@relacionesculturales.edu.mx	NULL	8115448400	PEAR850506HNLRLL08	2008-04-16	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 10	10	NULL	KARLA ANDREA	PURATA JONGUITUD	F	NULL	NULL	karlaj@relacionesculturales.edu.mx	NULL	8113116174	PUJK901209MSPRNR09	2016-07-16	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 11	11	NULL	YAHAVE GADI	CAMACHO GONZALEZ	M	NULL	NULL	yahave.camacho@relacionesculturales.com	NULL	8115147178	CAGY740427HNLMNH00	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 12	12	NULL	MERCED	DIAZ LUNA	F	NULL	NULL	merced.diaz@relacionesculturales.com	NULL	8110646572	DILM661230HNLZNR09	1991-10-01	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 13	13	NULL	CATALINA	GONZALEZ OCHOA	F	NULL	NULL	catalinago@relacionesculturales.com	NULL	8114909570	GOOC641215MNLNCT14	2023-09-26	2023-12-05	NULL	NULL	NULL	0
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 14	14	NULL	HUGO	VELAZQUEZ GAYTAN	M	NULL	NULL	hugovg@relacionesculturales.com	NULL	8111153841	VEGH730401HNLLYG09	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 15	15	NULL	JORGE CARLOS	PEREZ FLOTA	M	NULL	NULL	carlospf@relacionesculturales.com	NULL	7441875359	PEFJ751030HYNRLR07	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 16	16	NULL	MARIANA GUADALUPE	GARZA CANTU	F	NULL	NULL	marianagc@relacionesculturales.com	NULL	8110313783	GACM911212MNLRNR00	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 17	17	NULL	CARLOS EDUARDO	GUZMAN GONZALEZ	M	NULL	NULL	carlosgg@relacionesculturales.com	NULL	8180959791	GUGC900401HNLZNR01	2018-09-01	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 18	18	NULL	GLADYS	GUTIERREZ TORRES	F	NULL	NULL	gladys.gtz@relacionesculturales.com	NULL	8181809324	GUTG841111MNLTRL01	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 19	19	NULL	RUBEN MEDARDO	RAMIREZ TAPIA	M	NULL	NULL	ruben.ramirez@relacionesculturales.com	NULL	8112458107	RATR800109HNLMPB28	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 20	20	NULL	LISANDRO JUAN	TREVIÑO GUEVARA	M	NULL	NULL	lisandro_trevino@relacionesculturales.edu.mx	NULL	8116118352	TEGL721008HNLRVS05	1996-07-29	NULL	NULL	NULL	NULL	0
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 21	21	NULL	EDGAR IVAN	LIRA VAZQUEZ	M	NULL	NULL	edgar.lira@relacionesculturales.com	NULL	8115083828	LIVE720821HNLRZD07	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 22	22	NULL	VICTOR MANUEL	CHAPA TAMEZ	M	NULL	NULL	victor.chapa@relacionesculturales.com	NULL	8112779075	CATV850809HNLHMC06	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 23	23	NULL	IRMA PEREGRINA	GUERRA ZERMEÑO	F	NULL	NULL	irma.guerra@relacionesculturales.com	NULL	8182558380	GUZI840615MNLRRR05	2023-09-26	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 24	24	NULL	AIMEE NOHEMI	PEREZ PUENTE	F	NULL	NULL	aimee@relacionesculturales.edu.mx	NULL	8123776767	PEPA951002MNLRNM06	2014-04-01	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM tb_usuarios_copy1 WHERE `tb_usuarios_copy1`.`id` = 25	25	NULL	DALIA ELIZABETH	ORTIZ VAZQUEZ	F	NULL	NULL	dalia@relacionesculturales.edu.mx	NULL	8122550335	OIVD940713MNLRZL05	2014-09-01	NULL	NULL	NULL	NULL	1

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view