Mega Code Archive

 

Categories / MySQL / Select Clause

 

Using variable the calculate the new column ID

SELECT @maxid := MAX(publID) FROM publishers; INSERT INTO publishers SELECT publID + @maxid, publName, ts FROM publishers;