Auto increment a value on the fly with MySQL

By assigning a value to a variable in MySQL and incrementing the variable as part of a select statement, it's possible to have a number auto-incremented on the fly. This number has no other reference to the table other than the order the data is selected. It is also possible to auto increment the variable when running an update statement so a new set of incrementing values could be stored into the table.
Category: MYSQL | View Tutorial

Views: 19

Getting Started with SQL Developer - Part 1

preparing your environment, installation, and getting started with SQL Developer.
Category: MYSQL | View Tutorial

Views: 13