Define and use small int : Small Int « Data Type « SQL / MySQL

1. SQL / MySQL
2. Data Type
3. Small Int

Define and use small int

   
/*
mysql> Drop table Test;
Query OK, 0 rows affected (0.11 sec)

mysql> CREATE TABLE Test
    -> (
    ->    TestID SMALLINT NOT NULL PRIMARY KEY,
    ->    Amount SMALLINT NOT NULL
    -> );
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO Test VALUES (101, 12),
    ->                         (102, 1),
    ->                         (103, 139),
    ->                         (104, -37),
    ->                         (105, 0),
    ->                         (106, -16);
Query OK, 6 rows affected (0.06 sec)
Records: 6  Duplicates: 0  Warnings: 0

*/

Drop table Test;

CREATE TABLE Test
(
   TestID SMALLINT NOT NULL PRIMARY KEY,
   Amount SMALLINT NOT NULL
);


INSERT INTO Test VALUES (101, 12), 
                        (102, 1), 
                        (103, 139), 
                        (104, -37), 
                        (105, 0), 
                        (106, -16);

           
         
    
    
  

Related examples in the same category