Hands-on task
CREATE TABLE: a suppliers table
The shop needs a suppliers table. Create a suppliers table in the /root/shop.db database with three columns:
id— a whole number, the primary key (the row's number, the database assigns it itself);name— text;phone— text.
Then add the first supplier to it: name Kitchen-Pro, phone +15550101234.
- sqlite3
- create table
- column types
- primary key