[SOLVED] TINYINT

[otuatail]

I can't use this script to insert a table. State problem around the TinyInt but documents say it's ok

 

DROP TABLE IF EXISTS `pages`;

CREATE TABLE IF NOT EXISTS `pages` (

  `id` int(11) NOT NULL auto_increment,

  `Current` unsigned TINYINT( ) default NULL,

  `History` varchar(100) default NULL,

  `Date` varchar(15) default NULL,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

Now value in brackets but does it need it? I only want a value 0 - 255

 

 

 

 

[Barand]

try

 

`Current` TINYINT unsigned ,

[otuatail]

Thanks for that. It works.

 

but strange when I look in phpMyAdmin it is tinyint(3)

 

Desmond.

 

[Barand]

INT, TINYINT etc without the (N) will default to the number of digits in the max value that can be stored.

[otuatail]

Thanks Prob solved