Fossil

Sandbox
Login

Sandbox

This Is The Title

A level-1 heading

This is the wiki sandbox.

A link to the index page:  here

Create a new wiki page

SVG is supported by Markdown:

<svg height="180" width="500"> <polyline points="0,40 40,40 40,80 80,80 80,120 120,120 120,160" style="fill:white;stroke:red;stroke-width:4" /> Sorry, your browser does not support inline SVG. </svg>

CREATE TABLE t1(a,b);
INSERT INTO t1(rowid,a,b) VALUES
  (10,'a','b'),
  (20,'c','d'),
  (30,'e','f');
.header on
.mode  box
SELECT rowid, * FROM t1;
┌───────┬───┬───┐
│ rowid │ a │ b │
├───────┼───┼───┤
│ 10    │ a │ b │
│ 20    │ c │ d │
│ 30    │ e │ f │
└───────┴───┴───┘
VACUUM;
SELECT rowid, * FROM t1;
┌───────┬───┬───┐
│ rowid │ a │ b │
├───────┼───┼───┤
│ 1     │ a │ b │
│ 2     │ c │ d │
│ 3     │ e │ f │
└───────┴───┴───┘

Link to Documentation outline