Error while executing the ALTER query
I followed the same query as shown in the video but I am facing an error stating "Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint 'sales_ibfk_1' in the referenced table 'customers' ", What does this mean and how can I solve it?
Problem solved, Adding a primary key (customer_id) while creating customers table.