Programming

Sql basic command 2

we work on the second sql basic command Delete the table DELETED FROM WHERE {Comparision} ORDER BY LIMIT 1; example- DELETD FROM Names Where name Like %a& ORDER BY DESC LIMIT 1; Update the table UPDATE SET = value 1 WHERE {Condition}; Changed the Structure the table and add column and before and after col ALTER TABLE CHANGED [new constrains (datatype,constraits)] example - ALTER TABLE Actor ADD Region VARCHAR(10) DEFAULT "Bollywood"; example 2 ALTER TABLE Actors ADD Middlename VARCHAR(10) AFTER FirstName; exaple 3 ALTER TABLE Actors DROP Middlename; AS we discuss the AS IN Sql to used the own name in the column SELECT DOB AS "Date of Birth" From Actors; CONCAT we can merged the Fistname and Lastname SELECT CONCAT(Fistname,'',Lastname) AS Name FROM Actors; DISTICT FIND THE UNIQUE NOT REPEAT SELECT DISTINCT Score FROM student2; COUNT SELECT COUNT(*) As "No of student" From Student2 Where Maritial_Status = "Single" SUM SELECT SUM(Score) From Student;

Jan 21, 2025 - 05:23
 0
Sql basic command 2

we work on the second sql basic command

Delete the table

DELETED FROM

WHERE {Comparision} ORDER BY LIMIT 1;
example-
DELETD FROM Names Where name Like %a& ORDER BY DESC LIMIT 1;

Update the table

UPDATE

SET = value 1 WHERE {Condition};

Changed the Structure the table and add column and before and after col

ALTER TABLE

CHANGED [new constrains (datatype,constraits)]
example - ALTER TABLE Actor ADD Region VARCHAR(10) DEFAULT "Bollywood";
example 2
ALTER TABLE Actors ADD Middlename VARCHAR(10) AFTER FirstName;
exaple 3
ALTER TABLE Actors DROP Middlename;

AS

we discuss the AS IN Sql to used the own name in the column
SELECT DOB AS "Date of Birth" From Actors;

CONCAT

we can merged the Fistname and Lastname
SELECT CONCAT(Fistname,'',Lastname) AS Name FROM Actors;

DISTICT

FIND THE UNIQUE NOT REPEAT
SELECT DISTINCT Score FROM student2;

COUNT

SELECT COUNT(*) As "No of student" From Student2 Where Maritial_Status = "Single"

SUM

SELECT SUM(Score) From Student;


Read More

Tags:

Previous Article

SPO600: First Lab

Next Article

Desbravando Go: Capítulo 2 – Estrutura dos Programas

What's Your Reaction?

like

dislike

love

funny

angry

sad

wow

Related Posts

JavaScript oop

JavaScript oop

Jan 20, 2025  0

Versionamento Semântico (SemVer): Um Guia Prático

Versionamento Semântico (SemVer): Um Guia Prático

Jan 19, 2025  0

Laravel Attributes

Laravel Attributes

Jan 19, 2025  0