MySQL Mystery

[earthlingzed]

I need some help understanding the best way to set up my database. I am getting this strrange thing where my MySQL database tables will stop storing data when there are more than 127 rows. If I clear the talbe it works again. I am lost as to why this is happening.

Below is the SQL structure of my table:

CREATE TABLE mm241c_linkbox (
id tinyint(4) NOT NULL auto_increment,
first_name text,
date_posted text,
last_name text,
assignment_name text,
url text,
email text,
PRIMARY KEY (id)
) TYPE=MyISAM;

[jweissig]

Hello,

I know why...

from MySQL Manual - 6.2 Column Types

TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

You need to do something like this..

CREATE TABLE mm241c_linkbox ( 
id int(11) NOT NULL auto_increment, 
first_name text, 
date_posted text, 
last_name text, 
assignment_name text, 
url text, 
email text, 
PRIMARY KEY (id) 
) TYPE=MyISAM;

Thanks,
- Justin

[earthlingzed]

Wow, I thougt it was something that simpel but just couldn't see it. Thanks a bunch!!!😃