mysql - truncate command
 

what does it do?
I thought it deleted all the entries from the tables while preserving the column structure, right?

well... when i type truncate tablename;
and then i try to see the data of the set, it says "empty set", which I would expect....
but when I am using with c#, it would tell me the entry already exists....so how can an empty set have an entry?
maybe I am doing something wrong with c#, but i doubt it!

Try running mysqladmin flush-tables.

does that preserve the structure of the tables? columns and all?