At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote:
> : I've got a database already populated with data and need to add a > : sequential numerical "id" field as a key. (as one would with an auto > : increment field) > : > : Is there a straightforward sql statement that will do this? > > >ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY >KEY; Thanks for the reply. What I need is to actually add the numbers though. :-) Gawain --------------------------------------------------------------------- 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
