gunu1 3Speak Podcast

https://3speak.tv/watch?v=gunu1/ovuyctdx
This video is a tutorial on SQL basics where I talk on some basic concepts. This serves as a reference material for the post I made on SQL

Code used:

USE Friend_list;

/** 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