SQL (Basic)

Kumpulan Keyword yg digunakan di SQL (BASIC)

SELECT

SELECT DISTINCT column_name(s)
FROM table_name

WHERE

SELECT * FROM Persons WHERE FirstName='Tove'
SELECT * FROM Persons WHERE Year=1965

AND/OR

SELECT * FROM Persons
WHERE FirstName='Tove'
AND/OR LastName='Svendson'

ORDER

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC

INSERT

INSERT INTO Persons (P_Id, LastName, FirstName)
VALUES (5, 'Tjessem', 'Jakob')

UPDATE

UPDATE Persons
SET Address='Nissestien 67', City='Sandnes'
WHERE LastName='Tjessem' AND FirstName='Jakob'

DELETE                                                                                                           DELETE ALL ROWs

DELETE FROM table_name                          DELETE FROM table_name
WHERE some_column=some_value                    or
                                                DELETE * FROM table_name