default value - adding multiple records with and without default value
how can i add default value if i give condition like this for multiple records
eg:
insert into companies(company_id,company_name,headquarters_phone_number)
values
('lan','cd','xyz'),
('chan', ,'abcd')
;
it showing error i want default values for 2nd record and 1st one with value inserted
i have added this condition also
alter table companies
change column company_name company_name varchar(255) default 'x';
1 answers ( 0 marked as helpful)
Hi Lanchan!
Thanks for reaching out.
You need to use the ALTER TABLE statement to add default values for the first and third column. If you provide a company name, you do not need to change this column to a default string. You simply provide a name and the other two columns contain a default value.
Hope this helps.
Best,
Tsvetelin