[RESOLVED] MySQL Insert issue

[RS_Arm]

Hello guys.
I would like to know another way for doing this insert instruction, without using the 'select ...' as value.
My version of MySQL doesn't allow this.

insert into calls 
	(id, date_entered, date_modified, name)
values
	((select max(id)+1 from calls), now(), now(),  'name')

Thank u

[si_the_geek]

The simplest method is to make that field an AutoNumber/Identity in the table design - that way the database system itself will automatically add the next number (and wont make any mistakes if multiple users add a record at the same time).

You then just remove the field (and value) from your Insert statement.

[RS_Arm]

I know that but I can't change the the table design. I'm not allowed to do that.
Anyway, thank's for for the tip.

[si_the_geek]

OK, well in that case try the usual syntax for an Insert/Select, eg:

insert into calls 
	(id, date_entered, date_modified, name)
select max(id)+1, now(), now(),  'name' from calls

[RS_Arm]

Thank u.
That's it!!
So simple...