SyntaxFix
Write A Post
Hire A Developer
Questions
Use table alias in subquery:
INSERT INTO customers ( customer_id, firstname, surname ) VALUES ((SELECT MAX( customer_id ) FROM customers C) +1, 'jim', 'sock')