Automatic Primary Key for "circular table"

2002-05-29 Thread Jonathan Pelletier
o tell Mysql 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 ??? /<><><><><><><><><><>&

Copy part of a table to a temporary table

2001-04-23 Thread Jonathan Pelletier
#x27;m deleting all the rows that I 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