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>