Simple INSERT clause : Insert « Insert Delete Update « SQL / MySQL

1. SQL / MySQL
2. Insert Delete Update
3. Insert

Simple INSERT clause

  
/*
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;


           
         
    
  

Related examples in the same category