Tag: create database table in terminal by text editor
-
sql (day2)
create database: example: create database students; Rename database: example: alter database “students” rename to “school”; Create database using primary key: example: create database students(s_id serial primary key,name varchar(20) not null); Add column: example: alter table students add column department varchar(20); Insert table: There are two types to insert table.There are: Type 1: example: insert into…