NameSilo

Mysql delete query?

Spacemail by SpaceshipSpacemail by Spaceship
Watch

ridesign1

Established Member
Impact
7
Hi,
I have this query :
UPDATE `phpbb_users` SET `user_trade` = NULL ,
`user_images` = '0' WHERE `user_id` =8 LIMIT 1 ;

this changes the user_images to 0, how do I modify this so that it modifies the value to 0 for all users ?

thanks
 
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
AfternicAfternic
UPDATE `phpbb_users` SET `user_trade` = NULL ,
`user_images` = '0';
 
0
•••
thanks,
didn't realise it would be that simple

:)
 
0
•••
Dynadot — .com Registration $8.99Dynadot — .com Registration $8.99
Appraise.net

We're social

Unstoppable Domains
Domain Recover
DomainEasy — Payment Flexibility
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back