Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Delete table data completely
- Jacky Luk
August 26, 2005, 6:58 pm
rate this thread
I can't seem to find a way to delete all records of a table. I created my
tables in MySQL Query Browser, then fill them up with VC++, but some records
were incorrect, And I had to recreate the table again. So please help, I
just wanted to delete the records rather than dropping the table completely
and start over again..
Re: Delete table data completely
If you would really like to start over agian than the best way is to
drop the table, as this way the autonumber index will start from scratch.
Else use the delete command (http://dev.mysql.com/doc/mysql/en/delete.html)
I believe the following should work:
DELETE FROM TABLE 'tablename'
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
Q: What is the most annoying thing on usenet and in e-mail?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum