Lësho filet këtu

SQL upload ( 0 ) x -

Rregullimet faqe-relevante Kliko mbi shirit për të lëvizur në krye të faqes
Shtyp Ctrl+Enter për të ekzekutuar pyetsorin Shtyp Enter për të ekzekutuar pyetsorin
ngritëse
zbritëse
Renditja:
Debug (rregullo) SQL
Numri
Ekzekutimi i renditjes
Koha që ka marrë
Renditur sipas:
Grupo pyetsorët
Mos-grupo pyetsorët
Ngushto Zgjero Shfaq gjurmën Fsheh gjurmën Numri : Koha që ka marrë :
Faqeruajtësit
Rifresko
Shto
Jo faqeruajtës
Shto faqeruajtës
Opsionet
E paracaktuar





Ngushto Zgjero Requery (kërkesë) Redakto Sqaro Profilon Faqeruajtës Pyetsori dështoi Databaza : Koha e pyetsorit :
Mënyra e shfletimit
Përshtat mënyrën e shfletimit.
Mënyra e shfletimit
Dokumentacioni Përdor vetëm ikona, vetëm text ose të dyja. Rivendos vlerën standarde
Dokumentacioni Përdor vetëm ikona, vetëm text ose të dyja. Rivendos vlerën standarde
Dokumentacioni Nëse një përdorues do të shfaqte një buton "shfaq të gjitha (radhët)". Rivendos vlerën standarde
Dokumentacioni Numri i radhëve të shfaqura, kur shfleton një set rezultatesh. Nëse seti i rezultateve përmban më shumë radhë, lidhjet "Përpara " dhe "Tjetër" do të shfaqen. Rivendos vlerën standarde
Dokumentacioni SMART - dmth. renditje zbritëse për kolonat e tipit TIME, DATE, DATETIME dhe TIMESTAMP, përndryshe rendiktje ngritëse. Rivendos vlerën standarde
Dokumentacioni Thekso radhën e treguar nga kursori i miut. Rivendos vlerën standarde
Dokumentacioni Thekso radhët e zgjedhura. Rivendos vlerën standarde
Dokumentacioni Rivendos vlerën standarde
Dokumentacioni Rivendos vlerën standarde
Dokumentacioni Përsërit kokat për çdo X qeliza, 0 e pasivizon këtë tipar. Rivendos vlerën standarde
Dokumentacioni Numri maksimal i karaktereve të shfaqura në çdo kolonë jo-numerike në pamjen e shfletimit. Rivendos vlerën standarde
Dokumentacioni Këto janë lidhjet për redaktim, kopjim dhe fshirje. Rivendos vlerën standarde
Dokumentacioni Qoftë për të treguar lidhjet e radhës edhe në mungesë të një çelësi unik. Rivendos vlerën standarde
Dokumentacioni Renditja e klasifikimit të paracaktuar për tabelat me një çelës primar. Rivendos vlerën standarde
Dokumentacioni Kur shfleton tabelat, klasifikimi i çdo tabele kujtohet. Rivendos vlerën standarde
Dokumentacioni Për opsionet e shfaqjes Rivendos vlerën standarde
SELECT * FROM `ROUTINES`
Redakto në linjë ] [ Redakto ] [ Sqaro SQL ] [ Krijo kodin PHP ] [ Rifresko ]
SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
extract_schema_from_file_name def sys extract_schema_from_file_name FUNCTION varchar 64 256 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(64) SQL
BEGIN
    RETURN LEFT(SUBSTRING_INDEX(SUBSTRING_IN...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a raw file path, a...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
extract_table_from_file_name def sys extract_table_from_file_name FUNCTION varchar 64 256 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(64) SQL
BEGIN
    RETURN LEFT(SUBSTRING_INDEX(REPLACE(SUBS...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a raw file path, a...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
format_bytes def sys format_bytes FUNCTION text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci text SQL
BEGIN
  IF (bytes IS NULL) THEN
    RETURN NULL;
 ...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a raw bytes value,...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
format_path def sys format_path FUNCTION varchar 512 2048 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(512) SQL
BEGIN
  DECLARE v_path VARCHAR(512);
  DECLARE v_u...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a raw path value, ...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
format_statement def sys format_statement FUNCTION longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci longtext SQL
BEGIN
  -- Check if we have the configured length,...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Formats a normalized sta...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
format_time def sys format_time FUNCTION text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci text SQL
BEGIN
  IF picoseconds IS NULL THEN RETURN NULL;
 ...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a raw picoseconds ...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
list_add def sys list_add FUNCTION text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci text SQL
BEGIN
    IF (in_add_value IS NULL) THEN
        S...
NULL SQL SQL YES CONTAINS SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a list, and a valu...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
list_drop def sys list_drop FUNCTION text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci text SQL
BEGIN
    IF (in_drop_value IS NULL) THEN
        ...
NULL SQL SQL YES CONTAINS SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a list, and a valu...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_is_account_enabled def sys ps_is_account_enabled FUNCTION enum 3 12 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci enum('YES','NO') SQL
BEGIN
    RETURN IF(EXISTS(SELECT 1
              ...
NULL SQL SQL YES READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Determines whether instr...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_is_consumer_enabled def sys ps_is_consumer_enabled FUNCTION enum 3 12 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci enum('YES','NO') SQL
BEGIN
    DECLARE v_is_enabled ENUM('YES', 'NO') D...
NULL SQL SQL YES READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Determines whether a con...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_is_instrument_default_enabled def sys ps_is_instrument_default_enabled FUNCTION enum 3 12 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci enum('YES','NO') SQL
BEGIN
    DECLARE v_enabled ENUM('YES', 'NO');
   ...
NULL SQL SQL YES READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns whether an instr...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_is_instrument_default_timed def sys ps_is_instrument_default_timed FUNCTION enum 3 12 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci enum('YES','NO') SQL
BEGIN
    DECLARE v_timed ENUM('YES', 'NO');
    I...
NULL SQL SQL YES READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns whether an instr...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_is_thread_instrumented def sys ps_is_thread_instrumented FUNCTION enum 7 28 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci enum('YES','NO','UNKNOWN') SQL
BEGIN
    DECLARE v_enabled ENUM('YES', 'NO', 'UNK...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Checks whether the provi...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_thread_id def sys ps_thread_id FUNCTION bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned SQL
BEGIN
  IF (in_connection_id IS NULL) THEN
    RET...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Return the Performance S...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_thread_account def sys ps_thread_account FUNCTION text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci text SQL
BEGIN
    RETURN (SELECT IF(
                     ...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Return the user@host acc...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_thread_stack def sys ps_thread_stack FUNCTION longtext 4294967295 4294967295 NULL NULL NULL latin1 latin1_swedish_ci longtext SQL
BEGIN
    DECLARE json_objects LONGTEXT;
    -- Do...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Outputs a JSON formatted...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
ps_thread_trx_info def sys ps_thread_trx_info FUNCTION longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci longtext SQL
BEGIN
    DECLARE v_output LONGTEXT DEFAULT '{}';
...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns a JSON object wi...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
quote_identifier def sys quote_identifier FUNCTION text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci text SQL
BEGIN
    RETURN CONCAT('`', REPLACE(in_identifier...
NULL SQL SQL YES NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes an unquoted identi...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
sys_get_config def sys sys_get_config FUNCTION varchar 128 512 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(128) SQL
BEGIN
    DECLARE v_value VARCHAR(128) DEFAULT NUL...
NULL SQL SQL YES READS SQL DATA NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns the value for th...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
version_major def sys version_major FUNCTION tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned SQL
BEGIN
    RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(V...
NULL SQL SQL NO NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns the major versio...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
version_minor def sys version_minor FUNCTION tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned SQL
BEGIN
    RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(S...
NULL SQL SQL NO NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns the minor (relea...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
version_patch def sys version_patch FUNCTION tinyint NULL NULL 3 0 NULL NULL NULL tinyint unsigned SQL
BEGIN
    RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(V...
NULL SQL SQL NO NO SQL NULL INVOKER 2026-05-16 08:17:52 2026-05-16 08:17:52 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Returns the patch releas...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
create_synonym_db def sys create_synonym_db PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL
BEGIN
    DECLARE v_done bool DEFAULT FALSE;
    D...
NULL SQL SQL NO MODIFIES SQL DATA NULL INVOKER 2026-05-16 08:17:53 2026-05-16 08:17:53 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes a source database ...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
execute_prepared_stmt def sys execute_prepared_stmt PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL
BEGIN
    -- Set configuration options
    IF (@sy...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:53 2026-05-16 08:17:53 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Takes the query in the a...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
diagnostics def sys diagnostics PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL
BEGIN
    DECLARE v_start, v_runtime, v_iter_start...
NULL SQL SQL NO READS SQL DATA NULL INVOKER 2026-05-16 08:17:53 2026-05-16 08:17:53 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
Description
-----------

Create a report of the c...
mysql.sys@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
Veprimet e rezultatit të pyetsorit Kopjo në clipboard Kopjo në clipboard Eksporti Eksporti Shfaq grafikun Shfaq grafikun Krijo pamje Krijo pamje
Faqeruaj këtë pyetsor SQL Faqeruaj këtë pyetsor SQL