CREATE TABLE table_name( column_name data_type, Column_name data_type DEFAULT ‘value’ );
ALTER TABLE mytbl ALTER j SET DEFAULT 1000;