Select Clause MySQL

  1. Home
  2. MySQL
  3. Select Clause
  4. Using variable the calculate the new column ID
SELECT @maxid := MAX(publID) FROM publishers;
INSERT INTO publishers SELECT publID + @maxid, publName, ts FROM publishers;