PHP MySQL II, Schemes and Mind Maps of Computer science

Download PHP MySQL II and more Schemes and Mind Maps Computer science in PDF only on Docsity!

PHP MYSQL II 204202 IT II

DATABASE MODIFICATION

คำสั่ง SELECT

1. INSERT

2. DELETE

3. UPDATE

DELETION

Syntax

DELETE FROM table WHERE condition;

DELETE from Likes WHERE drinker=‘Sally’; DELETE from Likes WHERE drinker=‘Sally’ AND beer=‘Singha’;

DELETE FROM table;

ไม่ต้องมี WHERE clause

DELETE FROM Likes