Query Question
 

What query can I run to clean out all my members User Notes. I was using this for one thing and am now going to use for something else and need all the info cleared.

Chris

[sql]DELETE FROM usernote[/sql]
If you are using a table prefix, then add this in front of 'usernote'.

Thank you - worked great!

Can I bother you for one last answer on this post from before.

https://vborg.vbsupport.ru/showthread.php?t=78471

I believe
[sql]
TRUNCATE usernote
[/sql]
...will also work, and possibly a great deal faster. However, that doesn't really matter if you're doing it just once.

Thanks filburt - this is just a one time deal - but to repeat asking questions I always write this stuff down so I dont have to bother people again -

Thanks

Actually, I think it's
[sql]TRUNCATE TABLE usernote[/sql];)

I think you are allowed to ommit the TABLE in the TRUNCATE statement, so both should be correct.

The difference between TRUNCATE and DELETE is that DELETE is deleting each row in the table seperate (slow but with respect to foreign key and other constraints), where TRUNCATE just reset the last row pointer (data is still there but there is no pointer to it anymore, is faster)

Thanks for all the help everyone!