MySQL increasing ID manually
Some times it’s necessary to assign a consecutively increasing ID field to a set of rows. Autoincrement is available, but you would need to leverage an INSERT in order to make use of MySQL’s autoincrement feature. Fortunately, it is possible to do this in place by using a separate counter variable in an UPDATE statement.
The solution given below is largely adapted for MySQL from Phil Haack’s SQL Server recipe. If you’re using MySQL Query Browser, you’ll need to make this a script by clicking File > New Script Tab.
SET @counter = your_starting_index; UPDATE your_table_name SET your_id_column_name=(@counter:=@counter+1);
Make sure to change your_starting_index, your_table_name, and your_id_column_name.
To receive updates on new articles, subscribe to CRF Design today!
Similar Posts:
- Dealing with mid-study changes (data model)
- Top 10 differences between Java and C#
- Using TZEdit on Windows SP, SP2, SP3 for Daylight Saving Time (DST)
- Remap keys, map caps lock to control button
- Overload the array square bracket operator in C#
