🗃️ 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 mysql
MariaDB/mysql/proc
OK
Conexión DB
31
Tablas visibles
mysql
Nivel actual

🧬 Columnas: mysql / proc

21
CampoTipoNullKeyDefaultExtra
dbchar(64)NOPRI
namechar(64)NOPRI
typeenum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY')NOPRI
specific_namechar(64)NO
languageenum('SQL')NOSQL
sql_data_accessenum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA')NOCONTAINS_SQL
is_deterministicenum('YES','NO')NONO
security_typeenum('INVOKER','DEFINER')NODEFINER
param_listblobNO
returnslongblobNO
bodylongblobNO
definervarchar(384)NO
createdtimestampNOcurrent_timestamp()on update current_timestamp()
modifiedtimestampNO0000-00-00 00:00:00
sql_modeset('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL')NO
commenttextNO
character_set_clientchar(32)YES
collation_connectionchar(64)YES
db_collationchar(64)YES
body_utf8longblobYES
aggregateenum('NONE','GROUP')NONONE

🔬 Muestra de datos

20 filas
dbnametypespecific_namelanguagesql_data_accessis_deterministicsecurity_typeparam_listreturnsbodydefinercreatedmodifiedsql_modecommentcharacter_set_clientcollation_connectiondb_collationbody_utf8aggregate
mysqlAddGeometryColumnPROCEDUREAddGeometryColumnSQLCONTAINS_SQLNOINVOKERcatalog varchar(64), t_schema varchar(64), t_name varchar(64), geometry_column varchar(...begin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,'...mariadb.sys@localhost2026-05-15 00:55:532026-05-15 00:55:53utf8mb3utf8mb3_general_ciutf8mb4_general_cibegin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,'...NONE
mysqlDropGeometryColumnPROCEDUREDropGeometryColumnSQLCONTAINS_SQLNOINVOKERcatalog varchar(64), t_schema varchar(64), t_name varchar(64), geometry_column varchar(...begin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column)...mariadb.sys@localhost2026-05-15 00:55:532026-05-15 00:55:53utf8mb3utf8mb3_general_ciutf8mb4_general_cibegin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column)...NONE
syscreate_synonym_dbPROCEDUREcreate_synonym_dbSQLMODIFIES_SQL_DATANOINVOKER IN in_db_name VARCHAR(64), IN in_synonym VARCHAR(64) BEGIN DECLARE v_done bool DEFAULT FALSE; DECLARE v_db_name_check VARCHAR(64); ...mariadb.sys@localhost2026-07-29 00:34:352026-07-29 00:34:35 Description Takes a source database name and synonym name, and ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_done bool DEFAULT FALSE; DECLARE v_db_name_check VARCHAR(64); ...NONE
sysextract_table_from_file_nameFUNCTIONextract_table_from_file_nameSQLNO_SQLYESINVOKERpath VARCHAR(512) varchar(64) CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN RETURN LEFT(SUBSTRING_INDEX(REPLACE(SUBSTRING_INDEX(REPLACE(path, '\\', '/'), '/...mariadb.sys@localhost2026-07-29 00:34:322026-07-29 00:34:32 Description Takes a raw file path, and extracts the table name ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN RETURN LEFT(SUBSTRING_INDEX(REPLACE(SUBSTRING_INDEX(REPLACE(path, '\', '/'), '/'...NONE
sysformat_bytesFUNCTIONformat_bytesSQLNO_SQLYESINVOKERbytes TEXT text CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN IF bytes IS NULL THEN RETURN NULL; ELSEIF bytes >= 1125899906842624 THEN RETURN ...mariadb.sys@localhost2026-07-29 00:34:322026-07-29 00:34:32 Description Takes a raw bytes value, and converts it to a human...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN IF bytes IS NULL THEN RETURN NULL; ELSEIF bytes >= 1125899906842624 THEN RETURN ...NONE
sysps_thread_stackFUNCTIONps_thread_stackSQLREADS_SQL_DATANOINVOKERthd_id BIGINT UNSIGNED, debug BOOLEAN longtext CHARSET latin1 COLLATE latin1_swedish_ciBEGIN DECLARE json_objects LONGTEXT; UPDATE performance_schema.threads ...mariadb.sys@localhost2026-07-29 00:34:332026-07-29 00:34:33 Description Outputs a JSON formatted stack of all statements, s...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE json_objects LONGTEXT; UPDATE performance_schema.threads ...NONE
sysps_thread_trx_infoFUNCTIONps_thread_trx_infoSQLREADS_SQL_DATANOINVOKERin_thread_id BIGINT UNSIGNED longtext CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN DECLARE v_output LONGTEXT DEFAULT '{}'; DECLARE v_msg_text TEXT DEFAULT ''; ...mariadb.sys@localhost2026-07-29 00:34:332026-07-29 00:34:33 Description Returns a JSON object with info on the given thread...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_output LONGTEXT DEFAULT '{}'; DECLARE v_msg_text TEXT DEFAULT ''; ...NONE
sysdiagnosticsPROCEDUREdiagnosticsSQLREADS_SQL_DATANOINVOKER IN in_max_runtime int unsigned, IN in_interval int unsigned, IN in_auto_c...BEGIN DECLARE v_start, v_runtime, v_iter_start, v_sleep DECIMAL(20,2) DEFAULT 0.0; ...mariadb.sys@localhost2026-07-29 00:34:352026-07-29 00:34:35 Description Create a report of the current status of the server...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_start, v_runtime, v_iter_start, v_sleep DECIMAL(20,2) DEFAULT 0.0; ...NONE
sysps_statement_avg_latency_histogramPROCEDUREps_statement_avg_latency_histogramSQLREADS_SQL_DATANOINVOKERBEGIN SELECT CONCAT('\n', '\n . = 1 unit', '\n * = 2 units', '\n #...mariadb.sys@localhost2026-07-29 00:34:352026-07-29 00:34:35 Description Outputs a textual histogram graph of the average la...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN SELECT CONCAT('\n', '\n . = 1 unit', '\n * = 2 units', '\n #...NONE
sysps_trace_statement_digestPROCEDUREps_trace_statement_digestSQLMODIFIES_SQL_DATANOINVOKER IN in_digest VARCHAR(32), IN in_runtime INT, IN in_interval DECIM...BEGIN DECLARE v_start_fresh BOOLEAN DEFAULT false; DECLARE v_auto_enable BOOLEAN D...mariadb.sys@localhost2026-07-29 00:34:352026-07-29 00:34:35 Description Traces all instrumentation within Performance Schem...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_start_fresh BOOLEAN DEFAULT false; DECLARE v_auto_enable BOOLEAN D...NONE
sysps_trace_threadPROCEDUREps_trace_threadSQLMODIFIES_SQL_DATANOINVOKER IN in_thread_id BIGINT UNSIGNED, IN in_outfile VARCHAR(255), IN i...BEGIN DECLARE v_done bool DEFAULT FALSE; DECLARE v_start, v_runtime DECIMAL(20,2) ...mariadb.sys@localhost2026-07-29 00:34:352026-07-29 00:34:35 Description Dumps all data within Performance Schema for an ins...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_done bool DEFAULT FALSE; DECLARE v_start, v_runtime DECIMAL(20,2) ...NONE
sysps_setup_reset_to_defaultPROCEDUREps_setup_reset_to_defaultSQLMODIFIES_SQL_DATANOINVOKER IN in_verbose BOOLEAN BEGIN SET @query = 'DELETE FROM performance_schema.setup_actors ...mariadb.sys@localhost2026-07-29 00:34:362026-07-29 00:34:36 Description Resets the Performance Schema setup to the default ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN SET @query = 'DELETE\n FROM performance_schema.setup_actors\n...NONE
sysps_setup_show_disabled_instrumentsPROCEDUREps_setup_show_disabled_instrumentsSQLREADS_SQL_DATAYESINVOKERBEGIN SELECT name AS disabled_instruments, timed FROM performance_schema.setup_i...mariadb.sys@localhost2026-07-29 00:34:362026-07-29 00:34:36 Description Shows all currently disabled instruments. ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN SELECT name AS disabled_instruments, timed FROM performance_schema.setup_i...NONE
sysformat_pathFUNCTIONformat_pathSQLNO_SQLYESINVOKERin_path VARCHAR(512) varchar(512) CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN DECLARE v_dir VARCHAR(1024); DECLARE v_path VARCHAR(512); DECLARE path_separat...mariadb.sys@localhost2026-07-29 00:34:322026-07-29 00:34:32 Description Takes a raw path value, and strips out the datadir ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_dir VARCHAR(1024); DECLARE v_path VARCHAR(512); DECLARE path_separat...NONE
systable_existsPROCEDUREtable_existsSQLCONTAINS_SQLNOINVOKER IN in_db VARCHAR(64), IN in_table VARCHAR(64), OUT out_exists ENUM('', 'B...BEGIN DECLARE v_error BOOLEAN DEFAULT FALSE; DECLARE db_quoted VARCHAR(64); DE...mariadb.sys@localhost2026-07-29 00:34:362026-07-29 00:34:36 Description Tests whether the table specified in in_db and in_t...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_error BOOLEAN DEFAULT FALSE; DECLARE db_quoted VARCHAR(64); DE...NONE
sysps_is_consumer_enabledFUNCTIONps_is_consumer_enabledSQLREADS_SQL_DATAYESINVOKERin_consumer varchar(64) enum('YES','NO') CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN RETURN ( SELECT (CASE WHEN c.NAME = 'global_instrumen...mariadb.sys@localhost2026-07-29 00:34:322026-07-29 00:34:32 Description Determines whether a consumer is enabled (taking th...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN RETURN ( SELECT (CASE WHEN c.NAME = 'global_instrumen...NONE
sysstatement_performance_analyzerPROCEDUREstatement_performance_analyzerSQLCONTAINS_SQLNOINVOKER IN in_action ENUM('snapshot', 'overall', 'delta', 'create_table', 'create_tmp', '...BEGIN DECLARE v_table_exists, v_tmp_digests_table_exists, v_custom_view_exists ENUM(''...mariadb.sys@localhost2026-07-29 00:34:362026-07-29 00:34:36 Description Create a report of the statements running on the se...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN DECLARE v_table_exists, v_tmp_digests_table_exists, v_custom_view_exists ENUM(''...NONE
sysps_setup_show_enabled_instrumentsPROCEDUREps_setup_show_enabled_instrumentsSQLREADS_SQL_DATAYESINVOKERBEGIN SELECT name AS enabled_instruments, timed FROM performance_schema.setup_in...mariadb.sys@localhost2026-07-29 00:34:362026-07-29 00:34:36 Description Shows all currently enabled instruments. ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN SELECT name AS enabled_instruments, timed FROM performance_schema.setup_in...NONE
sysps_setup_show_enabled_consumersPROCEDUREps_setup_show_enabled_consumersSQLREADS_SQL_DATAYESINVOKERBEGIN SELECT name AS enabled_consumers FROM performance_schema.setup_consumers ...mariadb.sys@localhost2026-07-29 00:34:362026-07-29 00:34:36 Description Shows all currently enabled consumers. ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN SELECT name AS enabled_consumers FROM performance_schema.setup_consumers ...NONE
sysps_setup_disable_background_threadsPROCEDUREps_setup_disable_background_threadsSQLMODIFIES_SQL_DATANOINVOKERBEGIN UPDATE performance_schema.threads SET instrumented = 'NO' WHERE type...mariadb.sys@localhost2026-07-29 00:34:352026-07-29 00:34:35 Description Disable all background thread instrumentation withi...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN UPDATE performance_schema.threads SET instrumented = 'NO' WHERE type...NONE