PERINTAH INSERT

 DML(Data Manipulation Language)

A. Pengertian DML

    DML(Data Manipulation Language) adalah Sub-bahasa SQL yang digunakan untuk....

1. CD C://xampp/mysql/bin

2. C:\xampp\mysql\bin>mysql -u root -p

3. MariaDB [(none)]> show databases;

4. MariaDB [(none)]> use db_smk;

5. MariaDB [db_smk]> show tables;

6. MariaDB [db_smk]> INSERT INTO tb_siswa 

   VALUES('123','Aan','Laki-laki','Pandeglang','2005-11-30','Siti');

7. MariaDB [db_smk]> INSERT INTO tb_siswa(nis,nama,jenis_kelamin,nama_ibukandung)

   VALUES('124','Iin','Perempuan','Ani');

6. MariaDB [db_smk]> INSERT INTO tb_siswa 

   VALUES('125','Nama_sendir','Laki-laki','Pandeglang','2005-11-30','ibu');