[RESOLVED] MySQL Insert issue

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.

Code:

---

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

---

Thank u

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.

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.

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

Code:

---

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

---

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