DML itself is a collection of SQL statements that relate to the work process the data in the table - and not associated with changes in the structure and data type definitions of database objects such as table, column, and so forth.
Examples of DML: Taking All the Row Data from table MS_KARYAWAN
SELECT *
FROM ms_karyawan
DML Example: Inserting data into tables ms_karyawan
INSERT INTO ms_karyawan (
kode_cabang,
kode_karyawan,
first_name,
last_name,
jenis_kelamin)
VALUES ('cab-001', 'kar-001', 'Perizzites', 'Thia', 'Male');
Some DML Commands list MySQL 5.0
CALL
DELETE
DO
HANDLER
INSERT
LOAD DATA INFILE
REPLACE
SELECT
TRUNCATE
UPDATE
Tidak ada komentar:
Posting Komentar