in reply to (OT) Mysql insert Problem

From your create table, the "phone" field has a type of int, meaning the maximum value storable is 2147483647.

I suggest you use varchar instead, since a phone number will often contain non-digits to indicate things such as a country code (for example "+61294131491" for an Australian number) or a separate extension.

Replies are listed 'Best First'.
Re^2: (OT) Mysql insert Problem
by cLive ;-) (Prior) on Jul 10, 2006 at 06:34 UTC
    Or if you're keeping it numerical, use BIGINT instead of INT. If ever you index the field, that will speed up selects a little...