i've got one "simple" question :)

this doesnt work but i am sure u know what i mean :-)[code=mysql]
INSERT INTO table1 set no=MAX(no)+1;[/code]

this doesnt work too :([code=mysql]
insert into table1 set no=(select MAX(no) from table1)+1;[/code]

any ideas how to do it?

thx a lot
jx2