Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
1.3 kB
2
Indexable
Never
Certainly, here are the SQL statements to insert one value at a time for each table:

For Sailors table:
```sql
INSERT INTO Sailors (sid, sname, rating, age) VALUES (101, 'Jack', 8, 25);
INSERT INTO Sailors (sid, sname, rating, age) VALUES (102, 'Emily', 7, 28);
INSERT INTO Sailors (sid, sname, rating, age) VALUES (103, 'David', 6, 22);
INSERT INTO Sailors (sid, sname, rating, age) VALUES (104, 'Sarah', 9, 30);
INSERT INTO Sailors (sid, sname, rating, age) VALUES (105, 'Michael', 5, 27);
```

For Boats table:
```sql
INSERT INTO Boats (bid, bname, color) VALUES (201, 'Sea Queen', 'Blue');
INSERT INTO Boats (bid, bname, color) VALUES (202, 'Sunset', 'Red');
INSERT INTO Boats (bid, bname, color) VALUES (203, 'Voyager', 'White');
INSERT INTO Boats (bid, bname, color) VALUES (204, 'Marina', 'Green');
INSERT INTO Boats (bid, bname, color) VALUES (205, 'Wave Rider', 'Yellow');
```

For Reserves table:
```sql
INSERT INTO Reserves (sid, bid, day) VALUES (101, 201, '01-Apr-2024');
INSERT INTO Reserves (sid, bid, day) VALUES (102, 202, '03-Apr-2024');
INSERT INTO Reserves (sid, bid, day) VALUES (103, 203, '05-Apr-2024');
INSERT INTO Reserves (sid, bid, day) VALUES (104, 204, '07-Apr-2024');
INSERT INTO Reserves (sid, bid, day) VALUES (105, 205, '09-Apr-2024
Leave a Comment