Mega Code Archive

 

Categories / MySQL / Data Type

 

Tinyint as column type

mysql> mysql> create table SALES_REPRESENTATIVE(     ->   EMPLOYEE_NO int,     ->   SURNAME varchar(40),     ->   FIRST_NAME varchar(30),     ->   COMMISSION tinyint     -> ); mysql> mysql> mysql> drop table SALES_REPRESENTATIVE; Query OK, 0 rows affected (0.01 sec)