SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE books (id INTEGER PRIMARY KEY, title TEXT, author_name TEXT);
✓
INSERT INTO books (title, author_name) VALUES ('Clean Code', 'Uncle Bob');
✓
INSERT INTO books (title, author_name) VALUES ('Fluent Python', 'Luciano Ramalho');
✓
INSERT INTO books (title, author_name) VALUES ('Introduction to Algorithms', 'Cormen, Leiserson, Rivest, Stein');
✓
SELECT * FROM books;


id
title
author_name


1
Clean Code
Uncle Bob

2
Fluent Python
Luciano Ramalho

3
Introduction to Algorithms
Cormen, Leiserson, Rivest, Stein

id	title	author_name
1	Clean Code	Uncle Bob
2	Fluent Python	Luciano Ramalho
3	Introduction to Algorithms	Cormen, Leiserson, Rivest, Stein