Tutorial Instal VB6 pada windows 10 Tanpa eror
Cara membuat database dengan MYSQL
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
Postingan populer dari blog ini
DASAR DASAR HTML
Elemen-elemen h1,h2,h3,h4,h5,h6 adalah elemen headings ( h = heading ). Dimana h1 adalah adalah tingkat pertama dan teks dari h1 adalah yg terbesar diikuti oleh h2 hingga h6 yang merupakan elemen headings yang terakhir. Heading 1 Heading 2 Heading 3 Heading 4 Heading 5 Heading Browser secara otomatis menambahkan satu bagian kosong/empty space pada setiap heading. Kode dari tampilan headings di atas : Codingku HTML Editori <html> <body> <h1>Heading 1</h1> <h2>Heading 2</h2> <h3>Heading 3</h3> <h4>Heading 4</h4> <h5>Heading 5</h5> <h6>Heading 6</h6> </body> </html> Elemen <Title> digunakan untuk menyatakan judul sebuah halaman web. Posisinya berada di dalam elemen <head>. <html> <head> <title>Judul Ha...
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 ca...
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...