Sql to insert data into colum based on another column value

Question

INSERT INTO tableX (ColumnPk,column1, column2)
VALUES((SELECT  max(columnPk) from tableX)+1, 'Column1 value', 'Column2 Value')

I tried this, but getting error 1093: you cannot specify the target table 'organizationmanagement' for updating in the FROM clause

+3

Ankit tater Feb 11 '14 at 11:31

1 answer

Barmar · Answer 1 · 2014-02-11T11:35:51+0000

You do not use VALUESwhen using the result SELECT:

INSERT INTO tableX (ColumnPk, column1, column2)
SELECT max(columnPk)+1, 'Column value', 'Column2 value';

Is there a reason why you did not configure it columnPkas an auto-increment column, so it will do it automatically?