<div>
You may want to add an order by to the select for the data you wish to have in sequence too.
</div>


You may want to add an order by to the select for the data you wish to have in sequence too.

<div>
<div class="content wysiwyg-content">
I have a MySQL database. &nbsp;If possible, I'd like 1 SQL Command to do this. &nbsp;The id's on it are all jumbled up and I would like to keep the order that the records are in the database, but change the id's so that they are consecutive. &nbsp;eg<br />
<br />
now - (1,a)(3,b),(4,c),(6,d),(8,<wbr />e),(9,f)<br />
<br />
after - (1,a),(2,b),(3,c),(4,d),(5<wbr />,e),(6,f)<br />
<br />
Thanks.
</div>
</div>


I have a MySQL database.  If possible, I'd like 1 SQL Command to do this.  The id's on it are all jumbled up and I would like to keep the order that the records are in the database, but change the id's so that they are consecutive.  eg

now - (1,a)(3,b),(4,c),(6,d),(8,e),(9,f)

after - (1,a),(2,b),(3,c),(4,d),(5,e),(6,f)

Thanks.

MySQL SQL Command, Reorder

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.