inserting unique value

#1 June 21st, 2007, 02:25 PM

I need to insert a unique value into a (not auto-increment) column.
I try

insert into idtest (val) values ((select max(val) from idtest)+1);

but I get

ERROR 1093 (HY000): You can't specify target table 'idtest' for update
in FROM clause

- what is the correct way to do this?

Regards,
Rune

#2 June 22nd, 2007, 03:45 PM

== Quote from Rune Zedeler (rz@daimi.au.dk)'s article

Quote:

I need to insert a unique value into a (not auto-increment) column.
I try
insert into idtest (val) values ((select max(val) from idtest)+1);
but I get
ERROR 1093 (HY000): You can't specify target table 'idtest' for update
in FROM clause
- what is the correct way to do this?
Regards,
Rune

how about this:

insert into idtest (val) (select (max(val)+1) from idtest);

let me know if it works for you.
--
POST BY: lark with PHP News Reader

#3 June 22nd, 2007, 05:25 PM

lark skrev:

Quote:

insert into idtest (val) (select (max(val)+1) from idtest);

Thanks, works! :+)

-Rune

inserting unique value

re: inserting unique value

re: inserting unique value

/bytes/development

/bytes/it

/bytes/about