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
        [EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to