This very demo is based on this post and utilizes the data from there.
cargo run --locked
You have now 3 tables available userdata1
, userdata2
and userdata3
Now you can interactively run sql queries like in a REPL.
- select only one column
sql ❯ select first_name from userdata3
- distinct select only one column
sql ❯ select distinct first_name from userdata3
- Union a projection of the different data tables
sql ❯ select distinct first_name from userdata3 union select first_name from userdata2 order by 1
- Substring matching
sql ❯ select * from userdata1 where first_name like '%ill%'