S

@Szheng25

Pink (clothing table)

SQL
3 years ago
/* CREATE TABLE - creates the database*/ /* entry afterward - name of database*/ /* (column_name, column_type, primary_key = true or false)*/ --ratings will be 1 (lowest) to 10 (highest)-- --set-up of schema-- CREATE TABLE pink (pink_id INTEGER PRIMARY KEY, product TEXT, cost INTEGER, stock INTEGER, rating INTEGER);