How to create schema in MyEclipse Derby
posted 3 years ago
Datatype INT or INTEGER doesn't take a parameter. Different numeric types can hold numeric values between certain ranges. For INTEGER, it is -2147483648 to 2147483647. If you actually want to store the numeric characters, then use one of the character types, not numeric types. However, given the names of your columns, phoneno and pincode, I would guess that you really need to use character data, anyway, as they won't be used as integers.