mysql

mysql adalah sebuah database bukan termasuk dalam kategori OS, untuk menjalankanya diperlukan sebuah syntaks.berikut adalah contoh syntaks dalam membuat database mahasiswa:
1.show databases; (menampilkan database)
2.create database db_19; (membuat database anda)
3.show databases; (menampilkan database)
4.use db_19;
5.create database db_19; (membuat database anda)
6.create table mhs (nama char (23) not null); (membuat table mhs)
7.show tables; (menampilkan table)
8.desc mhs;
9.drop table mhs; (menghapus table mhs)
10.create table datagw (nama varchar (30), notel char(9) not null, primary key(notel));
11.desc datagw;
12.insert into datagw values ('sarmoko','99957831'); (input data)
13.select * from datagw; (menampilkan semua data)



database barang:
-create database barang;
-use barang;
-create table barang (nama_barang varchar (20), kode_barang char (4), jml_barang int(3));
-create table harga 9kode_barang char(4), harga int (5));
-insert into barang values ('baju','0011,100), ('tas','0012',50);

menggabungkan dua table menhadi satu table:
-select barang.nama_barang, harga.harga_satuan from barang.barang, harga where barang.kode_barang = harga.kode_barang;

menghapus data yang sudah di input:
-delete from barang where nama_barang = 'sepatu';

update harga:
-update harga set harga =30.000 where kode_barang ='0012';


demikian tulisan yang saya buat, semoga bermanfaat untuk semuanya, jika ada kekurangan pada tulisan mohon komentarnya, jangan ragu-ragu dan jangan bimbang kalo bingung ya pegangan, aaaaaaaaaaaa.

quotation letter

May01, 2008




We have completed a preliminary loan analysis and are proposing financing in the amount stated
below and on the following general terms and conditions.

Loan Quote Information

Loan Name Multifamily Sample

Requested Loan Amount $ 1,530,000

Schedule of Proposed Loan Terms

Loan Amount $ 1,520,000

Loan Term (yrs) 10

Amortization (yrs) 30

Interest Rate Spread 2. 150%

Current Index Yield 5. 150%

Final Note Rate 7.300%

Interest Rate Index 10 Yr US Treasury

Loan Type Fixed


Interest Accrual Actual 360

M h d
Proposed DSCR 1.23

Proposed LTV 80.0%


This is a summary of our preliminary analysis based on the information provided. Based on your level of interest, we would be pleased to provide you with additional information. Please contact me with your comments.



Sincerely,