Calculation in INSERT clause
|
/* 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;
|
|
|
|
|
Related Scripts with Example Source Code in same category :
-
-
-
-
-
-
|
|