Biodata Erna Selviyanti

Mengenai Saya

Foto saya
Nana Imut,,,asik,,,senang punya teman banyak, suka banget ma kucing hitam ^^

Senin, 04 Juli 2011

Data PKL part I

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 116
Server version: 5.5.8-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> describe data_kamera;
ERROR 1046 (3D000): No database selected
mysql> use db_survei;
Database changed
mysql> describe data_kamera;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| id_kamera | varchar(15) | NO | PRI | | |
| tanggal | date | NO | | NULL | |
| waktu | time | NO | | NULL | |
| file | varchar(40) | NO | | NULL | |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> describe data_gps;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_gps | varchar(15) | NO | PRI | NULL | |
| local_time | datetime | NO | | NULL | |
| longitude | int(11) | NO | | NULL | |
| latitude | int(11) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| ketinggian | int(11) | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)

mysql> describe data_spektroradiometer;
+-------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| id_radio | varchar(20) | NO | PRI | NULL | |
| tanggal | date | NO | | NULL | |
| waktu | time | NO | | NULL | |
| panjang_gelombang | int(11) | NO | | NULL | |
+-------------------+-------------+------+-----+---------+-------+
4 rows in set (0.02 sec)

mysql>





Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 161
Server version: 5.5.8-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_survei;
Database changed
mysql> describe tb_main;
+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| id_main | varchar(40) | NO | | NULL | |
| id_pengukuran | varchar(40) | NO | PRI | NULL | |
| nama | varchar(40) | NO | | NULL | |
| nama_pengukuran | varchar(40) | NO | | NULL | |
| waktu | datetime | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+-----------------+-------------+------+-----+---------+-------+
6 rows in set (0.02 sec)

mysql> describe tb_gps;
+---------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+-------------+------+-----+---------+-------+
| id_gps | varchar(30) | NO | PRI | NULL | |
| id_pengukuran | varchar(40) | NO | | NULL | |
| nama_lokasi | varchar(30) | NO | | NULL | |
| provinsi | varchar(30) | NO | | NULL | |
| kabupaten | varchar(30) | NO | | NULL | |
| kecamatan | varchar(30) | NO | | NULL | |
| kelurahan_atau_desa | varchar(30) | NO | | NULL | |
| tipe_lokasi | varchar(30) | NO | | NULL | |
| waktu_setempat | datetime | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| ketinggian | varchar(30) | NO | | NULL | |
| longitude | varchar(30) | NO | | NULL | |
| latitude | varchar(30) | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+---------------------+-------------+------+-----+---------+-------+
15 rows in set (0.02 sec)

mysql> describe tb_kamera;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_kamera | varchar(30) | NO | PRI | NULL | |
| id_gps | varchar(30) | NO | | NULL | |
| gambar_preview | blob | NO | | NULL | |
| file_gambar | varchar(30) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)

mysql> describe tb_spektroradiometer;
+----------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------+------+-----+---------+-------+
| id_spektroradiometer | varchar(30) | NO | PRI | NULL | |
| id_pengukuran | varchar(40) | NO | | NULL | |
| panjang_gelombang | varchar(30) | NO | | NULL | |
| nilai_digital | varchar(30) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)

mysql> alter table tb_gps MODIFY id_pengukuran VARCHAR(40) NOT NULL,ADD FOREIGN
KEY(id_pengukuran) REFERENCES tb_main(id_pengukuran);
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> describe tb_gps;
+---------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+-------------+------+-----+---------+-------+
| id_gps | varchar(30) | NO | PRI | NULL | |
| id_pengukuran | varchar(40) | NO | MUL | NULL | |
| nama_lokasi | varchar(30) | NO | | NULL | |
| provinsi | varchar(30) | NO | | NULL | |
| kabupaten | varchar(30) | NO | | NULL | |
| kecamatan | varchar(30) | NO | | NULL | |
| kelurahan_atau_desa | varchar(30) | NO | | NULL | |
| tipe_lokasi | varchar(30) | NO | | NULL | |
| waktu_setempat | datetime | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| ketinggian | varchar(30) | NO | | NULL | |
| longitude | varchar(30) | NO | | NULL | |
| latitude | varchar(30) | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+---------------------+-------------+------+-----+---------+-------+
15 rows in set (0.02 sec)

mysql> alter table tb_spektroradiometer MODIFY id_pengukuran VARCHAR(40) NOT NUL
L,ADD FOREIGN KEY(id_pengukuran) REFERENCES tb_main(id_pengukuran);
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> describe tb_spektroradiometer;
+----------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------+------+-----+---------+-------+
| id_spektroradiometer | varchar(30) | NO | PRI | NULL | |
| id_pengukuran | varchar(40) | NO | MUL | NULL | |
| panjang_gelombang | varchar(30) | NO | | NULL | |
| nilai_digital | varchar(30) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)

mysql> alter table tb_kamera MODIFY id_gps VARCHAR(30) NOT NULL,ADD FOREIGN KEY(
id_gps) REFERENCES tb_gps(id_gps);
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> describe tb_kamera;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| id_kamera | varchar(30) | NO | PRI | NULL | |
| id_gps | varchar(30) | NO | MUL | NULL | |
| gambar_preview | blob | NO | | NULL | |
| file_gambar | varchar(30) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)

