Web Development Intensive

Create

INSERT INTO abloomberg_animals (name, color) VALUE (‘zubr’, ‘brown’)

Read

SELECT * FROM abloomberg_animals WHERE 1
SELECT name, color FROM abloomberg_animals WHERE id=15

Update

UPDATE abloomberg_animals SET name=’zubr’ WHERE id=15
UPDATE abloomberg_animals SET name=’zubr’, color=’brown’ WHERE id=15

Delete

DELETE from abloomberg_animals WHERE id=15

Related posts:

1. Class 8 – A simple CMS for SQL CRUD

Tagged: class 8, create, crud, delete, read, update