The error is saying that you have 2 columns with the auto increment attribute ( sales_id
and customer_id
), which is not valid. You also have two primary keys.
My intuition is that you wanted customer_id
to be a foreign key to a different table, but the question isn't clear enough. Could you further describe what you were trying to do? I'm personally interested in why you want to define a table this way.