REMOVE FROM livres IF titre='Fahrenheit 451'

REMOVE FROM livres WHERE titre='Fahrenheit 451'

ERASE FROM livres IF titre='Fahrenheit 451'

SUPPRESS FROM livres IF titre='Fahrenheit 451'

DELETE FROM livres IF titre='Fahrenheit 451'

ERASE FROM livres WHERE titre='Fahrenheit 451'

DELETE FROM livres WHERE titre='Fahrenheit 451'

SUPPRESS FROM livres WHERE titre='Fahrenheit 451'

SELECT prenom,nom FROM auteurs JOIN ON livres WHERE titre = "Fahrenheit 451"

SELECT * FROM livres ORDER BY ann_pub DECREASING

SELECT * FROM livres SORT BY ann_pub DECREASING

SELECT * FROM livres RANK BY ann_pub

SELECT * FROM livres SORT BY ann_pub DESC

SELECT * FROM livres ORDER BY ann_pub

SELECT * FROM livres RANK BY ann_pub DESC

SELECT * FROM livres ORDER BY ann_pub DESC

SELECT * FROM livres RANK BY ann_pub DECREASING

SELECT * FROM livres SORT BY ann_pub

SELECT * FROM livres ON 1980 <= ann_pub <= 2000

SELECT * FROM livres WHERE ann_pub => 1980 AND ann_pub => 2000

SELECT * FROM livres ON ann_pub >= 1980, ann_pub <= 2000

SELECT * FROM livres ON ann_pub => 1980 AND ann_pub => 2000

SELECT * FROM livres WHERE 1980 <= ann_pub <= 2000

SELECT * FROM livres WHERE ann_pub >= 1980 AND ann_pub <= 2000

SELECT * FROM livres WHERE ann_pub >= 1980, ann_pub <= 2000

SELECT * FROM livres ON ann_pub <= 1980 AND ann_pub <= 2000

UPDATE auteurs SET nom = 'Barjavel', prenom = 'René' WHERE id = 2

CHANGE livres TO nom = 'Barjavel', prenom = 'René' WHERE titre = 'Dune'

CHANGE livres TO id_auteur = 6 WHERE titre = 'Dune'

UDPATE livres SET nom = 'Barjavel', prenom = 'René' WHERE titre = 'Dune'

CHANGE auteurs TO nom = 'Barjavel', prenom = 'René' WHERE id = 2

UPDATE livres SET id_auteur = 6 WHERE titre = 'Dune'