of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Thanks
Visolve DB Team
- Original Message -
From: William DeMasi [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 15, 2006 12:34 AM
Subject: Incrementing using Max(Field) ?
Does anyone
Does anyone have any ideas of how I can select the max value and insert the
next highest value?
I want something that would do something like this:
Insert into table1 (select max(field1)+1 from table1);
This obviously doesn't work.
I know if the table was set to auto-increment it wouldn't be
for the right syntax to use near 'select
obj_act_id from c2iedm_dev2.act_functl_assoc where subj_
I have looked at the documentation for MySQL and this seems to be the
correct syntax for using IN.
Could someone please let me know what is wrong?
Thank you.
William DeMasi
--
MySQL General Mailing