Menu
I've got a table in MySQL that has a Primary Key Column.
Lets say:
ID | Value 1 | One 2 | Two 6 | Three 8 | Four 9 | Five How do I get it to be:
ID | Value 1 | One 2 | Two 3 | Three 4 | Four 5 | Five There are no other tables. Just the one. I just want the ID to be in a proper series.
Any suggestion?? A Query perhaps.. :)
241
Luckily, it's easy for MySQL to optimize index data for MyISAM tables. You can use the OPTIMIZE TABLE command to reindex a table. In doing so, MySQL will reread all the records in the table and reconstruct all of its indexes. The result will be tightly packed indexes with good statistics available.
Yes, primary key is automatically indexed in MySQL because primary key, index, etc gets stored into B-trees. All engines including InnoDB as well as MyISAM automatically supports the primary key to be indexed. The primary key is implicitly indexed in InnoDB, MyISAM, and other engines.
Short answer: yes you can.
You can define a primary key in SQL Server by using SQL Server Management Studio or Transact-SQL. Creating a primary key automatically creates a corresponding unique clustered index, or a nonclustered index if specified as such.
There is even a simple way to accomplish the result by writing this query
SET @newid=0; UPDATE tablename SET primary_key_id=(@newid:=@newid+1) ORDER BY primary_key_id; This query will reindex the primary key starts from 1
165
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
