Query Question

[ChrisBaktis]

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

[Marco van Herwaarden]

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

[ChrisBaktis]

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

[filburt1]

I believe

TRUNCATE usernote

...will also work, and possibly a great deal faster. However, that doesn't really matter if you're doing it just once.

[ChrisBaktis]

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

[Oblivion Knight]

I believe

TRUNCATE usernote

...will also work, and possibly a great deal faster. However, that doesn't really matter if you're doing it just once.Actually, I think it's
TRUNCATE TABLE usernote;)

[Marco van Herwaarden]

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)

[ChrisBaktis]

Thanks for all the help everyone!