mysql>




Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 316
Server version: 5.5.8-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_survei;
Database changed
mysql> describe tb_main;
+-----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+----------------+
| id_main | int(11) | NO | | NULL | |
| id_pengukuran | int(11) | NO | PRI | NULL | auto_increment |
| nama | varchar(30) | YES | | NULL | |
| nama_pengukuran | varchar(30) | NO | | NULL | |
| waktu | datetime | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+-----------------+-------------+------+-----+---------+----------------+
6 rows in set (0.01 sec)

mysql> describe tb_gps;
+---------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+-------------+------+-----+---------+----------------+
| id_gps | int(11) | NO | PRI | NULL | auto_increment |
| id_pengukuran | int(11) | NO | | NULL | |
| nama_lokasi | varchar(30) | NO | | NULL | |
| provinsi | varchar(30) | YES | | NULL | |
| kabupaten | varchar(30) | YES | | NULL | |
| kecamatan | varchar(30) | YES | | NULL | |
| kelurahan_atau_desa | varchar(30) | YES | | NULL | |
| tipe_lokasi | varchar(30) | NO | | NULL | |
| waktu_setempat | datetime | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| ketinggian | int(11) | NO | | NULL | |
| longitude | int(11) | NO | | NULL | |
| latitude | int(11) | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+---------------------+-------------+------+-----+---------+----------------+
15 rows in set (0.02 sec)

mysql> describe tb_kamera;
+----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+----------------+
| id_kamera | int(11) | NO | PRI | NULL | auto_increment |
| id_gps | int(11) | NO | | NULL | |
| gambar_preview | varchar(30) | YES | | NULL | |
| file_gambar | varchar(30) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------+-------------+------+-----+---------+----------------+
7 rows in set (0.02 sec)

mysql> describe tb_spektroradiometer;
+----------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------+------+-----+---------+----------------+
| id_spektroradiometer | int(11) | NO | PRI | NULL | auto_increment |
| id_pengukuran | int(11) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| panjang_gelombang | varchar(30) | NO | | NULL | |
| nilai_digital | varchar(30) | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------------+-------------+------+-----+---------+----------------+
7 rows in set (0.02 sec)

mysql> alter table tb_gps MODIFY id_pengukuran INT NOT NULL,ADD FOREIGN KEY(id_p
engukuran) REFERENCES tb_main(id_pengukuran);
Query OK, 0 rows affected (0.08 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> describe tb_gps;
+---------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+-------------+------+-----+---------+----------------+
| id_gps | int(11) | NO | PRI | NULL | auto_increment |
| id_pengukuran | int(11) | NO | MUL | NULL | |
| nama_lokasi | varchar(30) | NO | | NULL | |
| provinsi | varchar(30) | YES | | NULL | |
| kabupaten | varchar(30) | YES | | NULL | |
| kecamatan | varchar(30) | YES | | NULL | |
| kelurahan_atau_desa | varchar(30) | YES | | NULL | |
| tipe_lokasi | varchar(30) | NO | | NULL | |
| waktu_setempat | datetime | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| ketinggian | int(11) | NO | | NULL | |
| longitude | int(11) | NO | | NULL | |
| latitude | int(11) | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+---------------------+-------------+------+-----+---------+----------------+
15 rows in set (0.02 sec)

mysql> alter table tb_kamera MODIFY id_gps INT NOT NULL,ADD FOREIGN KEY(id_gps)
REFERENCES tb_main(id_gps);
ERROR 1005 (HY000): Can't create table 'db_survei.#sql-17e4_13c' (errno: 150)
mysql> alter table tb_kamera MODIFY id_gps INT NOT NULL,ADD FOREIGN KEY(id_gps)
REFERENCES tb_gps(id_gps);
Query OK, 0 rows affected (0.35 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> describe tb_kamera;
+----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+----------------+
| id_kamera | int(11) | NO | PRI | NULL | auto_increment |
| id_gps | int(11) | NO | MUL | NULL | |
| gambar_preview | varchar(30) | YES | | NULL | |
| file_gambar | varchar(30) | NO | | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------+-------------+------+-----+---------+----------------+
7 rows in set (0.02 sec)

mysql> alter table tb_spektroradiometer MODIFY id_pengukuran INT NOT NULL,ADD FO
REIGN KEY(id_pengukuran) REFERENCES tb_main(id_pengukuran);
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> describe tb_spektroradiometer;
+----------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------+------+-----+---------+----------------+
| id_spektroradiometer | int(11) | NO | PRI | NULL | auto_increment |
| id_pengukuran | int(11) | NO | MUL | NULL | |
| waktu | time | NO | | NULL | |
| tanggal | date | NO | | NULL | |
| panjang_gelombang | varchar(30) | NO | | NULL | |
| nilai_digital | varchar(30) | NO | | NULL | |
| waktu_update | datetime | NO | | NULL | |
+----------------------+-------------+------+-----+---------+----------------+
7 rows in set (0.02 sec)

mysql>



































































Diposting oleh di
Label:

0 komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)