1UPDATE student
2SET name = institute.inst_name
3FROM institute
4WHERE student.student_id = institute.inst_id;
1
2
3
4
5 ALTER TABLE customer
6ADD COLUMN fax VARCHAR,
7ADD COLUMN email VARCHAR;
1ALTER TABLE mytable
2ADD COLUMN column1 VARCHAR,
3ADD COLUMN column2 REAL;
4
5INSERT INTO mytable (column1)
6VALUES (v1), (v2), (vn);