{"id":107320,"date":"2025-05-09T20:22:50","date_gmt":"2025-05-09T14:52:50","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/?page_id=107320"},"modified":"2025-05-09T17:41:15","modified_gmt":"2025-05-09T12:11:15","slug":"sql-editor-tool","status":"publish","type":"page","link":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/","title":{"rendered":"Online SQL Compiler"},"content":{"rendered":"\n<!-- Load FontAwesome for Icons -->\n<link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.4.0\/css\/all.min.css\">\n\n<!-- Load CodeMirror for the Editor -->\n<link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/codemirror\/5.65.13\/codemirror.min.css\">\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/codemirror\/5.65.13\/codemirror.min.js\"><\/script>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/codemirror\/5.65.13\/mode\/sql\/sql.min.js\"><\/script>\n\n<!-- Load SQL.js for the Database -->\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/sql.js\/1.8.0\/sql-wasm.min.js\"><\/script>\n\n<div class=\"sql-ide-container\" id=\"sql-ide\">\n    <!-- Header -->\n    <div class=\"sql-ide-header\">\n        <div class=\"sql-header-left\">\n            <div class=\"sql-title\">Online SQL Compiler<\/div>\n            <div class=\"sql-icons\">\n                <i class=\"fa-solid fa-rotate-right\" id=\"btn-refresh\" title=\"Reset Editor & DB\"><\/i>\n                <i class=\"fa-solid fa-expand\" id=\"btn-expand\" title=\"Toggle Fullscreen\"><\/i>\n            <\/div>\n            <button class=\"sql-run-btn\" id=\"btn-run\">Run Code<\/button>\n        <\/div>\n        <!-- Desktop Tabs -->\n        <div class=\"sql-header-right\">\n            <div class=\"sql-tabs\">\n                <button class=\"sql-tab active\" data-target=\"output\">\n                    <i class=\"fa-solid fa-arrow-right-to-bracket\"><\/i> Output\n                <\/button>\n                <button class=\"sql-tab\" data-target=\"schema\">\n                    <i class=\"fa-solid fa-diagram-project\"><\/i> Schema\n                <\/button>\n                <button class=\"sql-tab\" data-target=\"tables\">\n                    <i class=\"fa-solid fa-database\"><\/i> Tables\n                <\/button>\n            <\/div>\n        <\/div>\n    <\/div>\n\n    <!-- Body -->\n    <div class=\"sql-ide-body\">\n        <div class=\"sql-editor-pane\" id=\"editor-pane\">\n            <textarea id=\"sql-code\"><\/textarea>\n        <\/div>\n        \n        <!-- Draggable Resizer -->\n        <div class=\"sql-resizer\" id=\"resizer\">\n            <i class=\"fa-solid fa-arrows-left-right\"><\/i>\n        <\/div>\n\n        <!-- Mobile Sandwiched Tabs (Hidden on Desktop) -->\n        <div class=\"mobile-tabs-container\">\n            <div class=\"sql-tabs\">\n                <button class=\"sql-tab active\" data-target=\"output\">\n                    <i class=\"fa-solid fa-arrow-right-to-bracket\"><\/i> Output\n                <\/button>\n                <button class=\"sql-tab\" data-target=\"schema\">\n                    <i class=\"fa-solid fa-diagram-project\"><\/i> Schema\n                <\/button>\n                <button class=\"sql-tab\" data-target=\"tables\">\n                    <i class=\"fa-solid fa-database\"><\/i> Tables\n                <\/button>\n            <\/div>\n        <\/div>\n\n        <div class=\"sql-output-pane\" id=\"output-pane\">\n            <div id=\"tab-output\" class=\"tab-content active\">\n                <p class=\"placeholder-text\">Run your code to see the output here.<\/p>\n            <\/div>\n            <div id=\"tab-schema\" class=\"tab-content\">\n                <p class=\"placeholder-text\">Loading Schema...<\/p>\n            <\/div>\n            <div id=\"tab-tables\" class=\"tab-content\">\n                <p class=\"placeholder-text\">Loading Tables...<\/p>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/div>\n\n<style>\n    \/* Sleek Custom Scrollbars *\/\n    .sql-ide-container *::-webkit-scrollbar { width: 8px; height: 8px; }\n    .sql-ide-container *::-webkit-scrollbar-track { background: #f1f1f1; border-radius: 4px; }\n    .sql-ide-container *::-webkit-scrollbar-thumb { background: #c1c1c1; border-radius: 4px; }\n    .sql-ide-container *::-webkit-scrollbar-thumb:hover { background: #a8a8a8; }\n\n    \/* Main Layout - Permanent Light Theme *\/\n    .sql-ide-container {\n        font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif;\n        background: #ffffff;\n        color: #333333;\n        border: 1px solid #ddd;\n        border-radius: 8px;\n        overflow: hidden;\n        display: flex;\n        flex-direction: column;\n        height: 650px;\n        box-shadow: 0 5px 20px rgba(0,0,0,0.08);\n        margin: 20px 0;\n        box-sizing: border-box;\n    }\n    .sql-ide-container * { box-sizing: border-box; }\n    \n    \/* Native Fullscreen Fix *\/\n    .sql-ide-container:fullscreen, \n    .sql-ide-container:-webkit-full-screen,\n    .sql-ide-container.fallback-fullscreen {\n        width: 100vw !important;\n        height: 100vh !important;\n        max-width: 100% !important;\n        margin: 0 !important; \n        border: none !important;\n        border-radius: 0 !important;\n    }\n    .sql-ide-container.fallback-fullscreen {\n        position: fixed !important;\n        top: 0 !important; left: 0 !important;\n        z-index: 999999 !important;\n    }\n    \n    \/* Header Styles *\/\n    .sql-ide-header {\n        display: flex; background: #f8f9fa; border-bottom: 1px solid #e0e0e0;\n        height: 60px; flex-shrink: 0;\n    }\n    .sql-header-left, .sql-header-right { flex: 1; display: flex; align-items: center; padding: 0 20px; }\n    .sql-header-left { border-right: 1px solid #e0e0e0; justify-content: space-between; }\n    .sql-title { font-weight: bold; font-size: 16px; color: #111; }\n    .sql-icons { display: flex; gap: 15px; color: #666; font-size: 16px; }\n    .sql-icons i { cursor: pointer; transition: color 0.2s; }\n    .sql-icons i:hover { color: #000; }\n    .sql-run-btn {\n        background: #0073aa; color: #fff; border: none; padding: 8px 18px; \n        border-radius: 5px; font-weight: 600; cursor: pointer; font-size: 14px; transition: background 0.2s;\n    }\n    .sql-run-btn:hover { background: #005177; }\n   .sql-tab:hover {\n    background: none !important;\n    color: #666 !important; }\n    \/* Tabs Styling *\/\n    .sql-tabs { display: flex; height: 100%; gap: 50px; }\n    .sql-tab {\n        background: none; border: none; color: #666; font-size: 15px; font-weight: 500; cursor: pointer;\n        height: 100%; align-items: center; gap: 8px; border-bottom: 2px solid transparent; padding: 0;\n    }\n      .sql-tab.active {\n    background: transparent;\n    border-bottom: 2px solid #0073aa;\n    color: #666; \/* same as normal tab *\/ }\n\n    \/* Mobile Tabs Container (Hidden by Default) *\/\n    .mobile-tabs-container { display: none; }\n\n    \/* Body & Panes *\/\n    .sql-ide-body { display: flex; flex: 1; height: calc(100% - 60px); overflow: hidden; width: 100%; }\n    .sql-editor-pane { width: calc(50% - 6px); display: flex; flex-direction: column; overflow: hidden; }\n    \n    \/* Draggable Resizer *\/\n    .sql-resizer {\n        width: 12px; background: #f1f1f1; cursor: col-resize; display: flex; align-items: center; justify-content: center;\n        border-left: 1px solid #e0e0e0; border-right: 1px solid #e0e0e0; z-index: 10; user-select: none; color: #aaa; font-size: 10px;\n    }\n    .sql-resizer:hover, .sql-resizer.dragging { background: #e0e0e0; color: #333; }\n\n    .sql-output-pane { flex: 1; padding: 20px; overflow-y: auto; overflow-x: auto; background: #ffffff; min-width: 150px; }\n\n    \/* CodeMirror Overrides *\/\n    .CodeMirror { flex: 1; height: 100% !important; width: 100% !important; font-family: 'Consolas', 'Courier New', monospace; font-size: 14px; background: #ffffff !important; }\n    .CodeMirror-gutters { background: #f8f9fa !important; border-right: 1px solid #e0e0e0 !important; }\n\n    \/* Data Tables Formatting *\/\n    .sql-data-table { width: 100%; border-collapse: collapse; margin-bottom: 30px; font-size: 13px; color: #333; background: #fff; }\n    .sql-data-table th, .sql-data-table td { border: 1px solid #ddd; padding: 10px 14px; text-align: left; }\n    .sql-data-table th { font-weight: bold; background: #f1f1f1; color: #111; }\n    \n    .schema-info { margin-bottom: 20px; }\n    .schema-info p { margin: 5px 0; font-size: 14px; color: #444; }\n    .schema-info p strong { color: #111; }\n    .table-title { font-size: 18px; margin-bottom: 10px; color: #111; font-weight: bold; }\n\n    .tab-content { display: none; }\n    .tab-content.active { display: block; }\n    .placeholder-text { color: #888; text-align: center; margin-top: 80px; font-size: 15px; }\n\n    \/* Mobile adjustments *\/\n    @media (max-width: 850px) {\n        .sql-ide-container { height: auto; min-height: 800px; }\n        .sql-ide-header { flex-direction: column; height: auto; }\n        .sql-header-left { border-right: none; border-bottom: 1px solid #e0e0e0; padding: 15px 20px; width: 100%; justify-content: space-between; flex-wrap: wrap; gap: 15px; }\n        .sql-header-right { display: none; } \/* Hide Header Tabs on Mobile *\/\n        \n        .sql-ide-body { flex-direction: column; height: auto; overflow: visible; }\n        .sql-editor-pane { width: 100% !important; height: 350px; flex: none; border-bottom: 1px solid #e0e0e0; }\n        .sql-resizer { display: none; }\n        \n        \/* Show Sandwiched Tabs on Mobile *\/\n        .mobile-tabs-container { \n            display: block; \n            width: 100%; \n            background: #ffffff; \n            border-bottom: 1px solid #e0e0e0; \n        }\n        .mobile-tabs-container .sql-tabs {\n            height: 50px; \n            gap: 20px; \/* Overwritten slightly from 50px so they don't overflow small phone screens *\/\n            justify-content: flex-start; \n            padding: 0 20px;\n        }\n\n        .sql-output-pane { \n            width: 100% !important; \n            height: 450px; \n            flex: none; \n            background: #f8f9fa; \/* Lighter background matching screenshot *\/\n        }\n    }\n    .table-responsive-wrapper { overflow-x: auto; width: 100%; }\n<\/style>\n\n<script>\ndocument.addEventListener(\"DOMContentLoaded\", function() {\n    let db;\n    const defaultSQL = `-- Online SQL Editor to Run SQL Online.\n-- Use the editor to create new tables, insert data and all other SQL operations.\n\nSELECT * from employees;`;\n\n    \/\/ 1. Initialize CodeMirror Editor\n    const editor = CodeMirror.fromTextArea(document.getElementById(\"sql-code\"), {\n        mode: \"text\/x-sql\", theme: \"default\", lineNumbers: true, lineWrapping: true\n    });\n    editor.setValue(defaultSQL);\n\n    \/\/ 2. Initialize SQL.js Database\n    const config = { locateFile: filename => `https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/sql.js\/1.8.0\/${filename}` };\n    \n    function initDB() {\n        initSqlJs(config).then(function(SQL){\n            db = new SQL.Database();\n            db.run(`\n                CREATE TABLE orders (ord_no INT, purch_amt DOUBLE, ord_date VARCHAR(512), customer_id INT, salesman_id INT);\n                INSERT INTO orders VALUES (70009, 270.65, '2012-09-10', 3001, 5005), (70002, 65.26, '2012-10-05', 3002, 5001),\n                (70004, 110.5, '2012-08-17', 3009, 5003), (70005, 2400.6, '2012-07-27', 3007, 5001),\n                (70008, 5760, '2012-09-10', 3002, 5001), (70010, 1983.43, '2012-10-10', 3004, 5006),\n                (70003, 2480.4, '2012-10-10', 3009, 5003), (70011, 75.29, '2012-08-17', 3003, 5007);\n\n                CREATE TABLE employees(id integer, name text, designation text, manager integer, hired_on date, salary integer, commission float, dept integer);\n                INSERT INTO employees VALUES (1, 'JOHNSON', 'ADMIN', 6, '1990-12-17', 18000, NULL, 4),\n                (2, 'HARDING', 'MANAGER', 9, '1998-02-02', 52000, 300, 3), (3, 'TAFT', 'SALES I', 2, '1996-01-02', 25000, 500, 3),\n                (4, 'HOOVER', 'SALES I', 2, '1990-04-02', 27000, NULL, 3), (5, 'LINCOLN', 'TECH', 6, '1994-06-23', 22500, 1400, 4),\n                (6, 'GARFIELD', 'MANAGER', 9, '1993-05-01', 54000, NULL, 4), (7, 'POLK', 'TECH', 6, '1997-09-22', 25000, NULL, 4),\n                (8, 'GRANT', 'ENGINEER', 10, '1997-03-30', 32000, NULL, 2), (9, 'JACKSON', 'CEO', NULL, '1990-01-01', 75000, NULL, 4),\n                (10, 'FILLMORE', 'MANAGER', 9, '1994-08-09', 56000, NULL, 2), (11, 'ADAMS', 'ENGINEER', 10, '1996-03-15', 34000, NULL, 2);\n            `);\n            renderSchema(); renderTables();\n        });\n    }\n    initDB();\n\n    \/\/ 3. UI Selectors\n    const runBtn = document.getElementById(\"btn-run\");\n    const refreshBtn = document.getElementById(\"btn-refresh\");\n    const expandBtn = document.getElementById(\"btn-expand\");\n    const ideContainer = document.getElementById(\"sql-ide\");\n    \n    \/\/ Select ALL tabs (Desktop & Mobile)\n    const tabs = document.querySelectorAll(\".sql-tab\");\n    const contents = document.querySelectorAll(\".tab-content\");\n    const outputDiv = document.getElementById(\"tab-output\");\n    const schemaDiv = document.getElementById(\"tab-schema\");\n    const tablesDiv = document.getElementById(\"tab-tables\");\n\n    \/\/ 4. Resizer Logic\n    const resizer = document.getElementById('resizer');\n    const leftPane = document.getElementById('editor-pane');\n    let isDragging = false;\n\n    resizer.addEventListener('mousedown', function(e) {\n        isDragging = true; resizer.classList.add('dragging'); document.body.style.cursor = 'col-resize'; e.preventDefault(); \n    });\n    document.addEventListener('mousemove', function(e) {\n        if (!isDragging) return;\n        const containerRect = ideContainer.getBoundingClientRect();\n        let newWidth = e.clientX - containerRect.left;\n        if (newWidth < 150) newWidth = 150; \n        if (newWidth > containerRect.width - 150) newWidth = containerRect.width - 150;\n        let widthPercent = (newWidth \/ containerRect.width) * 100;\n        leftPane.style.width = `${widthPercent}%`;\n    });\n    document.addEventListener('mouseup', function() {\n        if (isDragging) { isDragging = false; resizer.classList.remove('dragging'); document.body.style.cursor = 'default'; editor.refresh(); }\n    });\n\n    \/\/ 5. Tabs Logic (Sync both Desktop & Mobile Tabs)\n    tabs.forEach(tab => {\n        tab.addEventListener(\"click\", () => {\n            tabs.forEach(t => t.classList.remove(\"active\")); \n            contents.forEach(c => c.classList.remove(\"active\"));\n            \n            const target = tab.dataset.target;\n            \n            \/\/ Set ALL matching tabs (Mobile + Desktop) to active\n            document.querySelectorAll(`.sql-tab[data-target=\"${target}\"]`).forEach(t => {\n                t.classList.add(\"active\");\n            });\n            \n            document.getElementById(\"tab-\" + target).classList.add(\"active\");\n            if (target === \"schema\") renderSchema();\n            if (target === \"tables\") renderTables();\n        });\n    });\n\n    \/\/ 6. Run Query Logic\n    runBtn.addEventListener(\"click\", function() {\n        document.querySelectorAll('.sql-tab[data-target=\"output\"]')[0].click();\n        let query = editor.getValue();\n        if(!db) return;\n        try {\n            let results = db.exec(query);\n            if (results.length === 0) {\n                outputDiv.innerHTML = \"<p style='color:#198754; font-weight:bold;'>Command executed successfully.<\/p>\";\n                renderSchema(); renderTables(); return;\n            }\n            let finalHtml = \"\";\n            results.forEach(res => {\n                let html = \"<div class='table-responsive-wrapper'><table class='sql-data-table'><thead><tr>\";\n                res.columns.forEach(col => html += `<th>${col}<\/th>`);\n                html += \"<\/tr><\/thead><tbody>\";\n                res.values.forEach(row => {\n                    html += \"<tr>\";\n                    row.forEach(val => html += `<td>${val !== null ? val : '-'}<\/td>`);\n                    html += \"<\/tr>\";\n                });\n                html += \"<\/tbody><\/table><\/div>\";\n                finalHtml += html;\n            });\n            outputDiv.innerHTML = finalHtml;\n        } catch(err) { outputDiv.innerHTML = `<p style=\"color:#dc3545; font-weight:bold;\">Error: ${err.message}<\/p>`; }\n    });\n\n    \/\/ 7. Schema and Table Generation\n    function renderTables() {\n        if(!db) return;\n        try {\n            let res = db.exec(\"SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%';\");\n            if(res.length === 0 || !res[0]) { tablesDiv.innerHTML = \"<p class='placeholder-text'>No tables exist.<\/p>\"; return; }\n            let html = \"\";\n            res[0].values.forEach(row => {\n                let tableName = row[0]; let tableData = db.exec(`SELECT * FROM ${tableName}`);\n                html += `<div class=\"table-title\">${tableName}<\/div>`;\n                if(tableData.length > 0) {\n                    html += \"<div class='table-responsive-wrapper'><table class='sql-data-table'><thead><tr>\";\n                    tableData[0].columns.forEach(col => html += `<th>${col}<\/th>`);\n                    html += \"<\/tr><\/thead><tbody>\";\n                    tableData[0].values.forEach(dataRow => {\n                        html += \"<tr>\"; dataRow.forEach(val => html += `<td>${val !== null ? val : '-'}<\/td>`); html += \"<\/tr>\";\n                    });\n                    html += \"<\/tbody><\/table><\/div>\";\n                } else { html += \"<p style='color:#6c757d; font-size:13px;'>Table is empty.<\/p>\"; }\n            });\n            tablesDiv.innerHTML = html;\n        } catch(e) {}\n    }\n\n    function renderSchema() {\n        if(!db) return;\n        try {\n            let res = db.exec(\"SELECT name, sql FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%';\");\n            if(res.length === 0 || !res[0]) { schemaDiv.innerHTML = \"<p class='placeholder-text'>No tables exist.<\/p>\"; return; }\n            let html = \"\";\n            res[0].values.forEach(row => {\n                let tableName = row[0]; let tableInfo = db.exec(`PRAGMA table_info('${tableName}')`);\n                html += `<div class=\"schema-info\"><p><strong>Table Name :<\/strong> ${tableName}<\/p><p><strong>Schema :<\/strong> ${row[1]}<\/p><\/div>`;\n                if(tableInfo.length > 0) {\n                    html += `<div class='table-responsive-wrapper'><table class='sql-data-table'><thead><tr><th>Column Name<\/th><th>Type<\/th><th>Schema<\/th><\/tr><\/thead><tbody>`;\n                    tableInfo[0].values.forEach(infoRow => { html += `<tr><td>${infoRow[1]}<\/td><td>${infoRow[2]}<\/td><td>${infoRow[1]} ${infoRow[2]}<\/td><\/tr>`; });\n                    html += `<\/tbody><\/table><\/div>`;\n                }\n            });\n            schemaDiv.innerHTML = html;\n        } catch(e) {}\n    }\n\n    \/\/ 8. Top Menu Buttons\n    refreshBtn.addEventListener(\"click\", () => {\n        editor.setValue(defaultSQL); initDB();\n        outputDiv.innerHTML = '<p class=\"placeholder-text\">Run your code to see the output here.<\/p>';\n        document.querySelectorAll('.sql-tab[data-target=\"output\"]')[0].click();\n    });\n\n    \/\/ --- NEW NATIVE FULLSCREEN LOGIC ---\n    function toggleFullscreen() {\n        if (!document.fullscreenElement && !document.webkitFullscreenElement) {\n            \/\/ Enter Fullscreen Native\n            if (ideContainer.requestFullscreen) {\n                ideContainer.requestFullscreen();\n            } else if (ideContainer.webkitRequestFullscreen) { \/* Safari *\/\n                ideContainer.webkitRequestFullscreen();\n            } else {\n                \/\/ Fallback for older browsers\n                ideContainer.classList.add(\"fallback-fullscreen\");\n                updateFullscreenIcon(true);\n            }\n        } else {\n            \/\/ Exit Fullscreen Native\n            if (document.exitFullscreen) {\n                document.exitFullscreen();\n            } else if (document.webkitExitFullscreen) { \/* Safari *\/\n                document.webkitExitFullscreen();\n            } else {\n                ideContainer.classList.remove(\"fallback-fullscreen\");\n                updateFullscreenIcon(false);\n            }\n        }\n    }\n\n    expandBtn.addEventListener(\"click\", toggleFullscreen);\n\n    \/\/ Watch for Native Fullscreen Changes (e.g. user pressing ESC key)\n    function handleFullscreenChange() {\n        const isFS = document.fullscreenElement || document.webkitFullscreenElement || ideContainer.classList.contains(\"fallback-fullscreen\");\n        updateFullscreenIcon(isFS);\n    }\n    document.addEventListener(\"fullscreenchange\", handleFullscreenChange);\n    document.addEventListener(\"webkitfullscreenchange\", handleFullscreenChange);\n\n    function updateFullscreenIcon(isFullscreen) {\n        expandBtn.className = isFullscreen ? \"fa-solid fa-compress\" : \"fa-solid fa-expand\";\n        setTimeout(() => editor.refresh(), 100); \/\/ Fixes layout on screen resize\n    }\n\n    setTimeout(() => editor.refresh(), 200);\n});\n<\/script>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-this-online-sql-compiler-works\"><strong>How This Online SQL Compiler Works<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1-explore-the-schema-tables\"><strong>1. Explore the Schema &amp; Tables<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The tool loads instantly with two pre-built sample tables: <strong>employees<\/strong> and <strong>orders<\/strong>.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Schema tab:<\/strong> View the structural blueprints, including column names and data types (e.g., INTEGER, VARCHAR).<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tables tab:<\/strong> Access the complete raw data currently stored in the database.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2-write-your-sql-queries\"><strong>2. Write Your SQL Queries<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the professional <strong>code editor<\/strong> to write custom SQL commands.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Features include <strong>syntax highlighting<\/strong>, <strong>line numbers<\/strong>, and <strong>text-wrapping<\/strong> for easier coding.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Practice beyond SELECT statements: try INSERT, UPDATE, DELETE, or even CREATE TABLE to build your own datasets from scratch.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3-run-analyze-instantly\"><strong>3. Run &amp; Analyze Instantly<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the <strong>\"Run Code\"<\/strong> button to execute commands directly in your browser.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Results automatically appear in the <strong>Output tab<\/strong>, displayed in a clean, easy-to-read grid.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4-customize-your-workspace\"><strong>4. Customize Your Workspace<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Distraction-Free:<\/strong> Click the <strong>Fullscreen icon<\/strong> (arrows) to expand the compiler across your entire monitor.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Adjustable Layout:<\/strong> On desktop screens, drag the vertical slider to resize the code editor or output panel.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Start Over:<\/strong> Made a mistake or deleted a table? Click the <strong>Refresh icon<\/strong> to reset the code and restore the default database instantly.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Online SQL Compiler Run Code Output Schema Tables Output Schema Tables Run your code to see the output here. Loading Schema... Loading Tables... How This Online SQL Compiler Works 1. Explore the Schema &amp; Tables 2. Write Your SQL Queries 3. Run &amp; Analyze Instantly 4. Customize Your Workspace<\/p>\n","protected":false},"author":41,"featured_media":111310,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[25860],"tags":[],"class_list":["post-107320","page","type-page","status-publish","has-post-thumbnail","hentry","category-software"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Online SQL Compiler and Editor<\/title>\n<meta name=\"description\" content=\"Run and practice your SQL queries online with this Online SQL Compiler.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online SQL Compiler\" \/>\n<meta property=\"og:description\" content=\"Run and practice your SQL queries online with this Online SQL Compiler.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1198\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"Online SQL Compiler\",\"datePublished\":\"2025-05-09T14:52:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/\"},\"wordCount\":207,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/sql-compiler.png\",\"articleSection\":[\"IT\\\/Software Development\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/\",\"name\":\"Online SQL Compiler and Editor\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/sql-compiler.png\",\"datePublished\":\"2025-05-09T14:52:50+00:00\",\"description\":\"Run and practice your SQL queries online with this Online SQL Compiler.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/sql-compiler.png\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/sql-compiler.png\",\"width\":1198,\"height\":627,\"caption\":\"online sql compiler\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-editor-tool\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online SQL Compiler\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill &amp; Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Online SQL Compiler and Editor","description":"Run and practice your SQL queries online with this Online SQL Compiler.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/","og_locale":"en_US","og_type":"article","og_title":"Online SQL Compiler","og_description":"Run and practice your SQL queries online with this Online SQL Compiler.","og_url":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","og_image":[{"width":1198,"height":627,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@Great_Learning","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"Online SQL Compiler","datePublished":"2025-05-09T14:52:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/"},"wordCount":207,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png","articleSection":["IT\/Software Development"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/","url":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/","name":"Online SQL Compiler and Editor","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png","datePublished":"2025-05-09T14:52:50+00:00","description":"Run and practice your SQL queries online with this Online SQL Compiler.","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png","width":1198,"height":627,"caption":"online sql compiler"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-editor-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Online SQL Compiler"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill &amp; Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png",1198,627,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-150x150.png",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-300x157.png",300,157,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-768x402.png",768,402,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-1024x536.png",1024,536,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png",1198,627,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler.png",1198,627,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-640x627.png",640,627,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-96x96.png",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2025\/08\/sql-compiler-150x79.png",150,79,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"Online SQL Compiler Run Code Output Schema Tables Output Schema Tables Run your code to see the output here. Loading Schema... Loading Tables... How This Online SQL Compiler Works 1. Explore the Schema &amp; Tables 2. Write Your SQL Queries 3. Run &amp; Analyze Instantly 4. Customize Your Workspace","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/pages\/107320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=107320"}],"version-history":[{"count":44,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/pages\/107320\/revisions"}],"predecessor-version":[{"id":116082,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/pages\/107320\/revisions\/116082"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/111310"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=107320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=107320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=107320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}