SyntaxFix
Write A Post
Hire A Developer
Questions
Your sub-query is just incomplete, that's all. See the query below with my addictions:
INSERT INTO customers ( customer_id, firstname, surname ) VALUES ((SELECT MAX( customer_id ) FROM customers) +1), 'jim', 'sock')