Class 8 – Examples of SQL CRUD commands
Posted: November 7th, 2009 | Author: amos | Filed under: mysql | Tags: class 8, create, crud, delete, read, update | 1 Comment »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
Loading ...
FF