NameSilo

Mysql delete query?

SpaceshipSpaceship
SpaceshipSpaceship
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.
Unstoppable Domains — AI StorefrontUnstoppable Domains — AI Storefront
UPDATE `phpbb_users` SET `user_trade` = NULL ,
`user_images` = '0';
 
0
•••
thanks,
didn't realise it would be that simple

:)
 
0
•••
Olitt — high-converting AI websites, only from $1/moOlitt — high-converting AI websites, only from $1/mo

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com
Catchy
URLs.com
NameFit
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back