Jim Singelis
asked on
Is there a mySQL equiv to SQL Server's select identity(int,1,1) as ...
I'm porting a project from SQL Server to mySQL.
In SQL Server:
"Select identity(int,1,1) as id, a, b, c INTO newTable from oldTable" creates an autoNumbered id column.
In MySQL: ?
If there's no equivalent way, I suppose I could create an empty table with an autoNumber field and then insert into it.
In SQL Server:
"Select identity(int,1,1) as id, a, b, c INTO newTable from oldTable" creates an autoNumbered id column.
In MySQL: ?
If there's no equivalent way, I suppose I could create an empty table with an autoNumber field and then insert into it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.