Structured Query Language (Basics 1 video)

/** C R U D

*/

CREATE TABLE friends( First_name VARCHAR(50), Last_name VARCHAR(50), Age INT, contact INT );

SELECT * FROM friends

INSERT INTO friends(First_name,Last_name,Age,contact) VALUES( 'Abdul Kahar', 'Gunu', 80, 0123456789 );

INSERT INTO friends(First_name,Last_name,Age,contact) VALUES( 'Abdul Rahman', 'Kudus', 50, 1234567890 );

SELECT First_name, Last_name FROM friends WHERE contact = 1234567890 SELECT Age FROM friends WHERE contact = 1234567890 SELECT Last_name AS [FIRST NAME],First_name AS [LAST NAME] FROM friends WHERE contact = 1234567890

UPDATE friends SET Age = 12 WHERE contact = 123456789

DELETE FROM friends WHERE contact = 1234567890