Hi,, I'm looking for a way to create a table with a ID columns (PRIMARY KEY) generated automatically...
The only probleme is that i cannot use a AUTO_INCREMENT field because I have thousand of lines added each day (and all lines older than a week are deleted) With AUTO_INCREMENT, one day or another I'll reach the size limit of the ID field ;-) I could also use a timestamp as a primary key, but i have over 15 process running at the same time that could make an INSERT query during the same second, so a timestamp in second is not enough ;-( I'm simply looking for a way to 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 ??? /<><><><><><><><><><><> Jonathan Pelletier <><><><><><><><><><><><>\ \ B.ing Informatique / / Matrox Electronic Systems Ltd. \ \ MIS / Département des systèmes -- Groupe Unix / / \ \ 1055 Blv. St-Regis Tel: (514) 822-6000 x.7589 / / Dorval (Quebec) Fax: (514) 822-6262 \ \ H9P 2T4 Email: [EMAIL PROTECTED] / / http://www.matrox.com \ \ / / Home: [EMAIL PROTECTED] \ \<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>/ _ ASCII ribbon campaign ( ) - against HTML email X & vcards / \ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php