 | | | General error;-1002 POS(1) Too many columns | General error;-1002 POS(1) Too many columns 2007-03-22 - By Chris J?lly
Back
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/maxdb?unsub=mysql@(protected)
|
|
|