Write create, read, update, delete operations.
Use the records table. Add one record, modify one existing record, remove one record, and return the remaining records.
record_id, record_name, status, and score.record_id ascending.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique record identifier |
| record_name | VARCHAR(100) | Name of the record |
| status | VARCHAR(20) | Current record status |
| score | INT | Optional numeric score |