Hands-on task
Your first SELECT: a price list
The manager needs a price list: the name and price of every product in the goods table of the /root/shop.db database.
Save them to /root/prices.txt: one line per product, name first, then price, separated by | — the way sqlite3 prints by default. There must be no other columns and no header line in the file. Any order of lines is fine.
- sqlite3
- select
- choosing columns
- output redirection