Rabu, 13 Juni 2012

DML - Data Manipulation Language

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