https://sqliteonline.com/ Wait * * File * Owner DB * Run * Team * Export * Import SQL.BanD for Business * * * [INS::INS] * 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 * 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 * SqLite Use technology supported by your browser, select version (wasm or asm.js): [default ] * Left Menu DBlClick - SELECT Table * Editor Disable autocomplite * Skins [Default] Hover cell [None ] SQL Online 22.5.19.5-2021 .Concept.toDream (c) 2021 Kirill N. z@sqliteonline.com upTime Server: OVH DO Vultr Hetzner DNS: ClouDNS * Powered by * 3.36.0 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 * 18c Oracle XE https://www.oracle.com/database/technologies/appdev/xe.html * 4.7.0 Font-Awesome The iconic font and CSS toolkit https://github.com/FortAwesome/Font-Awesome * 1.3.3 FileSaver.js An HTML5 saveAs() FileSaver implementation https://github.com/eligrey/FileSaver.js * 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 * 2019.+ jetBrains The company offers an extended family of integrated development environments IDE https://www.jetbrains.com/ [ ][ ][ ]