BCStorm DB Help

[RetroRP]

I wanna update homeroom for everyone.. But I need a fix on my code to insert, Here is my code:

SELECT * FROM `users`;
Update TABLE='users' set home_room='222'

Can anyone correct the code for me? As its not working for me haha

 

[Lionches]

UPDATE `users` SET `home_room` = 222

 

[Find]

also go onto design table and change the default value to the room id

 

[RetroRP]

Nvm I fixed it.. The code was

ALTER TABLE `users`
MODIFY COLUMN `home_room`  int(10) UNSIGNED NULL DEFAULT 0 AFTER `ip_reg`;