🗃️ BASES / MARIADB

Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.

🏠 Tres puertas🗃️ Bases📋 Tablas de information_schema
MariaDB/information_schema/ALL_PLUGINS
OK
Conexión DB
82
Tablas visibles
information_schema
Nivel actual

🧬 Columnas: information_schema / ALL_PLUGINS

13
CampoTipoNullKeyDefaultExtra
PLUGIN_NAMEvarchar(64)NO
PLUGIN_VERSIONvarchar(20)NO
PLUGIN_STATUSvarchar(16)NO
PLUGIN_TYPEvarchar(80)NO
PLUGIN_TYPE_VERSIONvarchar(20)NO
PLUGIN_LIBRARYvarchar(64)YES
PLUGIN_LIBRARY_VERSIONvarchar(20)YES
PLUGIN_AUTHORvarchar(64)YES
PLUGIN_DESCRIPTIONlongtextYES
PLUGIN_LICENSEvarchar(80)NO
LOAD_OPTIONvarchar(64)NO
PLUGIN_MATURITYvarchar(12)NO
PLUGIN_AUTH_VERSIONvarchar(80)YES

🔬 Muestra de datos

20 filas
PLUGIN_NAMEPLUGIN_VERSIONPLUGIN_STATUSPLUGIN_TYPEPLUGIN_TYPE_VERSIONPLUGIN_LIBRARYPLUGIN_LIBRARY_VERSIONPLUGIN_AUTHORPLUGIN_DESCRIPTIONPLUGIN_LICENSELOAD_OPTIONPLUGIN_MATURITYPLUGIN_AUTH_VERSION
binlog1.0ACTIVESTORAGE ENGINE110407.0MySQL ABThis is a pseudo storage engine to represent the binlog in a transactionGPLFORCEStable1.0
mysql_native_password1.0ACTIVEAUTHENTICATION2.2R.J.Silk, Sergei GolubchikNative MySQL authenticationGPLFORCEStable1.0
mysql_old_password1.0ACTIVEAUTHENTICATION2.2R.J.Silk, Sergei GolubchikOld MySQL-4.0 authenticationGPLFORCEStable1.0
CSV1.0ACTIVESTORAGE ENGINE110407.0Brian Aker, MySQL ABStores tables as CSV filesGPLFORCEStable1.0
MEMORY1.0ACTIVESTORAGE ENGINE110407.0MySQL ABHash based, stored in memory, useful for temporary tablesGPLFORCEStable1.0
Aria1.5ACTIVESTORAGE ENGINE110407.0MariaDB Corporation AbCrash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege t...GPLFORCEStable1.5
MyISAM1.0ACTIVESTORAGE ENGINE110407.0MySQL ABNon-transactional engine with good performance and small data footprintGPLFORCEStable1.0
MRG_MyISAM1.0ACTIVESTORAGE ENGINE110407.0MySQL ABCollection of identical MyISAM tablesGPLFORCEStable1.0
SPATIAL_REF_SYS1.0ACTIVEINFORMATION SCHEMA110407.0MariaDBLists all geometry columnsGPLFORCEStable1.0
GEOMETRY_COLUMNS1.0ACTIVEINFORMATION SCHEMA110407.0MariaDBLists all geometry columnsGPLFORCEStable1.0
inet41.0ACTIVEDATA TYPE110407.0MariaDB CorporationData type INET4GPLFORCEGamma1.0
inet61.0ACTIVEDATA TYPE110407.0MariaDB CorporationData type INET6GPLFORCEStable1.0
inet_aton1.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction INET_ATON()GPLFORCEStable1.0
inet_ntoa1.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction INET_NTOA()GPLFORCEStable1.0
inet6_aton1.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction INET6_ATON()GPLFORCEStable1.0
inet6_ntoa1.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction INET6_NTOA()GPLFORCEStable1.0
is_ipv41.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction IS_IPV4()GPLFORCEStable1.0
is_ipv61.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction IS_IPV6()GPLFORCEStable1.0
is_ipv4_compat1.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction IS_IPV4_COMPAT()GPLFORCEStable1.0
is_ipv4_mapped1.0ACTIVEFUNCTION110407.0MariaDB CorporationFunction IS_IPV4_MAPPED()GPLFORCEStable1.0