PDA

View Full Version : Mysql i want to delete user id's @ 0 my attempt


Almax1
09-14-2003, 10:47 AM
In Mysql i want to delete user id's @ 0 and there posts but i am unsure how to run the query

user id's @ 0 (removed members) are still being called up from some hacks

In a recent board move some members were not transferred to the new place there user ids are now 0 i want to delete them from the mysql database as they are still being called up with some hacks installed

help needed please anyone ?

DELETE FROM table_post
WHERE userid = '0'
ORDER BY timestamp
LIMIT 1

does this sound right ?

Issvar
09-14-2003, 11:25 AM
LIMIT 1 means only one post with userid 0 will be removed. Remove that if you want to remove all posts which have userid 0. You may also want to make sure you have the correct name for the posts table, it is not called table_post on VB