add boolean column

[dessie1981]

Hi everyone,

Can anyone give me the right syntax to use here please

alter table orders add column uploaded boolean default false;

Regards
Dessie

 

[r937]

alter table orders
add column uploaded CHAR(1) NOT NULL default 'N';

or

alter table orders
add column uploaded TINYINT NOT NULL default 0;


r937.com | rudy.ca

 

[dessie1981]

Thanks that great got it

Regards
Dessie