Why is MySQL creating tables with a _seq suffix?

Question

I have created a InnoDB table named foo in MySQL. As soon as I perform an insert into the table, I see that another table foo_seq is created.

If I drop the auto generated table, it appears after the next insert.

What is causing this?

Answer 1

That sounds like a sequence is being created, do you have any autogenerated primary keys or IDs?