Add multiple columns to existing table
How to add multiple columns to existing table. Alter syntax and example.
Syntax
ALTER TABLE table_name ADD COLUMN column_name data_type, ADD COLUMN column_name data_type;
Create table
CREATE TABLE users( userid numeric not null default nextval('seq_users'::regclass), username varchar(100), userpass varchar(250), usermail varchar(50), address varchar(1000) );
Example Add multiple columns
ALTER TABLE users ADD COLUMN first_name varchar(100), ADD COLUMN last_name varchar(100);