contoh sederhana pembuatan database menggunakan query analizer

drop table if exists data_pulsa;
drop table if exists data_pelanggan;
drop table if exists data_transaksi;
drop table if exists data_user;
create table data_pulsa(
kode varchar(5) not null,
jenis varchar(3) not null,
kategori varchar(11) not null,
judul varchar(50) not null,
status varchar(11) not null,
harga int(11) not null,
primary key(kode)

)
type=InnoDB;

create table data_pelanggan(
id varchar(11) not null,
nama varchar(50) not null,
alamat varchar(50) not null,
jaminan varchar(11) not null,
primary key(id)
)
type=InnoDB;

create table data_transaksi(
id int(11) not null,
kode varchar(5) not null,
tgl_transaksi varchar(11) not null,
tgl_pembayaran varchar(11) not null,
harga int(5) not null,
keterangan varchar(11) not null,
judul varchar(50) not null,
jaminan varchar(11) not null
)
type=InnoDB;

create table data_user(
nama varchar(50),
password text
)
type=InnoDB;