
DELETE FROM `mybb_threads` WHERE `uid` = '145'
is this right?
[Tutorial] Common SQL queries and how to run them
|
![]() is this right?
2011-05-08, 09:33 PM
Yes, it is right.
I recommend backing up your mybb_threads table first though, just in case something goes wrong.
With more than one board admin, how does one know what one's uid is? Or are all the admin's uid's the same, meaning it is a group designation and not an individual?
i do upgrade mybb
I gave my password, but show error I use this training so I changed the password to the test but show : Error The password you entered is incorrect. If you have forgotten your password, click here. Otherwise, go back and try again. Help me for Change password use this cod ? UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt = '' WHERE uid = 'X' X For Me is 1 But my password [test] not Change please 4users.ir Mohammad
2012-02-07, 08:21 PM
Is there a query I can run to delete all pm's from a specific member?
2012-02-07, 08:29 PM
-Paul H.
Cogisne lingua latina?
2012-02-07, 09:23 PM
Thanks Paul!
2012-02-19, 11:41 PM
Nice tips though noticed one thing:
Quote:Also notice that with these 2 example, the layout is different. One has
You have to sue it? ![]()
Is it possible to add to an existing column?
For example if I have a table named Points, and within that table I have a column named Points2 If there were 2 rows in that table, row 1 had 100 for Points2 column, and row 2 had 200 for the Points2 column, is it possible to add 100 to each, so that row 1 would now have 200, and row 2 would have 300? Also is it possible to prune stuff too? If one column is used for dates, is it possible to prune from a certain date to another date? Cheers!
2013-01-06, 02:46 PM
How do i run this on the admin cp.
|
« Next Oldest | Next Newest »
|