/*
mysql> Drop table Inventory;
mysql> CREATE TABLE Inventory
-> (
-> ID SMALLINT NOT NULL PRIMARY KEY,
-> InStock SMALLINT NOT NULL,
-> OnOrder SMALLINT NOT NULL,
-> Reserved SMALLINT NOT NULL
-> );
Query OK, 0 rows affected (0.06 sec)
mysql> INSERT INTO Inventory VALUES (101, 10, 15, 4),
-> (102, 1, 9, 3),
-> (103, 5, 2, 13);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from Inventory;
+-----+---------+---------+----------+
| ID | InStock | OnOrder | Reserved |
+-----+---------+---------+----------+
| 101 | 10 | 15 | 4 |
| 102 | 1 | 9 | 3 |
| 103 | 5 | 2 | 13 |
+-----+---------+---------+----------+
3 rows in set (0.01 sec)
*/
Drop table Inventory;
CREATE TABLE Inventory
(
ID SMALLINT NOT NULL PRIMARY KEY,
InStock SMALLINT NOT NULL,
OnOrder SMALLINT NOT NULL,
Reserved SMALLINT NOT NULL
);
INSERT INTO Inventory VALUES (101, 10, 15, 4),
(102, 1, 9, 3),
(103, 5, 2, 13);
select * from Inventory;