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
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
: 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
