Belajar adalah cermin masa depan: Langkah Membuat Program MYSQL

LANGKAH PERTAMA YANG ANDA HARUS LAKUKANDari Menu Start Pilih Dulu Php Triad Aktifkan Start Apache Dan MySQL- D-NT

KEMUDIAN BUKA Command Prompt Kalo bingung Tekan Ctr + r (ketikan cmd) maka akan muncul Secara Otomotis

Ni Sintaknya

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.47-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.02 sec)
Apa bila Tampilnya seperti di atas maka tahap pertama anda berhasil dan silakan lakukan sintak berikutnya
mysql> create database db_remedial; (Create untuk membuat database)
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+-------------+
| Database    |
+-------------+
| db_remedial |
| mysql       |
| test        |
+-------------+
3 rows in set (0.00 sec)

mysql> use db_remedial (use untuk mengaktifkan database yang anda inginkan)
Database changed
mysql> create table mahasiswa
    -> (npm varchar(10),
    -> nama varchar(30),
    -> alamat varchar(100));
Query OK, 0 rows affected (0.03 sec)

mysql> desc mahasiswa; (Desc Untuk Menampilkan table)
+--------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| npm    | varchar(10) | YES |     | NULL    |       |
| nama   | varchar(30) | YES |     | NULL    |       |
| alamat | varchar(100) | YES |     | NULL    |       |
+--------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> alter table mahasiswa
    -> add no int(11) first;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table mahasiswa
    -> add notlp varchar(12) after alamat;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> desc mahasiswa;
+--------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| no     | int(11)      | YES |     | NULL    |       |
| npm    | varchar(10) | YES |     | NULL    |       |
| nama   | varchar(30) | YES |     | NULL    |       |
| alamat | varchar(100) | YES |     | NULL    |       |
| notlp | varchar(12) | YES |     | NULL    |       |
+--------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> alter table mahasiswa
    -> change nama namamahasiswa varchar(30);
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> desc mahasiswa;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| no            | int(11)      | YES |     | NULL    |       |
| npm           | varchar(10) | YES |     | NULL    |       |
| namamahasiswa | varchar(30) | YES |     | NULL    |       |
| alamat        | varchar(100) | YES |     | NULL    |       |
| notlp         | varchar(12) | YES |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> insert into mahasiswa
    -> (no,npm,namamahasisawa,alamat,notlp)
    -> values
    -> )'1'0801231236','sarif hidayat','palapa','0812312345');
    '> alter table mahasiswa
    mysql> insert into mahasiswa
    -> (no,npm,namamahasiswa,alamat,notlp)
    -> values
    -> ('1','0801231236','sarif hidayat','palapa','0812312345');
Query OK, 1 row affected (0.00 sec)

+------+------------+---------------+--------+------------+
| no   | npm        | namamahasiswa | alamat | notlp      |
+------+------------+---------------+--------+------------+
|    1 | 0801231236 | sarif hidayat | palapa | 0812312345 |
+------+------------+---------------+--------+------------+
1 row in set (0.02 sec)

mysql> insert into mahasiswa
    -> (no,npm,namamahasiswa,alamat,notlp)
    -> values
    -> )'1','0478123','akuan koplo','belakang ubl','0789555');
ERROR 1064: You have an error in your SQL syntax near ')'1','0478123','akuan kop
lo','belakang ubl','0789555')' at line 4
mysql> insert into mahasiswa
    -> (no,npm,namamahasiswa,alamat,notlp)
    -> values
    -> ('2','0691231236','akuan koplo','ubl','085622345');
Query OK, 1 row affected (0.00 sec)

mysql> select * from mahasisawa;
ERROR 1146: Table 'db_remedial.mahasisawa' doesn't exist
mysql> select * from mahasiswa;
+------+------------+---------------+--------+------------+
| no   | npm        | namamahasiswa | alamat | notlp      |
+------+------------+---------------+--------+------------+
|    1 | 0801231236 | sarif hidayat | palapa | 0812312345 |
|    2 | 0691231236 | akuan koplo   | ubl    | 085622345 |
+------+------------+---------------+--------+------------+
2 rows in set (0.00 sec)

mysql> insert into mahasiswa
    -> (no,npm,namamahasiswa,alamat,notlp)
    -> values
    -> ('3','066551236','andres','kandis','0819500123');
Query OK, 1 row affected (0.00 sec)

mysql> insert into mahasiswa
    -> (no,npm,namamahasiswa,alamat,notlp)
    -> values
    -> ('4','099912300','nanang koplo','tataan','08456123');
Query OK, 1 row affected (0.02 sec)

mysql> insert into mahasiswa
    -> (no,npm,namamahasiswa,alamat,notlp)
    -> values
    -> ('5','89223000','yudi koplo','pelita','0813708800910');
Query OK, 1 row affected (0.00 sec)

mysql> select * from mahasiswa;
+------+------------+---------------+--------+--------------+
| no   | npm        | namamahasiswa | alamat | notlp        |
+------+------------+---------------+--------+--------------+
|    1 | 0801231236 | sarif hidayat | palapa | 0812312345   |
|    2 | 0691231236 | akuan koplo   | ubl    | 085622345    |
|    3 | 066551236 | andres        | kandis | 0819500123   |
|    4 | 099912300 | nanang koplo | tataan | 08456123     |
|    5 | 89223000   | yudi koplo    | pelita | 081370880091 |
+------+------------+---------------+--------+--------------+
5 rows in set (0.00 sec)

mysql>