🗃️ 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-07-04 18:34:152026-07-04 18:34:15utf8mb3utf8mb3_general_ciutf8mb4_uca1400_ai_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-07-04 18:34:152026-07-04 18:34:15utf8mb3utf8mb3_general_ciutf8mb4_uca1400_ai_cibegin set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column)...NONE
sysextract_schema_from_file_nameFUNCTIONextract_schema_from_file_nameSQLNO_SQLYESINVOKERpath VARCHAR(512) varchar(64) CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN RETURN LEFT(SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(path, '\\', '/'), '/', -2), ...mariadb.sys@localhost2026-07-04 18:34:152026-07-04 18:34:15 Description Takes a raw file path, and attempts to extract the ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN RETURN LEFT(SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(path, '\', '/'), '/', -2), '...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-04 18:34:152026-07-04 18:34:15 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-04 18:34:152026-07-04 18:34:15 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-04 18:34:162026-07-04 18:34:16 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-04 18:34:172026-07-04 18:34:17 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-04 18:34:242026-07-04 18:34:24 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
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-04 18:34:162026-07-04 18:34:16 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
sysformat_statementFUNCTIONformat_statementSQLNO_SQLYESINVOKERstatement LONGTEXT longtext CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN IF @sys.statement_truncate_len IS NULL THEN SET @sys.statement_truncate_len ...mariadb.sys@localhost2026-07-04 18:34:162026-07-04 18:34:16 Description Formats a normalized statement, truncating it if it...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN IF @sys.statement_truncate_len IS NULL THEN SET @sys.statement_truncate_len ...NONE
syslist_addFUNCTIONlist_addSQLCONTAINS_SQLYESINVOKERin_list TEXT, in_add_value TEXT text CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN IF (in_add_value IS NULL) THEN SIGNAL SQLSTATE '02200' SET ME...mariadb.sys@localhost2026-07-04 18:34:162026-07-04 18:34:16 Description Takes a list, and a value to add to the list, and r...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN IF (in_add_value IS NULL) THEN SIGNAL SQLSTATE '02200' SET ME...NONE
sysoptimizer_switch_onPROCEDUREoptimizer_switch_onSQLCONTAINS_SQLNOINVOKERBEGIN call optimizer_switch_choice("on"); ENDmariadb.sys@localhost2026-07-04 18:34:242026-07-04 18:34:24return @@optimizer_switch options that are onutf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN call optimizer_switch_choice("on"); ENDNONE
sysoptimizer_switch_offPROCEDUREoptimizer_switch_offSQLCONTAINS_SQLNOINVOKERBEGIN call optimizer_switch_choice("off"); ENDmariadb.sys@localhost2026-07-04 18:34:242026-07-04 18:34:24return @@optimizer_switch options that are offutf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN call optimizer_switch_choice("off"); ENDNONE
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-04 18:34:242026-07-04 18:34:24 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-04 18:34:242026-07-04 18:34:24 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-04 18:34:242026-07-04 18:34:24 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-04 18:34:252026-07-04 18:34:25 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
sysformat_timeFUNCTIONformat_timeSQLNO_SQLYESINVOKERpicoseconds TEXT text CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN IF picoseconds IS NULL THEN RETURN NULL; ELSEIF picoseconds >= 60480000000000000...mariadb.sys@localhost2026-07-04 18:34:162026-07-04 18:34:16 Description OBSOLETE. USE BUILT-IN format_pico_time() INSTEAD ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN IF picoseconds IS NULL THEN RETURN NULL; ELSEIF picoseconds >= 60480000000000000...NONE
syslist_dropFUNCTIONlist_dropSQLCONTAINS_SQLYESINVOKERin_list TEXT, in_drop_value TEXT text CHARSET utf8mb3 COLLATE utf8mb3_general_ciBEGIN IF (in_drop_value IS NULL) THEN SIGNAL SQLSTATE '02200' SET M...mariadb.sys@localhost2026-07-04 18:34:162026-07-04 18:34:16 Description Takes a list, and a value to attempt to remove from...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN IF (in_drop_value IS NULL) THEN SIGNAL SQLSTATE '02200' SET M...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-04 18:34:262026-07-04 18:34:26 Description Shows all currently disabled instruments. ...utf8mb3utf8mb3_general_ciutf8mb3_general_ciBEGIN SELECT name AS disabled_instruments, timed FROM performance_schema.setup_i...NONE