SELAMAT DATANG DI BLOG SAYA..

Kamis, 14 Februari 2013

MEMBUAT DATABASE MENGGUNAKAN MYSQL

Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

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

mysql>
mysql> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| amik_universal_medan |
| db_mahasiswa         |
| mahasiswa            |
| mahasiswa_ti         |
| mysql                |
| tgit                 |
+----------------------+
7 rows in set (0.00 sec)

mysql> use amik_universal_medan;
Database changed
mysql> create table tempat_tinggal(nama  varchar(20),nim varchar(10),jurusan cha
r(2),alamat varchar(30),lintang double,bujur double));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
 line 1
mysql>
mysql> create table tempat_tinggal(nama  varchar(20),nim varchar(10),jurusan cha
r(2),alamat varchar(30),lintang varchar(4),bujur varchar(4));
Query OK, 0 rows affected (0.11 sec)

mysql> describe tempat_tinggal;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| nama    | varchar(20) | YES  |     | NULL    |       |
| nim     | varchar(10) | YES  |     | NULL    |       |
| jurusan | char(2)     | YES  |     | NULL    |       |
| alamat  | varchar(30) | YES  |     | NULL    |       |
| lintang | varchar(4)  | YES  |     | NULL    |       |
| bujur   | varchar(4)  | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

mysql> insert into tempat_tinggal(nama,nim,jurusan,alamat,lintang,bujur) values(
'sehukuur','100310003','ti','jl.plamboyan','s','t');
Query OK, 1 row affected (0.00 sec)

mysql> select * from tempat_tinggal;
+----------+-----------+---------+--------------+---------+-------+
| nama     | nim       | jurusan | alamat       | lintang | bujur |
+----------+-----------+---------+--------------+---------+-------+
| sehukuur | 100310003 | ti      | jl.plamboyan | s       | t     |
+----------+-----------+---------+--------------+---------+-------+
1 row in set (0.00 sec)

mysql> insert into tempat_tinggal(nama,nim,jurusan,alamat,lintang,bujur) values(
'yuki','100310001','ti','jl.plamboyan','0,91','1049');
Query OK, 1 row affected (0.00 sec)

mysql> insert into tempat_tinggal(nama,nim,jurusan,alamat,lintang,bujur) values(
'alim','100310003','ti','jl.seta budi','0,90','1041');
Query OK, 1 row affected (0.00 sec)

mysql> insert into tempat_tinggal(nama,nim,jurusan,alamat,lintang,bujur) values(
'niko','100310012','ti','simalingkar b','0,93','10401');
Query OK, 1 row affected, 1 warning (1.45 sec)

mysql> insert into tempat_tinggal(nama,nim,jurusan,alamat,lintang,bujur) values(
'anju','100310032','ti','gg.setia budi','1,21','1040');
Query OK, 1 row affected (0.00 sec)

mysql> select * from tempat_tinggal;
+----------+-----------+---------+---------------+---------+-------+
| nama     | nim       | jurusan | alamat        | lintang | bujur |
+----------+-----------+---------+---------------+---------+-------+
| sehukuur | 100310003 | ti      | jl.plamboyan  | s       | t     |
| yuki     | 100310001 | ti      | jl.plamboyan  | 0,91    | 1049  |
| alim     | 100310003 | ti      | jl.seta budi  | 0,90    | 1041  |
| niko     | 100310012 | ti      | simalingkar b | 0,93    | 1040  |
| anju     | 100310032 | ti      | gg.setia budi | 1,21    | 1040  |
+----------+-----------+---------+---------------+---------+-------+
5 rows in set (0.00 sec)

mysql>