-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Vincente, et al --
...and then Vicente Valero said... % % Hello, I need help. Hi! That's why the list is here :-) % % I want to create a table with a numeric primary key as index in my sql. I Good. % want this % index will be automatic. I've tried an auto_increment column, but if insert Also good. % a non-correlative value then all new entries continue from this % non-correlative value (1,2,3,4,1026,1027,...). It is possible use the first Aha! There's your problem. Don't specify values into an auto_increment column; let the database handle it itself. If you need to track some other sort of id, like 1026 or 1000, then put that in another column (which might be empty if there's no value to track). Don't overload the primary key, which should simply be a unique row identifier, by asking it to hold row data as well. % value not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)? Nope. % % Thank you, % Vicente HTH & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+NnNRGb7uCXufRwARApd7AJ9bF2tJJZgcS5WIw5Xxj03iVcXthACg4CDc QUDmZnRb8FcXWaJrUB5Xe84= =KQeg -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
