"delete from table" doesn't delete!

[Anon]

Has anyone else noticed this? I have a mysql table named, "chart," and it is HUGE.

I did the mysql command: delete from chart;

Then, I "double-checked" that everything was deleted with a statement:
select * from chart;
and it came up empty (which is what I expected).

But then, when I was re-uploading data into it, I got failed "duplicate" errors, and found the chart was still full of data!

I ended up having to "drop table chart"; and rebuild it.

does this make sense?

[radley]

To delete a table completely:

DROP TABLE chart

to remove all the data from the table without deleting it

DELETE TABLE chart

hope it helps

--Rad