buka cmd
c:
C:\apache\mysql\bin

mysql -u root ---> masuk mysql(30)''

--------------------------------

mysql> show databases;   --> melihat data base yang ada

mysql> create database;  --> membuat database

mysql> use (nama database); ---> memilih data base yang di inginkan

mysql> create table rpl (no int(30)not null,nama varchar(30)not null,jk varchar(
30)not null,kelas varchar(20)not null,primary key(no));    ---------------------------> perintah membuat Field

mysql>drop (nama table) -------> menghapus tabel



mysql>insert into rpl values('1','dede','laki-laki','XI'); ----------> memasukan data pada table
mysql> select no,nama,jk,kelas from rpl; -------------------> untuk menampilkan data base.,.,.

mysql> select*from dekurnia WHERE kelas='X'; => menampilkan data sesuai permintaan....

+----+------+-----------+-------+
| no | nama | jk        | kelas |
+----+------+-----------+-------+
|  4 | beno | perempuan | X     |
|  6 | uji  | laki-laki | X     |
+----+------+-----------+-------+
2 rows in set (0.00 sec)

mysql> select*from dekurnia WHERE kelas='XI';
+----+-------+-----------+-------+
| no | nama  | jk        | kelas |
+----+-------+-----------+-------+
|  3 | kur   | perempuan | XI    |
|  5 | iyonk | laki-laki | XI    |
+----+-------+-----------+-------+
2 rows in set (0.00 sec)



Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\dekur>cd\

C:\>cd apache

C:\apache>cd mysql

C:\apache\mysql>mysql -u root
'mysql' is not recognized as an internal or external command,
operable program or batch file.

C:\apache\mysql>cd bin

C:\apache\mysql\bin>mysql -u root
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\apache\mysql\bin>mysql.exe
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\apache\mysql\bin>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 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.00 sec)

mysql> create database dede
    -> ;
Query OK, 1 row affected (0.00 sec)

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

mysql> use dede;
Database changed
mysql> create database siswa;
Query OK, 1 row affected (0.00 sec)

mysql> use siswa;
Database changed
mysql> show databases;
+----------+
| Database |
+----------+
| dede     |
| mysql    |
| siswa    |
| test     |
+----------+
4 rows in set (0.00 sec)

mysql> use siswa;
Database changed
mysql> create table rpl (no(5)int not null auto_increment,nama(20)varchar not nu
ll,jk(20)varchar not null,kelas(30)varchar not null,primary key(no));
ERROR 1064: You have an error in your SQL syntax near '(5)int not null auto_incr
ement,nama(20)varchar not null,jk(20)varchar not null,k' at line 1
mysql> create table rpl (no int(30)not null,nama varchar(30)not null,jk varchar(
30)not null,kelas varchar(20)not null,primary key(no));
Query OK, 0 rows affected (0.07 sec)

mysql> select *.* rpl;
ERROR 1064: You have an error in your SQL syntax near '.* rpl' at line 1
mysql> select *. rpl;
ERROR 1064: You have an error in your SQL syntax near '. rpl' at line 1
mysql> select no,nama,jk,kelas from rpl;
Empty set (0.07 sec)

mysql> insert into rpl (1,'dede kurnia','laki-laki','XI';
ERROR 1064: You have an error in your SQL syntax near '1,'dede kurnia','laki-lak
i','XI'' at line 1
mysql> insert into rpl (1,'dede kurnia','laki-laki','XI');
ERROR 1064: You have an error in your SQL syntax near '1,'dede kurnia','laki-lak
i','XI')' at line 1
mysql> insert into rpl ('1','dede kurnia','laki-laki','XI');
ERROR 1064: You have an error in your SQL syntax near ''1','dede kurnia','laki-l
aki','XI')' at line 1
mysql> insert into rpl ('dede kurnia','laki-laki','XI');
ERROR 1064: You have an error in your SQL syntax near ''dede kurnia','laki-laki'
,'XI')' at line 1
mysql> create table rpl (no varchar(30)not null,nama varchar(30)not null,jk varc
har(30)not null,kelas varchar(20)not null,primary key(no));
ERROR 1050: Table 'rpl' already exists
mysql> drop table rpl;
Query OK, 0 rows affected (0.00 sec)

mysql> create table rpl (no varchar(30)not null,nama varchar(30)not null,jk varc
har(30)not null,kelas varchar(20)not null,primary key(no));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into rpl ('1','dede','laki-laki','XI');
ERROR 1064: You have an error in your SQL syntax near ''1','dede','laki-laki','X
I')' at line 1
mysql> insert into rpl '1','dede','laki-laki','XI';
ERROR 1064: You have an error in your SQL syntax near ''1','dede','laki-laki','X
I'' at line 1
mysql> insert into rpl values('1','dede','laki-laki','XI');
Query OK, 1 row affected (0.10 sec)

mysql> select *.* from rpl;
ERROR 1064: You have an error in your SQL syntax near '.* from rpl' at line 1
mysql> select *. from rpl;
ERROR 1064: You have an error in your SQL syntax near '. from rpl' at line 1
mysql> select .* from rpl;
ERROR 1064: You have an error in your SQL syntax near '* from rpl' at line 1
mysql> select no,nama,jk,kelas from rpl;
+----+------+-----------+-------+
| no | nama | jk        | kelas |
+----+------+-----------+-------+
| 1  | dede | laki-laki | XI    |
+----+------+-----------+-------+
1 row in set (0.00 sec)

mysql> select no,nama,jk from rpl;
+----+------+-----------+
| no | nama | jk        |
+----+------+-----------+
| 1  | dede | laki-laki |
+----+------+-----------+
1 row in set (0.00 sec)

mysql> select nama,jk from rpl;
+------+-----------+
| nama | jk        |
+------+-----------+
| dede | laki-laki |
+------+-----------+
1 row in set (0.00 sec)

mysql> delete siswa;
ERROR 1064: You have an error in your SQL syntax near 'siswa' at line 1
mysql> delete database siswa;
ERROR 1064: You have an error in your SQL syntax near 'database siswa' at line 1

mysql> cls
    ->
    -> :
    -> ;
ERROR 1064: You have an error in your SQL syntax near 'cls
:' at line 1
mysql> mysql> Aborted

C:\apache\mysql\bin>cd/

C:\>cd apache

C:\apache>cd mysql

C:\apache\mysql>cd bin

C:\apache\mysql\bin>mysql -u root
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 |
+----------+
| dede     |
| mysql    |
| siswa    |
| test     |
+----------+
4 rows in set (0.00 sec)

mysql> create database dekur
    -> ;
Query OK, 1 row affected (0.01 sec)

mysql> show databases
    -> ;
+----------+
| Database |
+----------+
| dede     |
| dekur    |
| mysql    |
| siswa    |
| test     |
+----------+
5 rows in set (0.00 sec)

mysql> uses dekur
    -> ;
ERROR 1064: You have an error in your SQL syntax near 'uses dekur' at line 1
mysql>