Automatic Primary Key for circular table

to use the first free value in the valid range of the field to use as a Primary Key (Ex: specify a INT as the ID and make MySQL take the first available integer in the INT range as the ID) Any Idea ??? / Jonathan Pelletier \ \ B.ing Informatique

Copy part of a table to a temporary table

don't need from the newly created table : It is not very efficient :-) I'll be glad if someone could tell me a SQL way to solve this tricky problem... / Jonathan Pelletier \ \ / / Matrox Electronic Systems Ltd