MySQL insert with subselect to insert a incrementing value

mysql_insert_with_subselect.sql

# http://stackoverflow.com/questions/10644149/insert-into-with-subquery-mysql
# Use a SELECT instead of VALUES
# Then give static values an alias

# Add a new row
# value for position should be the highest position in group + 1
INSERT INTO some_table (group_id, name, position) 
  SELECT 
  2 as group_id, 
  'bert' as name , 
  (COALESCE(MAX(position), 0) + 1) as position 
  FROM some_table WHERE group_id = 2


INSERT INTO qa_costpriceslog (item_code, invoice_code, item_costprice)
  SELECT
    /* Literal number values with column aliases */
    1 AS item_code,
    2 AS invoice_code,
    item_costprice
  FROM qa_items 
  WHERE item_code = 1;