CREATE TABLE kassid(
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  v2rv VARCHAR(20),
  mass_grammides INT
);


INSERT INTO kassid(v2rv, mass_grammides) VALUES ("helehall", 1200);
INSERT INTO kassid(v2rv, mass_grammides) VALUES ("helepruun", 900);
INSERT INTO kassid(v2rv, mass_grammides) VALUES ("musta-valgekirju", 850);

SELECT * FROM kassid;
SELECT * FROM kassid ORDER BY mass_grammides;

UPDATE kassid SET mass_grammides=mass_grammides+50 WHERE id=2;
DELETE FROM kassid WHERE id=2;