<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a table that has about 70 values, &nbsp;I want to add another column that will contain an auto incrementing number for each row that exists. &nbsp;So the value of this column, lets call it display order, it '1' in the first row, '2' in the second row, and '70' in the last row. &nbsp;How can I do this programmatically so that I don't have to enter in all 70 values for this column?<br />
<br />
If you could tell me how to do this in phpMyAdmin, as well as in SQL,that would be a plus.<br />
Thanks
</div>
</div>


Hello,

I have a table that has about 70 values,  I want to add another column that will contain an auto incrementing number for each row that exists.  So the value of this column, lets call it display order, it '1' in the first row, '2' in the second row, and '70' in the last row.  How can I do this programmatically so that I don't have to enter in all 70 values for this column?

If you could tell me how to do this in phpMyAdmin, as well as in SQL,that would be a plus.
Thanks

Adding a new column in MySQL that adds a value for each row in the table

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

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.