Cara membuat database dengan MYSQL
- Dapatkan link
- Aplikasi Lainnya
Langkah Langkah Membuat Database penjualan dengan MYSQL
Langsung saja tidak usa bertele-tele dan panjang lebar silahkan ikuti step by stepnya
Tekan tombol Windows+R
lalu ketik cmd dan tekan enter
selanjutkan silahkan ketik perintah berikut
cd c:/xampp//mysql/bin/
mysql -u root -p
Enter password:====================>bilah tidak punya pass tekan enter
show databases;
create database penjualan;
Query OK, 1 row affected (0.00 sec)
show databases;
+--------------------+
| Database |
+--------------------+
| 3g_nokia |
| dbretail |
| information_schema |
| mysql |
| penjualan |
| performance_schema |
| phpmyadmin |
| stripbandunk_toko |
| test |
| zero traffic |
+--------------------+
10 rows in set (0.00 sec)
use penjualan;
Database changed
create table tbl_jenis(kode_jenis varchar(4),jenis varchar(100),primary key(kode_jenis));
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_jenis |
+---------------------+
1 row in set (0.00 sec)
describe tbl_jenis;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| kode_jenis | varchar(4) | NO | PRI | NULL | |
| jenis | varchar(100) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
create table tbl_petugas(id_petugas varchar(4),nama_petugas varchar(100),alamat varchar(100),email varchar(80),telepon varchar(14),primary key(id_petugas));
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_jenis |
| tbl_petugas |
+---------------------+
2 rows in set (0.00 sec)
describe tbl_petugas;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| id_petugas | varchar(4) | NO | PRI | NULL | |
| nama_petugas | varchar(100) | YES | | NULL | |
| alamat | varchar(100) | YES | | NULL | |
| email | varchar(80) | YES | | NULL | |
| telepon | varchar(14) | YES | | NULL | |
+--------------+--------------+------+-----+---------+-------+
5 rows in set (0.01 sec)
create table tbl_distributor(id_distributor varchar(4),nama_distributor varchar(100),alamat varchar(100),kota_asal varchar(80),email varchar(80),telepon varchar(14),primary key(id_distributor));
Query OK, 0 rows affected (0.18 sec)
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+---------------------+
3 rows in set (0.00 sec)
describe tbl_distributor;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id_distributor | varchar(4) | NO | PRI | NULL | |
| nama_distributor | varchar(100) | YES | | NULL | |
| alamat | varchar(100) | YES | | NULL | |
| kota_asal | varchar(80) | YES | | NULL | |
| email | varchar(80) | YES | | NULL | |
| telepon | varchar(14) | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
create table tbl_barang(kode_brg varchar(4),nama_brg varchar(100),kode_jenis varchar(4),harga_net double,harga_jual double,stok smallint,primary key(kode_brg));
Query OK, 0 rows affected (0.19 sec)
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_barang |
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+---------------------+
4 rows in set (0.00 sec)
describe tbl_barang;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| kode_brg | varchar(4) | NO | PRI | NULL | |
| nama_brg | varchar(100) | YES | | NULL | |
| kode_jenis | varchar(4) | YES | | NULL | |
| harga_net | double | YES | | NULL | |
| harga_jual | double | YES | | NULL | |
| stok | smallint(6) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
create table tbl_brg_masuk(no_nota varchar(10),tgl_brg_masuk date,id_distributor varchar(4),id_petugas varchar(4),total double,primary key(no_nota));
Query OK, 0 rows affected (0.18 sec)
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+---------------------+
5 rows in set (0.00 sec)
describe tbl_brg_masuk;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| no_nota | varchar(10) | NO | PRI | NULL | |
| tgl_brg_masuk | date | YES | | NULL | |
| id_distributor | varchar(4) | YES | | NULL | |
| id_petugas | varchar(4) | YES | | NULL | |
| total | double | YES | | NULL | |
+----------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)
create table tbl_detail_brg_masuk(no_nota varchar(10),kode_brg varchar(4),jumlah smallint,subtotal double);
Query OK, 0 rows affected (0.22 sec)
show tables;
+----------------------+
| Tables_in_penjualan |
+----------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_detail_brg_masuk |
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+----------------------+
6 rows in set (0.00 sec)
describe tbl_detail_brg_masuk;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| no_nota | varchar(10) | NO | | NULL | |
| kode_brg | varchar(4) | NO | | NULL | |
| jumlah | smallint(6) | YES | | NULL | |
| subtotal | double | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
create table tbl_penjualan(no_faktur varchar(10),tgl_penjualan date,id_petugas varchar(4),bayar double,sisa double,total double,primary key(no_faktur));
Query OK, 0 rows affected (0.22 sec)
show tables;
+----------------------+
| Tables_in_penjualan |
+----------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_detail_brg_masuk |
| tbl_distributor |
| tbl_jenis |
| tbl_penjualan |
| tbl_petugas |
+----------------------+
7 rows in set (0.00 sec)
describe tbl_penjualan;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| no_faktur | varchar(10) | NO | PRI | NULL | |
| tgl_penjualan | date | YES | | NULL | |
| id_petugas | varchar(4) | YES | | NULL | |
| bayar | double | YES | | NULL | |
| sisa | double | YES | | NULL | |
| total | double | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
create table tbl_detail_penjualan(no_faktur varchar(10),kode_brg varchar(4),jumlah smallint,sub_total double);
Query OK, 0 rows affected (0.22 sec)
show tables;
+----------------------+
| Tables_in_penjualan |
+----------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_detail_brg_masuk |
| tbl_detail_penjualan |
| tbl_distributor |
| tbl_jenis |
| tbl_penjualan |
| tbl_petugas |
+----------------------+
8 rows in set (0.00 sec)
describe tbl_detail_penjualan;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| no_faktur | varchar(10) | YES | | NULL | |
| kode_brg | varchar(4) | YES | | NULL | |
| jumlah | smallint(6) | YES | | NULL | |
| sub_total | double | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
Sekian Tutorial ini lebih dan kurangnya mohon di ma,afkan
Langsung saja tidak usa bertele-tele dan panjang lebar silahkan ikuti step by stepnya
Tekan tombol Windows+R
lalu ketik cmd dan tekan enter
selanjutkan silahkan ketik perintah berikut
cd c:/xampp//mysql/bin/
mysql -u root -p
Enter password:====================>bilah tidak punya pass tekan enter
show databases;
create database penjualan;
Query OK, 1 row affected (0.00 sec)
show databases;
+--------------------+
| Database |
+--------------------+
| 3g_nokia |
| dbretail |
| information_schema |
| mysql |
| penjualan |
| performance_schema |
| phpmyadmin |
| stripbandunk_toko |
| test |
| zero traffic |
+--------------------+
10 rows in set (0.00 sec)
use penjualan;
Database changed
create table tbl_jenis(kode_jenis varchar(4),jenis varchar(100),primary key(kode_jenis));
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_jenis |
+---------------------+
1 row in set (0.00 sec)
describe tbl_jenis;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| kode_jenis | varchar(4) | NO | PRI | NULL | |
| jenis | varchar(100) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
create table tbl_petugas(id_petugas varchar(4),nama_petugas varchar(100),alamat varchar(100),email varchar(80),telepon varchar(14),primary key(id_petugas));
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_jenis |
| tbl_petugas |
+---------------------+
2 rows in set (0.00 sec)
describe tbl_petugas;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| id_petugas | varchar(4) | NO | PRI | NULL | |
| nama_petugas | varchar(100) | YES | | NULL | |
| alamat | varchar(100) | YES | | NULL | |
| email | varchar(80) | YES | | NULL | |
| telepon | varchar(14) | YES | | NULL | |
+--------------+--------------+------+-----+---------+-------+
5 rows in set (0.01 sec)
create table tbl_distributor(id_distributor varchar(4),nama_distributor varchar(100),alamat varchar(100),kota_asal varchar(80),email varchar(80),telepon varchar(14),primary key(id_distributor));
Query OK, 0 rows affected (0.18 sec)
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+---------------------+
3 rows in set (0.00 sec)
describe tbl_distributor;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id_distributor | varchar(4) | NO | PRI | NULL | |
| nama_distributor | varchar(100) | YES | | NULL | |
| alamat | varchar(100) | YES | | NULL | |
| kota_asal | varchar(80) | YES | | NULL | |
| email | varchar(80) | YES | | NULL | |
| telepon | varchar(14) | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
create table tbl_barang(kode_brg varchar(4),nama_brg varchar(100),kode_jenis varchar(4),harga_net double,harga_jual double,stok smallint,primary key(kode_brg));
Query OK, 0 rows affected (0.19 sec)
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_barang |
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+---------------------+
4 rows in set (0.00 sec)
describe tbl_barang;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| kode_brg | varchar(4) | NO | PRI | NULL | |
| nama_brg | varchar(100) | YES | | NULL | |
| kode_jenis | varchar(4) | YES | | NULL | |
| harga_net | double | YES | | NULL | |
| harga_jual | double | YES | | NULL | |
| stok | smallint(6) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
create table tbl_brg_masuk(no_nota varchar(10),tgl_brg_masuk date,id_distributor varchar(4),id_petugas varchar(4),total double,primary key(no_nota));
Query OK, 0 rows affected (0.18 sec)
show tables;
+---------------------+
| Tables_in_penjualan |
+---------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+---------------------+
5 rows in set (0.00 sec)
describe tbl_brg_masuk;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| no_nota | varchar(10) | NO | PRI | NULL | |
| tgl_brg_masuk | date | YES | | NULL | |
| id_distributor | varchar(4) | YES | | NULL | |
| id_petugas | varchar(4) | YES | | NULL | |
| total | double | YES | | NULL | |
+----------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)
create table tbl_detail_brg_masuk(no_nota varchar(10),kode_brg varchar(4),jumlah smallint,subtotal double);
Query OK, 0 rows affected (0.22 sec)
show tables;
+----------------------+
| Tables_in_penjualan |
+----------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_detail_brg_masuk |
| tbl_distributor |
| tbl_jenis |
| tbl_petugas |
+----------------------+
6 rows in set (0.00 sec)
describe tbl_detail_brg_masuk;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| no_nota | varchar(10) | NO | | NULL | |
| kode_brg | varchar(4) | NO | | NULL | |
| jumlah | smallint(6) | YES | | NULL | |
| subtotal | double | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
create table tbl_penjualan(no_faktur varchar(10),tgl_penjualan date,id_petugas varchar(4),bayar double,sisa double,total double,primary key(no_faktur));
Query OK, 0 rows affected (0.22 sec)
show tables;
+----------------------+
| Tables_in_penjualan |
+----------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_detail_brg_masuk |
| tbl_distributor |
| tbl_jenis |
| tbl_penjualan |
| tbl_petugas |
+----------------------+
7 rows in set (0.00 sec)
describe tbl_penjualan;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| no_faktur | varchar(10) | NO | PRI | NULL | |
| tgl_penjualan | date | YES | | NULL | |
| id_petugas | varchar(4) | YES | | NULL | |
| bayar | double | YES | | NULL | |
| sisa | double | YES | | NULL | |
| total | double | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
create table tbl_detail_penjualan(no_faktur varchar(10),kode_brg varchar(4),jumlah smallint,sub_total double);
Query OK, 0 rows affected (0.22 sec)
show tables;
+----------------------+
| Tables_in_penjualan |
+----------------------+
| tbl_barang |
| tbl_brg_masuk |
| tbl_detail_brg_masuk |
| tbl_detail_penjualan |
| tbl_distributor |
| tbl_jenis |
| tbl_penjualan |
| tbl_petugas |
+----------------------+
8 rows in set (0.00 sec)
describe tbl_detail_penjualan;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| no_faktur | varchar(10) | YES | | NULL | |
| kode_brg | varchar(4) | YES | | NULL | |
| jumlah | smallint(6) | YES | | NULL | |
| sub_total | double | YES | | NULL | |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
Sekian Tutorial ini lebih dan kurangnya mohon di ma,afkan
- Dapatkan link
- Aplikasi Lainnya
Postingan populer dari blog ini
Komponen Utama Komputer
Komponen Utama Komputer Komponen-komponen komputer yang melekat dalam komputer personal merupakan benda penting yang bisa dikatakan sebagai nyawa dari komputer kita. Tanpa adanya salah satu dari komponen-komponen komputer berikut ini, komputer tidak akan dapat beroperasi dengan baik, malah kadang tidak dapat berfungsi sama sekali. Agar dapat menjaga komputer anda dalam kondisi baik, ada baiknya kita mengenal lebih akrab komponen-komponen komputer beserta fungsinya. Komponen Utama dalam Komputer Komponen pertama yang perlu kita kenal adalah motherboard. Motherboard merupakan komponen perangkat keras atau hardware paling penting dari seluruh komponen lain;di sinilah komponen penting lainnya terpasang, seperti hard disk, prosessor, memori, dan lainnya. Prosesor adalah bagian dari komponen komputer yang bertugas sebagai otak mesin. Ada pula RAM yang merupakan komponen yang bertugas menyimpan data sementara dari program yang tengah dijalankan. Video card dan sound card menjad
Hitung nilai mahasiswa pascal
Hitung nilai kehadiran mahasiswa pascal program hitung_nilai; var Np:string[6]; Nama:string[30]; NK1,NK2,NK3,NK4,NK5,NK6,NK7,NK8,NK9,NK10,NK11,NK12,NK13,NK14,NK15,TH,NT1,NT2,NT3,NT4,NT5,TT,NM,NF:integer; TNK,TNT,NA:Real; NH:char; begin writeln('menghitung nilai akhir'); write('masukan no pokok:'); readln(NP); write('masukan nama:'); readln(Nama); write('masukan nilai kehadiran ke 1='); read(NK1); write('masukan nilai kahadiran ke 2='); read(NK2); write('masukan nilai kehadiran ke 3='); read(NK3); write('masukan nilai kehadiran ke 4='); read(NK4); write('masukan nilai kehadiran ke 5='); read(NK5); write('masukan nilai kehadiran ke 6='); read(NK6); write('masukan nilai kehadiran ke 7='); read(NK7); write('masukan nilai kehadiran ke 8='); read(NK8); write('masukan nilai kehadiran ke 9='); read(NK9); write('masukan nilai kehadiran ke 10=');read(NK10); wr
Turbo pascal hitung nilai mahasiswa
Program Hitung Nilai Mahasiswa dengan Turbo Pascal program data_mahasiswa; uses crt; type mahasiswa=record nim:string; nama:string; presnsi,uas,uts,tugas:integer; nilai:real; grade:char; end; var mhs:array [1..10] of mahasiswa; i,j,x:integer; jml:integer; kode_mk:integer; nama_mk:string; begin clrscr; j:=0; writeln(‘=====================================’); writeln(‘ PROGRAM HITUNG NILAI ‘); writeln(‘=====================================’); write(‘Masukan Jumlah Data : ‘);readln(jml); write(‘Masukan Kode Matakuliah : ‘);readln(kode_mk); writeln; if kode_mk =151 then begin nama_mk:=’Algoritma & Pemograman’; end else if kode_mk=422 then begin nama_mk:=’Linux 1′; end else if kode_mk=733 then begin nama_mk:=’PPN II (Access)’; end else if kode_mk=772 then begin nama_mk:=’DBMS’; end else begin nama_mk:=”; end; if jml>10 then begin writeln(‘Melebihi Kapasitas’); end else begin for i:=1 to jml do begin with mhs[i] do begin write(‘Nilai ke- ‘,i,’ dari ‘,jml);