How wide are your varchar columns? Maybe you hit some storage limit.
robert
2007/3/22, Chris Jölly <[EMAIL PROTECTED]>:
Hello!
i have a small table with one pk integer column and 4 varchar columns
and want to issue the following alter statement to add a new column:
alter table my_table add ("delete_record" smallint)
if the table both is filled or empty i can not add the column. i always
get the error message:
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Not Committed
General error;-1002 POS(1) Too many columns
alter table my_table add ( "delete_record" smallint )
whats wrong with that statement?
thx, chris
--
the version of the database is 7.5 running at suse linux...
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Have a look: http://www.flickr.com/photos/fussel-foto/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
