In the last episode (Aug 27), Osman Omar said:
> below is my tables properties,
> and my last record id is 127;
>
> mysql> desc emcs;
> +------------+-------------+------+-----+------------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+-------------+------+-----+------------+----------------+
> | id | tinyint(6) | | PRI | NULL | auto_increment |
From the manual:
`TINYINT[(M)] [UNSIGNED] [ZEROFILL]'
A very small integer. The signed range is `-128' to `127'. The
unsigned range is `0' to `255'.
What do you think happens with you hit 127?
Replace that TINYINT with INTEGER.
--
Dan Nelson
dnelson@stripped
