alter table error

[tommo74]

I want to add a column to a table that holds datatype INT with a default of 0 and the maximum digits allowed in the column is 3.

This :

ALTER TABLE Person ADD Age INT(3) DEFAULT 0;

gives the following error :

ERROR:  parser: parse error at or near "(" at character 31

Any help ?

[BenInBlack]

You have to use Decimal or Numeric to control the length

DECIMAL(3,0)

 

I would use TINYINT you save on space and dont slow down searches on large data

see http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

 

 

 

 

[fenway]

That's a php error, not a mysql error... nothing to do with the data type.