Category: SQL

• sql (day 3)

  Retrive: It retrive all data. eg:select * from students; Column name: It shows only contain in particular column by the column name. eg:select name from students; It shows only contain in particular column by the column name(two or more column). eg:select name,course from students; To get only particular name: eg:select * from students where course…

  Santhiya Govindarajan

  29th Nov 2022

  SQL

  lies as, Retrive data

• sql day-1

  How to install postgresql in terminal? sql basics:

  Santhiya Govindarajan

  30th Oct 2022

  SQL

  How to install postgresql in terminal?, sql basics

• 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