/*
mysql> Drop table Inventory;
Query OK, 0 rows affected (0.02 sec)
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.05 sec)
mysql> INSERT INTO Inventory VALUES (104, 16, 25-InStock, 0);
Query OK, 1 row affected (0.00 sec)
mysql> select * from Inventory;
+-----+---------+---------+----------+
| ID | InStock | OnOrder | Reserved |
+-----+---------+---------+----------+
| 104 | 16 | 9 | 0 |
+-----+---------+---------+----------+
1 row in set (0.00 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 (104, 16, 25-InStock, 0);
select * from Inventory;