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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Database structure
Choose which details to show in the database structure (list of tables).
Database structure
Documentation Show or hide a column displaying the charset for all tables. Restore default value
Documentation Show or hide a column displaying the comments for all tables. Restore default value
Documentation Show or hide a column displaying the Creation timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last update timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last check timestamp for all tables. Restore default value
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
codart   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB latin1_swedish_ci 16.0 KiB -
codigos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 MyISAM latin1_swedish_ci 2.3 KiB -
codigos2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
codscajacombo   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 InnoDB latin1_swedish_ci 16.0 KiB -
grcontrol   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM latin1_swedish_ci 1.0 KiB -
grforms   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 MyISAM latin1_swedish_ci 2.2 KiB -
grfrmobjs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14 MyISAM latin1_swedish_ci 2.5 KiB -
grgrpusers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 MyISAM latin1_swedish_ci 2.2 KiB -
grgrupos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 MyISAM latin1_swedish_ci 2.1 KiB -
grpermisos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 25 MyISAM latin1_swedish_ci 2.4 KiB -
gruserlog   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 50,572 MyISAM latin1_swedish_ci 1.9 MiB -
grusers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 MyISAM latin1_swedish_ci 2.1 KiB -
grvgruposusers   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
grvpermisos   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
lst2bld   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15 InnoDB latin1_swedish_ci 48.0 KiB -
lstcompras   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 262 MyISAM latin1_swedish_ci 25.4 KiB -
lstcompras2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 214 InnoDB latin1_swedish_ci 48.0 KiB -
lstcrtlventas   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
lstcrtlventas2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
lstventas   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 124 MyISAM latin1_swedish_ci 12.2 KiB -
lstventas2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 124 InnoDB latin1_swedish_ci 16.0 KiB -
marticulos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15,489 InnoDB latin1_swedish_ci 2.6 MiB -
martpartstock   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 32,925 InnoDB latin1_swedish_ci 3.5 MiB -
mcativa   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 MyISAM latin1_swedish_ci 1.1 KiB -
mclienteshug   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
mcoddocs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 MyISAM latin1_swedish_ci 1.1 KiB -
mcompraslinea   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 26,641 InnoDB latin1_swedish_ci 3.5 MiB -
mcontrol   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM latin1_swedish_ci 2.1 KiB -
mfacturasc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 23,750 MyISAM latin1_spanish_ci 2.5 MiB -
mfacturasclinea   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 35,994 MyISAM latin1_swedish_ci 3.2 MiB -
mfacturasv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 200,677 MyISAM latin1_spanish_ci 35.1 MiB -
mfacturasvlinea   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 248,132 MyISAM latin1_swedish_ci 22.1 MiB -
micli   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
mlineas   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 240 InnoDB latin1_swedish_ci 32.0 KiB -
mmarcas   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 905 InnoDB latin1_swedish_ci 80.0 KiB -
mpartidas   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB latin1_swedish_ci 16.0 KiB -
mpreproy2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
mproveedores   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 542 InnoDB latin1_swedish_ci 96.0 KiB -
mprovincias   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 20 MyISAM latin1_swedish_ci 1.4 KiB -
mrelaciones   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 70 MyISAM latin1_swedish_ci 8.3 KiB -
msecuencias   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 18 MyISAM latin1_swedish_ci 2.4 KiB -
mtranscc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 109 MyISAM latin1_swedish_ci 5.7 KiB -
mtranshoy   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 55 InnoDB latin1_swedish_ci 16.0 KiB -
mtrasf   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16,304 MyISAM latin1_spanish_ci 2.4 MiB -
mtrasflinea   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 53,966 MyISAM latin1_swedish_ci 4.6 MiB -
mvistacliente   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 33 MyISAM latin1_swedish_ci 3.5 KiB -
oridoc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 MyISAM latin1_swedish_ci 1.1 KiB -
parmfdfharti   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
parmpartcli   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
parmproyeccion2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
partidacliente   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
partidas   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10 MyISAM latin1_swedish_ci 2.2 KiB -
precios   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~66,665 InnoDB latin1_swedish_ci 5.5 MiB -
precios2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16.0 KiB -
relaciones   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 MyISAM latin1_swedish_ci 1.1 KiB -
tmplstarj   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 476 InnoDB latin1_swedish_ci 160.0 KiB -
tmplstdeudxcalle   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 InnoDB latin1_swedish_ci 32.0 KiB -
tmplstmovsxdiajunta   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 55 InnoDB latin1_swedish_ci 32.0 KiB -
tmppretarjazules   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 800 InnoDB latin1_swedish_ci 256.0 KiB -
tranborre   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB latin1_swedish_ci 16.0 KiB -
usuarios   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15 InnoDB latin1_swedish_ci 16.0 KiB -
utfaltaimport   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 16.0 KiB -
utmisfotos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB latin1_swedish_ci 320.0 KiB -
utprobarw   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7 InnoDB latin1_swedish_ci 16.0 KiB -
utrel   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB latin1_swedish_ci 16.0 KiB -
vcontarcasos   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vfdfharti   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vlinmarc   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vlinmarcart   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vlstcomprasconlymyorder   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vlstcrtlventasconlymyorder   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vlstventasconlymyorder   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vlstventascontodoyorderloc   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vprecartah   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vprelstarj   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vprelstpagoshoy   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vproy2trans1   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vproyeccion   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
vtransccacum   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
79 tables Sum ~775,349 InnoDB utf8mb4_general_ci 88.5 MiB 0 B
With selected:

Data dictionary Data dictionary

Create new table Create new table