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?
views:
30answers:
2
+1
A:
That sounds like a sequence is being created, do you have any autogenerated primary keys or IDs?
Matias Valdenegro
2010-10-05 18:54:59
Not sure what you mean by "autogenerated", I have auto incrementing primary key on the table.
mmattax
2010-10-05 19:05:22
Since when does MySQL have sequences?
a_horse_with_no_name
2010-10-05 19:49:50
@mmattax That's basically a autogenerated value.
Matias Valdenegro
2010-10-05 19:51:09
+1
A:
Issue this query, chances are very high it will tell you what happens before an insert:
SHOW TRIGGERS LIKE 'foo';
Wrikken
2010-10-05 19:17:23