Navicat - Default Value

[Benjames]

HELLO,

Can someone tell me how to set a default value in Navicat. (Mysqldatabase) for example, when another row is added/user registers their password is by default pass123. (Thats not the actual usage & i dont need it to overwrite anything previous because it will be an empty field.

Thanks

Ben

Sorry if this is in wrong place, its nothing to di with Habbo so I didn't know where toput it.

 

[Weasel]

Do it trough a query

ALTER TABLE users ADD COLUMN password varchar (20) DEFAULT 'pass123' ;

 

[Benjames]

Do it trough a query

ALTER TABLE users ADD COLUMN password varchar (20) DEFAULT 'pass123' ;

And what if the column is already created. Thank you btw!

 

[zMagenta]

ALTER TABLE users ALTER password SET DEFAULT 'test123';

That should work.

 

[Benjames]

ALTER TABLE users ALTER password SET DEFAULT 'test123';

That should work.

Thanks both of you. This is extremely helpful. Not tested them but I assume they work. You're both amazing!

Thread can be closed. Question answered :--)

 

[Kaz]

Closed on request, if the above codes give you any issues pm me and i will re-open this thread