LEARNING DATABASE (SQLSERVER QUERY) PART.5

SUMMARY [Part.2]

B. DATA MANIPULATION LANGUAGE

1. Insert

Format:

use [DATABASE_NAME];

insert into [TABLE_NAME] ([COLUMN_NAME_1], [COLUMN_NAME_2],...) values

([VALUE_OF_COLUMN_NAME_1], [VALUE_OF_COLUMN_2],...);

    Example:

    USE nilaiSiswa;

    INSERT INTO matkul (kodeMatkul, namaMatkul, sks) VALUES ('MK001', 'Networking', 4);

2. Update

Format:

use [DATABASE_NAME];

update [TABLE_NAME] set [COLUMN_NAME]=[VALUE] where [CONDITION];

    Example:

    USE nilaiSiswa;

    UPDATE matkul SET namaMatkul='Web Programming' WHERE kodeMatkul='MK001';

3. Delete

Format:

use [DATABASE_NAME];

delete from [TABLE_NAME] where [CONDITION](s);

    Example:

    USE nilaiSiswa;

    DELETE FROM matkul WHERE sks < 4 OR sks > 2;

4. Select

Format:

use [DATABASE_NAME];

select [distinc/*] [COLUMN_NAME] from [TABLE_NAME]

where [CONDITION]

group by [COLUMN_LIST]

having [CONDITION]

order by [COLUMN_LIST] [ASC/DESC]

    Example:

    USE nilaiSiswa;

    SELECT DISTINC username FROM username WHERE userStatusId=1

    AND userClassId <> 'ADM' ORDER BY username ASC;