How many fields in table MYSQL

[Guest_imported]

I would like to know how many fields can be set-up in a table.
I currently have 19 and when I try to add another with "Alter table xxx add xxx varchar(xxx);" I get a error?

 

[piti]

hi

i have a table with 60+ columns so ...
what error returns your alter table statement?

 

[luckyblackcat]

Thanks for your help.

It works fine now

$i=1;
while($row=mysql_fetch_array($result)){
echo "&title[".$i."]=".$row[0];
echo "&price[".$i."]=".$row[2];
echo "&item_no[".$i."]=".$row[4];
echo "&itemstatus[".$i."]=".$row[6];
$i++;
}
I altered the code a little to get it going.
The inner join is excellent, I knew I was making life difficult using 2 SELECT statements!!!

 

[Guest_imported]

This is the error and the way I get it from the DOS prompt...

My Input:
ALTER TABLE general ADD staffcon VARCHAR(250);

The error I get:
ERROR 7: Error on rename of '.\minutes\general.MYI' to '.\minutes\#sql2-25c-2d2.
MYI' (Errcode: 13)

Thanks..

 

[piti]

maybe the table is opened by another process
try "FLUSH TABLES" before altering the table