mysql> show create table employee;
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                              |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| employee | CREATE TABLE `employee` (
  `name` varchar(30) default NULL,
  `address` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  `phone` int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

##</code><code>##

 mysql> insert into employee values("John", "New York", "John@hotmail.com", "12345678901");

##</code><code>##

John	New York	John@hotmail.com	2147483647