Class 8 – Examples of SQL CRUD commands
Saturday, November 7th, 2009Create
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
Loading ...