SQL : Insert, Update data, delete data dan tambah field

tambah field:
ALTER TABLE `mahasiswa` ADD `value` INT( 5 ) NULL DEFAULT '0';

insert :
INSERT INTO `sistem_kuliah`.`mahasiswa` (
`nim` ,
`nama` ,
`alamat` ,
`angkatan` ,
`status` ,
`value`
)
VALUES (
'085555', 'indira', 'jl. sunter II', '2008', 'aktif', '5'
);

update data:
UPDATE `sistem_kuliah`.`mahasiswa`
SET `status` = 'tidak aktif'
WHERE `nim`= '0180000536';

delete:
DELETE FROM [tabel]
WHERE [kondisi];