DML

Question 1

INSERT DATA INTO TABLES

Answer 1

INSERT INTO tablename (collumnname1,collumnname2,…)

VALUES (‘value1,’value2’,…),(‘value1’,value2’,…);

Question 2

UPDATE DATA IN TABLES

Answer 2

UPDATE tablename
SET columnname = ‘value’
WHERE columnname = ‘value’

Question 3

DELETE DATA FROM TABLES

Answer 3

DELETE FROM tablename
WHERE columnname = value

DELETE FROM tablename
(διαγραφει ολα)