How do i set home room using navicat?

[Oscarblue]

How do i set home room using navicat?

Please help

Retro:
r63

 

[NeedForSpreed]

Right click the table that contains the home_room. Navigate to the column then at the bottom there should be a field 'DEFAULT' set that to the room id.

Skickat från min FRD-L09 via Tapatalk

 

[JayC]

UPDATE `users` SET `home_room` = '1';
ALTER TABLE `users` ALTER COLUMN `home_room` SET DEFAULT '1';

 

[Oscarblue]

UPDATE `users` SET `home_room` = '1';
ALTER TABLE `users` ALTER COLUMN `home_room` SET DEFAULT '1';

thanks