View Single Post
Old Aug 11th, 2007, 3:21 AM   #1
programmingnoob
Hobbyist Programmer
 
Join Date: Feb 2006
Posts: 154
Rep Power: 3 programmingnoob is on a distinguished road
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!
programmingnoob is offline   Reply With Quote