/storage/emulated/0 $ cd Download/sqlite337/*0
/storage/emulated/0/Download/sqlite337/sqlite-amalgamation-3370000 $ gcc -DSQLITE_THREADSAFE=0 shell.c sqlite3.c -ldl -lm -o sqlite3
/storage/emulated/0/Download/sqlite337/sqlite-amalgamation-3370000 $
/storage/emulated/0/Download/sqlite337/sqlite-amalgamation-3370000 $
/storage/emulated/0/Download/sqlite337/sqlite-amalgamation-3370000 $ ls
shell.c sqlite3 sqlite3.c sqlite3.h sqlite3ext.h
/storage/emulated/0/Download/sqlite337/sqlite-amalgamation-3370000 $ ./sqlite3
SQLite version 3.37.0 2021-11-27 14:13:22
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
/storage/emulated/0 $ cd Download/sqlite337/*0
/storage/emulated/0/Download/sqlite337/sqlite-amalgamation-3370000 $ ./sqlite3
SQLite version 3.37.0 2021-11-27 14:13:22
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .mode
current output mode: list
sqlite> .mode column
sqlite> select 42 a;
a
--
42
sqlite> with recursive t as (select 1 a union all select a+1 from t where a 10)select * from t;
a
--
1
2
3
4
5
6
7
8
9
10
sqlite>
