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…

  Santhiya Govindarajan

  30th Oct 2022

  SQL

  add column in sql, create database in sql, create database table in terminal by text editor, create database table in text editor by terminal, drop table in sql, insert table in sql, primary key in sql, rename database in sql, truncate table in sql, where keyword in sql