setting default values - PHPBuilder Forums

setting default values

Anon

I used to know, but I forgot.

alter table products
add shipping float(4,2) ?????

mattw

ALTER TABLE products ADD shipping FLOAT(4,2) DEFAULT '6.00'

Should do it for you...

Matt Wade
codewalkers.com