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: given name for id – column name. serial – should be integer, it takes contiguous number at continuous manner. primary key – don’t repeat not null – compulsory to fill data. Moreover defaultely takes not…

  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