ERROR 1264 (22003): Out of range value for column (INSERT Statement)

[Tom McInnerney]

Hi =) Been learning SQL for a few days now from SamsTeachYourself SQL in 24 Hours book. I've been inserting data into the tables lately and I've have a few problems, some of my own doing, but I can't seem to find a solution on this one.

The error is

ERROR 1264 (22003): Out of range value for column 'CUST FAX' at row 1

Results of SHOW CREATE TABLE customer_tbl:

| customer_tbl | CREATE TABLE `customer_tbl` (
  `CUST_ID` varchar(10) NOT NULL,
  `CUST_NAME` varchar(30) NOT NULL,
  `CUST_ADDRESS` varchar(20) NOT NULL,
  `CUST_CITY` varchar(15) NOT NULL,
  `CUST_STATE` char(2) NOT NULL,
  `CUST_ZIP` int(5) NOT NULL,
  `CUST_PHONE` char(10) DEFAULT NULL,
  `CUST_FAX` int(10) DEFAULT NULL,
  PRIMARY KEY (`CUST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

My insert statement:

mysql> insert into customer_tbl values
    -> ('12', 'Marys Gift Shop', '435 Main ST', 'Danville', 'IL', '47978', '3178
567221', '3178523434');
ERROR 1264 (22003): Out of range value for column 'CUST_FAX' at row 1

Any help would be greatly appreciated, I'm sure it's something really simple that I've missed.