SQL Online Compiler - For Data Science

Wait Hint: click "Button Save" (Top-Right)

Syntax

• Table
• Syntax
• History

Chart for Data Science

-- Change first word "SELECT" to "LINE-SELECT" SELECT LINE-SELECT ​ -- labels - first column -- values - all columns 2..N -- color column key - "_c": name_cFF00FF (HEX6) -- Example : LINE-SELECT name as label, cos(id) as cos_c1ab394, sin(id) as sin_cFF0000 FROM demo; -- Example : AREA-SELECT id as x, id as y FROM demo; -- Example : BAR-SELECT name as label, id as y FROM demo; -- Example : PIE-SELECT name as label, id as y FROM demo;

• History
• About

History

• for SQLite: NEW migrating to sqlite.org/wasm (from sql.js) UPD no 4mb query limit ADD regexp function ADD tooltip description for multi query UPD 1001 micro-modifications 04.2024

• new concept ...2024

• Concept generation 2 2023

• ADD Format number in table 11.2023

• UPD Multi share-connect UPD 1001 micro-modifications 9.2023

• NEW Auto-save TAB 3.2023

• NEW Clipboard to SQL ADD share-connect: simple link and password ADD SQLite enabled bigint UPD 1001 micro-modifications 2.2023

• NEW Color settings ADD color theme "Dark" ADD color theme "Night" 11.2022

• NEW SQLite server, share connect-link ADD show result from history ADD copy result from history UPD share link for: MariaDB, PostgreSQL, MS SQL 10.2022

• New design Editor/Table four position Native scroll for table History saves the last 10 results 9.2022

• FIX iOS height FIX iOS ContextMenu ADD Copy all table 4.2022

• UPD MariaDB server UPD PostgreSQL server UPD MS SQL server ADD info from Oracle 12.2021

• FIX left menu for mobile FIX left menu scroll 10.2021

• UPD left menu, ADD multi >-< multi databases DEL Share sqlite DB ADD Share cloud script UPD 1001 micro-modifications Remove lib MetisMenu 8.2021

• ADD select query(text) RUN. 7.2021

• FIX xss injections, Thanks Luis Madero https://twitter.com/_Y000_ 5.2021

• Docker - SOE Mysql (0.0.6), Docker - SOE MariaDB (0.0.6): UPD Multi-Level Security block UPD Use memory ADD Time query Docker - SQLite Server (0.0.6-3.35.4): UPD Multi-Level Security block 4.2021

• ADD Docker - SQLite Server ADD Time query (only "soe 0.0.4+" - Docker version) UPD Import UPD 1001 micro-modifications 3.2021

• ADD Sort left menu ADD Search in left menu (Table, Column, Type, Index, Trigger, Procedure, Function, ..) Example: NameSearch #TypeSearch NameSearch#TypeSearch 1.2021

• ADD Docker - PostgreSQL ADD Docker - MySQL ADD Docker - MariaDB 12.2020

• UPD SQL.js ADD JSON1 (SQL.js) ADD FTS5 (SQL.js) 11.2020

• ADD Import: MariaDB, PostgrSQL, MS SQL UPD Intelligent-Import UPD Cloud User Script 10.2020

• ADD Hover cell ADD SQLite 3.33.0 UPD Stealth size bar in block UPD Left-Menu UPD Export UPD Import FIX Multi-PK 8.2020

• FIX Visual-UPDATE ADD SQLite 3.32.1 ADD Save columns size 5.2020

• ADD Multi-result ADD Short CODE: ct sf tableName ii tableName us tableName uw tableName df tableName dw tableName 4.2020

• ADD Visual Sort column ADD Team-Work MariaDB ADD Team-Work MS SQL Server UPD MultiSyntax SQL 3.2020

• NEW 1001+ UX ADD New Chart ADD Team-Work PostgreSQL Remove jQuery and all lib use 2.2020

• ADD MS SQL Server - test ADD Oracle - test ADD NEW Scroll ADD Resize box ADD PostgreSQL - Export ADD MariaDB - Export ADD PostgreSQL - test ADD Visual-Edit MariaDB ADD Visual-Edit PostgreSQL 10.2019

• ADD MariaDB - test UPD Visual DROP COLUMN + Syntax SQL UPD WASM default UPD Left menu ADD Visual DROP COLUMN + Syntax SQL UPD MultiVersion to WASM UPD Visual ADD COLUMN 07.2019

• ADD Visual ADD COLUMN + Syntax SQL FIX Visual RENAME UPD Import SQL UPD Export CSV FIX db-save name ADD date release ADD Visual RENAME + Syntax SQL UPD Left menu UPD Import CSV FIX Export Schema UPD Code editor UPD AI.Help 6.2019

• UPD Left menu sql schema FIX Visual TEST SQLite.wasm ADD Visual UPDATE + Syntax SQL ADD Visual DELETE + Syntax SQL UPD Visual INSERT + Syntax SQL 5.2019

• UPD Default 3.28.0 FIX display text ADD Chart.test 4.2019

• FIX Edge UPD Default 3.27.2 UPD 1001 micro-modifications ADD Geo-Balancing UPD Export JSON ADD Menu table - Export JSON 2.2019

• UPD module library ADD Dark style ADD Test Premium 1.2019

• ADD Scroll columns ADD Width column ADD auto-Width columns ADD Visual adding of ROW (INT, TEXT, BLOB) UPD Default 3.26.0 12.2018

• ADD MultiVersion + 3.25.3 FIX Import CSV UPD Default 3.25.2 11.2018

• ADD MultiVersion + 3.25.2 ADD MultiVersion + 3.25.0, 3.25.1 9.2018

• FIX "table already exists" ADD MultiVersion many changes 8.2018

• UPD Sqlite 3.24.0 6.2018

• UPD Sqlite 3.23.1 ADD table setting col ADD "Open row" ai.link ADD "Open row" ai.color FIX back 5.2018

• ADD "Open row" ai.image 4.2018

• First version 2014

Settings

• Left Menu DBlClick - SELECT Table
• Editor Disable autocomplite
• Disable the message about changes when the site is closed. (will work after the next load)
• Skins

  Silver Purplish Mil Antique Brass Blue Steel Indigo Tangerine Pink Frost Dark Night User color

  Color settings

• Table

  Hover cell None Animation Rectangle

  Format number None Left Right L_ _R

SQL Online

0.3.9 - 2024 .Concept (.NewEra) © 2024 Kirill N. z@sqliteonline.com

• Powered by

• 3.45.2

  SqLite

  - is a relational database management system contained in a C programming library. http://sqlite.org/
• 1.5.0

  Sql.js

  SQLite compiled to JavaScript through Emscripten https://github.com/sql-js/sql.js
• 10

  MariaDB

  https://mariadb.org
• 12

  PostgreSQL

  https://www.postgresql.org
• 2019

  MS SQL Server Express

  https://www.microsoft.com/en-us/sql-server/sql-server-editions-express
• 4.7.0

  Font-Awesome

  The iconic font and CSS toolkit https://github.com/FortAwesome/Font-Awesome
• 5.62.0

  CodeMirror

  In-browser code editor https://github.com/codemirror/CodeMirror/

• Toastify

  https://github.com/apvarun/toastify-js

• Chart.js

  https://github.com/chartjs/Chart.js

• RGB-LAB

  - comparing the difference between RGB colors https://github.com/antimatter15/rgb-lab
• 2019.+

  jetBrains

  The company offers an extended family of integrated development environments IDE https://www.jetbrains.com/